I have a master data list on sheet 1. Need to split the data by location (4 locations) on other sheets but only want to update sheet 1 as I get more data. How can I make it so?

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

The best I've found is four pivot tables filtered for location in each of the tabs. Would love to hear other ways

like

I agree. I think this is honestly the most efficient method.

like

If not pivot, look into doing each sheet as a query of the master table sheet which would just pull each specific location

like

How much data?

It's not a lot. Currently only 300 rows but I will keep adding to it
I would like to do it without a pivot, basically want sheets 2-4 to have all the same data and formatting but only filtered by location. So sheet 2 will have all data from location a, sheet 3 from location b etc

Do you have or in the future is it possible for you to have “duplicate” data within each location?

Good approach

OMG I have this same question

Related Posts

I graduated with a degree in Business in 2018. I’m planning to pursue a Masters in Engineering (likely will pair with MBA) and have been taking the required pre-reqs over the last year from community college.

Is there a big difference between MEng and MS degrees? Or about the same?

I started off looking in going into Mechanical Eng but now looking more into Civil & Environmental.

Is anyone here willing to provide insight about job prospects between the two fields?

Or any other advice?

like

On my way to offer advice at a dinner for first-year attorneys of color. What should I tell them?

like

I'm a military veteran and a recent graduate. I will be relocating from Atlanta and starting my new position in August. I am looking for a studio or one bedroom in Brickell or Downtown (possibly Little Havana or immediate surrounding areas as well), since I will be working Downtown. If anyone knows of any places leasing for $2,300 or less please let me know. It's been tough for me to find anything - I am not considering roomates.

TC 105k: $80k base and $25k from other sources.

helpful

Hows the appraisal number in coforge for this year ?? Nd also how much variable did you guys received ??

like

Has anyone else tried Strattera, had success, and a few months later felt like work was a struggle again? Am I imagining it? There are reasons why I should not take stimulants, but I miss that feeling of being a “regular” person at work and so am curious if others have had a similar journey and where you all ended up

like

Saw a post where a guy had 11 remote jobs and 11 laptops on his desk. Said he racked up $1.3m in salaries. I wonder…would employers really even know?

likefunnysmart

For those who have international travel planned (USA to India), how are we supposed to get a PCR test result in 72 hours? Labs are overwhelmed. Flight is not until end of Jan but I’m concerned!

like

Tips for desk research heavy projects (lots of reading, processing and synthesising information): how do you do it? Are certain meds better/worse? Modafinil feels better for reading and processing info but stimulants better for focus and executing tasks.

like

I’m a financial services regulatory / Fintech lawyer in Singapore, have you heard of foreign lawyers in the financial services regulatory space in US? I’m looking to move into the US market

like

Why are weddings so expensive?!

like

Hi! Has anyone know the salary range for a radiologic technologist with <1y experience in New Jersey?! How much should I expect get paid? (In a hospital / medical center)

like

Can anyone help me with ECTC with JPMC for 602 grade.
Even a range would help.

Tech- React
YOE-8+
CCTC-15lpa

They have agreed for 25 fixed. Not sure if that is good enough.

Have a very demoralizing situation at work right now. Trying to win the Academy Award by pretending I’m not devastated. Doing everything in my power to cope until I can get out of here.

like

On resumes do you just want to see the company and the clients you worked for while there? Or do you want a list of all the accomplishments you did at each?

like

Hi .. got an offer with Mphasis…band 4 level 6.. can anyone help what would be the roles n responsibility under this level…

like

Are all large healthcare provider organizations (big health systems) messed up? In terms of poor senior leadership, no accountability, poor support to their leaders, mismanaged, etc.

like

Did anyone else have their final round interview at Bain?

like

I have to spend all of next week at a wedding with a friend who I realized makes me feel bad and I don't want to be around anymore. Don't know how I'll get through it 😩

like

Cognizant joining date is last week of December,22. When shall i complete the BGV documentation ?

like

Additional Posts in Excel Genius

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

like

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

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

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

like

Best pdf to excel converter?

like

Whats a good book/course that will teach me advanced excel skills? I want to be quick with shorcuts etc & learn VBA/Macros. Under $30 please, input is greatly appreciated.

like

Anyone use teammates analytics? Does it work well with large worksheet? I am cleaning up this large Excel sheet, it's taking so long I don't even know if it's taking it's time or what.

like

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

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

Post Photo
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

Please help. I was recently hired by a Venture Capital firm that uses MacBooks instead of PCs. I’m extremely efficient with Excel on PCs and am struggling with the transition to Mac. Do any Mac users have a list of keyboard shortcuts that they use frequently, or any other tips/tricks?

likefunny

What's the F4 analogy in Office 365?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

I really need some help.
What shortcut inverses my
Ctrl + [ aka Ctrl + {
which jumps through a cell to the source? How do I jump back? Manually isn't practical for a 50+ tab sheet

like

This is pretty vague, but what are some formatting tips n tricks for a model? I know the basics (like color code) but borders, titles, font, tables always look weird and I have no idea how to start

like

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

likeuplifting

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

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

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