Does anybody know how to create a VBA code to automatically extract all the active data in a sheet on a different workbook without opening and manually copying to a different workbook? Ps also to create a reference cell to be able to change the file name and run macro so that it can use the reference cell to find the file and copy..

Asking for a friend who is a 2L in a New York law school, given the current coronavirus situation, how are firms handling summer internships, if any are hiring?

Over the last few weeks I feel like every headline I read is about layoffs across various companies and industries… except consulting. Why are consulting firms still hiring strong? Aren’t they suppose to be the first ones to lay people off?

Hello people of San Diego! Would love to hear how y’all are affording to live here comfortably. Please state your company, position, TC, YOE, and do you have a side hustle? I’ll start - I’m an advisor in Wealth Management with TC of $70k, 3 YOE and no side hustle. Among other things, rent just jumped from $2500 to $3700 for 2 bedroom and areas were looking at. I’d like to “make it” here but if it means switching career to make money I’d like to get an idea to make the right job change.

It seems like a lot of agencies, when hiring, only consider people who have already had agency experience (according to job posts I see). I’ve been designing a while, but haven’t worked full time at one. Obviously your work needs to be good. But any other thoughts/tips on breaking in? Thanks!

I have an interview with PeopleShare tomorrow for a remote recruiter position. Does anyone have any information on the interview process, or what kind of salary they offer for entry level remote recruiters? Thanks!!!

Currently in a full time role at an RPO but have a potential offer in house on a 6-9 month contract with strong possibility of conversion at Hubspot. Pay is $15k higher than I make now. Would it be a bad decision to take the contract / contract to hire? I don’t doubt my ability to get converted, but the entire market is seeing huge layoffs so it makes me a little nervous. Thoughts?

Hi Peeps I just cleared 3 rounds of interview with the Accenture Toronto Team for a Banking Strategy Manager position under Strategy & Consulting practice. Can anyone please tell me the base pay range? I have a call with the recruiter tomorrow to discuss expectations. My research online says 150-165k CAD. Is this accurate? Thank you!

Anyone have anything to say about Nestle culture? Looking for dmv industry exit- would prefer capital one (heard great things) but am much more aligned with a handful of Nestle postingsHeard not great

Hi, how is the work life balance and job security in Infosys?
Which location is the best for the AWS role?

sales opening in USA

Hi all, I have an offer in hand from Coforge (20+1) and indegene (22+1). Confused which one to go for as both are offering IT delivery role.

Hello Fishes,
I am selected for Data Engineer L4 role in Amazon. What is the fixed base pay i can expect to get realistically?

Hey! I created a bowl for DEIB practitioners and employers/hiring managers who need contractors or candidates .

After my first HR round the recruiter decided to speak with seniors and find out if they will consider me for a senior position. (This took 2 weeks)

I had two technical round, at the end of the second round I was told that someone else also needs to also take your interview. (This tools 3 weeks)

HR to decide who will this person be.

It's been two weeks since my last interview. Still waiting to heard back from the Reciter. It's this normal? What should I do next?

I need a reference from NCR for a QA position, is anyone from NCR here?

Can anyone with direct knowledge about VILLAGEMD let me know what they think about the company's headcount planning strategies (hiring blitz vs strategically planned out). And what the culture is … more

What jobs to expect after working as transaction risk investigator for a year at Amazon?? And how to get any job

Do TCS blacklist if we accept the offer and didnt join?

Need 11 likes to enable DM

If we join in September, are we eligible for coming appraisal / year end review?

Taylor Swift is older than my MD. 🤯

I am working as business PM on critical project and implemented a regulatory solution which helped bank saving YoY 1 Mio USD - in today's dept. town hall, my manager(cluster PM) along with dept. head presented a case study of my project on how innovative solution can save millions for a bank - disappointed that I was not even mentioned once and worse part was that, the slide they presented was also prepared by me ☹️ - never felt so low and insulted - how should i take this experience??

Hot take: drinking alcohol (even “social” drinking) is not attractive. It’s indicative of poor mental and physical health

I have recently joined wipro into APMEA-iDEAS Digital. Please suggest which clients/customers wipro holds for this unit/region

Male 🐠, what are your thoughts on women sleeping on the first date? Do you think you are no longer interested because they slept on the first date ?

Looking for canada onsite opportunity in IBM.
7 YOE . Full stack tech lead. JAVA, Angular, AWS, NodeJs

Can anyone please refer me Bain & Company . For the job id 61588.

Do you have a classroom coach?

Any recommendations for car repair shop in Everett/Malden/Medford or Somerville?

Did anyone start WFO in Hyderabad? If so what is the occupancy in your office ?

Need some excel help. I have a report that includes data for a bunch of accounts. However the report does not include a column for client name for each account. I'm waiting on our software engineer to pull the report but in the meantime I need to figure out a way to get the existing data to include the client name.

If I have a report with all accounts and client names and the second report with the data with the account numbers, is it possible to get excel to find the associated client name

Not Excel but Outlook: anyone know how to make it so others can’t recall messages from your inbox?

Hi all, I want to calculate duration in hours between x date/time and y date/time (dd/mm/yyyy 00:00 format). The part I need help on is how to build in logic which ignores certain hours of the day from the hours figure that we get at the end. E.g. without this built in, 0000-1900= 19 hours, but if I want to build in logic that only counts duration of hours between 0800-1700, we would get the answer of “9” even if x = 0000 and y = 1900. Would appreciate any guidance on how to do this.

Would you rather use Excel versus CRM to store data and manage records? If so, why?

How much of a learning curve for Alteryx if one’s excel skills are advance? Or it doesn’t matter since both are totally different?

Is there an easy way to create flow chats and diagrams in Excel without the Visio add-in?

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

What are your favorite excel macros to make you more efficient at work?

What's the equivalent to a sumifs formula but instead of #s I want to bring in names. For example, i want to return a client name but only if it meets two criteria.

Need to create an P&L for a physical therapy center without using existing excel templates. Just cap payment info, lease price, team member salaries and supply costs.

Seeking formula support…,and open to other tips and tricks.

Just created my first macro! Super proud of myself! #humblebrag

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

To see a list of all tabs you right click on the arrows to the left of the tabs. Is there a shortcut to this without a mouse?

Anyone know of any roles or companies that hire you with basic excel skills and train you in advanced excel/analytics?