Is there a way to simultaneously merge spreadsheets (or workbooks) and decide which columns/rows to update without a third party tool?

like
Posting as :
works at
You are currently posting as works at

I know you said in excel but alteryx makes this very easy

likehelpful

Powebi

helpful

Uhh a macro can probably do that

like

Okay, back to figuring that out then. Thanks

Here’s a website that I just looked up that might help

Post Photo
like

Yeah this one doesn’t...I believe

When searching always type “excel VBA” before or after you’re search in google

helpful

Can’t PowerPivot do what you’re looking for?

like

I’m very much an excel novice so at this point just looking for any direction. I’ll look into that, thanks

PowerQuery under the data tab could also be useful

helpful

Microsoft Excel- Power Query

helpful

Python with openpyxl or xlwings

helpful

Thanks all!

Related Posts

Has anyone traveled to Italy ? I would like to know what your experience was and how long you stayed and how much it cost.

like

Thoughts on Lo and son’s Brookline bag? I got the OMG but had to return it due to its huge size. I am petite Asian women so a small bag is preferred.
TIA!

like

Hello! I’m providing referrals for my organization. Latino Network is in Portland, OR and provides services to the Latino community. Benefits, work-life balance & work environment are AMAZING. 15 days off per year + paid self care days in summer (14 days), fully paid insurance, 401k with match, wellness stipends, access to Nike/Adidas employee store, free Trailblazers tickets + other sports teams and concerts, and many more benefits. Happy to chat with anyone about my experience.

Hi Fishes,
Anyone gave interview at grid dynamics by hyderabad recently ? Did anyone receive the offer letter yet. I was selected selected after the interview but did not receive the offer letter yet. No response the hr as well.
@griddynamics

like

Tired of stressful airport experiences?

WE ARE HERE TO HELP!

Wish you had someone to help you with luggage, kids and just getting through the airport? Are you a senior who would like a helping hand but don’t want to be stuck in a wheelchair? Now you can find the assistance you need. Sign up online or call our phone number and we will connect you with a trained, pre-vetted airport assistant.
Bookings must be made 24 hours in advance of service.

Post Photo
like

Is it really bad if you renege an offer after you've received some of the relocation reimbursement, if you just don't pay them back, are you technically reliable? The offer is at will right.

like

Anyone in PWC London Digital & Cloud COE?

like
likefunny

Did any of you have side effects from estradiol in the lead-up to your FET? I am also going to be taking medrol and doing progesterone in oil shots and am unsure what to expect physically. TIA!

like

Does Capgemini encourage counter offer? If so when should I approach the hr?

like

Hi,
Can anyone help who has recently joined TCS.
By when we can get the onboarding link and other details.
I missed one of the documentation webex session.
Can someone share the experience of joining.
TIA

like

Any ETL Developer here? IBM is looking for an immediate joiner. Ping me if anyone interested.

like
like

Whose hiring in SAP Security/GRC?

How are you all feeling about going into the holiday season while being remote? Missing the company holiday parties, or happy to be able to do your own thing?

How easy it to ask for a title change if your responsibilities have changed? Is it easy for a leader to make that change off cycle?

like

McKinsey & Company Bain & Company Hello, I received an offer as a Senior Practice Manager at Bain. The profit sharing range is 0-12% in the offer letter. Is it typical to receive the midpoint (6%)? Also, what do the annual salary increases typically look like? Any insights are much appreciated. Bain & Company Boston Consulting Group McKinsey & Company

Anyone have experience with PIP, and what’s the process?

like

Hi
I got offer from Publicis sapient and Valtech.
which one is better?

like

Additional Posts in Excel Genius

how do you index or vlookup when the match isn't exact? like one cell has a comma or space after the value...?

like

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

What are your top Excel ninja tricks? Ones that few people know...

like

What are the most typical models you all build

likehelpful

What's the F4 analogy in Office 365?

like

Ok, using excel is not a primary function for my role (this will be very obvious shortly...) So please be kind! On my sheet, in the first and third columns, I have lists of reference numbers. In the second column I have a client name. I already identified the duplicates in the first and third columns using conditional formatting.What I need to find now is column 2 value, whenever value in column 3 is identified as duplicate. Problem is, I have over 120k rows of data so I can't filter! Help!

like

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

Excel Fact Of The Day:

An apostrophe before a cell value forces Excel to interpret the value as text. (Continued on next post).

like

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

Need some help. Is there a fax function (Filter) so that if I want my subtotals to show a number but nothing below it to report. One expansion of a row the subtotals show but no numbers below it.

like

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

Best pdf to excel converter?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal