Hopefully this will be useful to someone...today I tried to work out how to select specific cells on Sheet1, which after clicking the macro copies the equivalent rows on Sheet2 (only the data from columns A:AD) and then paste that data into Sheet3, individually it was easy enough but with multiple I ran into issues however after alot of trial and error I found a simple solution (I'm sure there is a much easier way but it does the job!)...macro to follow...

Best places for takeout in inner loop? I love Local Foods, Aladdin, etc.

Multiple openings in Unisys India Pvt Ltd. However, I will refer you only in exchange of referral. You refer me to your company, I will refer you to mine. DM me for further conversation.

What does Amdocs provide to a 2.6 YOE candidate?

Any idea about how is Zomato in terms of work culture in GRC (governance risk and compliance) department?

TC New grad Software Engineer
Base: $110k
Sign-On: $35k
RSU: $120k/3years
Relocation: $20k

Starting fresh with virtually $0 savings and $0 worth of financial literacy, whats the best course of action? any advice is greatly appreciated!

Hi Guys
Any suggession for last email. Jaate jaate dhamaka karna h EY m 🤣

I’m a BSN,RN and wish to pivot away from the bedside in the near future. I also have a psyc degree inclined towards organization behavior. I’m learning about change management but wish to connect with people who have gone through change initiatives so they can share insights and help me decide if that’s a path I want to take. Feel free to message or drop some wisdom in the post! Thank you

3 Things to keep in mind which changing jobs:
1. Always ask dedicated budget for the job before you tell your expectations.

2. Always have atleast 2 weeks of gap before you join any company. You might not understand significance of that but just have a gap.

3. Always talk to people of team you will be joining before you accept offer or atleast before you join company.

Morning ! Just setup a coinbase pro account yesterday but I got the trading prohibited message . Does anyone know whats going on?

Anyone here 40s never married, no kids?

Best areas to live in if have to commute to DTLA two days a week and partner has to travel to Riverside next year? Ideally we don't want to move twice. Hoping to not have longer than 1 hr commute with traffic in either direction. Please be kind I know LA traffic is horrible- I don't need a lecture about how bad it is lol

What would be the best method to transition from a financial advisory role to a more financial analyst focused position? Is this type of move unheard of/too difficult to do?

Free MBA at Yale/Stern vs. Full price tag at H/S. What would you choose and why?

Hi, does anyone know the pay range for Syneos Health Engagement Manager role?

Is fp&a a good exit? Feels like many look down on it

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

How do I compare two sheets to make sure they are identical?

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

Best websites to get more of a handle on Excel as a beginner-intermediate?

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?