I would like to shortcut the time of filterating the data by creating a template to extract the data wanted into different tabs every time I copy paste a new data.? Any idea?

I work as an accountant, our general ledger has different accounts, I just want to filterate these accounts into multiple tabs rather than copy paste data into these tabs every time. Thanks

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

Create a pivot table and then update the pivot table data source?

like

For sure it depends on the template, but =FILTER() should solve most of it

like

If the process is repetitive and doesn't require a lot of thinking you can try out a macro, no?

like

The filteration is not the issue, extracting the data into multiple tabs is the issue. Thanks

Excel has a FILTER function that should solve it

like

Thank you all, I think I will go with the pivot table solution . 🙏

What does filterate mean

Use Power Query for this.

Related Posts

Has anyone met with TR about the exemptions?

like

Any of you still flying to client site?

like

What is the "expiration date" on having to wish someone happy new year, even if you haven't seen them yet in January?

like

Anyone have any Boston area firms they would recommend working at? Considering a change

like

I've put down my papers in TCS few days ago, and I received a mail from RMG to fill some online-form survey.
Can anyone shed a light on what would be asked on that survey?

like

Hi Folks,
How much salary should a lateral hire ask for this position , at Airbus Bangalore?
Scrum Master in Scaled agile Framework (safe).
9+ years experienced , with relevant experience of 3+ years.

like

Question: You are all members of the Yakuza and you happen to be visiting the Lackawanna trolley museum and you are attacked by triads. How can you hold them off until your clan arrives?

like

There is a baby in my home today. (Friends are visiting.) Help.

funnylike

Anyone hiring entry level ux? I am a senior designer but feel junior ux. I mean does anyone train anymore?

like

Do @ICICi have hybrid mode of work in TEchnology groups? Pls advise.

Started/maxed out my 2020 IRA on Friday at the market high without knowing and now my whole portfolio is down 2-5% already 😔

likefunny

Any advice for someone who is looking for his first job in the video game industry? I've just graduated in my higher education in interactive environments and don't get much responses to my job applications

like

Does anybody know CTC offered by Accenture Strategy at campus this year?

like

Anyone else feel like family law is toxic and detrimental to the attorney’s health/quality of life? My client was served w/ an order of protection against her—her ex is abusive and is gearing up for a custody battle. Of course the OP was filled with outrageous lies. My home-office phone and cell were ringing from 9:00pm- 12 am after she was served…..I am in my first trimester of pregnancy with my 2nd kid and suddenly feel like I don’t want to/cannot handle this type of toxicity.…continued….

like

Anyone know the TC for internal tech product manager in Mega funds(Apollo, Blackstone, kkr) 7YOE

like

I am on notice period with Tata Consultancy with 2 months remaining with an offer in hand where the joining date is just after notice period ends. Now, I got early release from current company and thus, I saved 2 months. But I want to use these 2 months for travelling, upskilling and looking for better offers instead of contacting the new company for early joining. So, if I join the new company after 2 months will this be considered as a 'gap' in my profile in the future and will it be harmful?

like

How is e-commerce tech operations role for CA with experience in internal audit. Will this help grow in career

Post-interview thank you note… any way to stand out with it? Should I use it to reiterate my case/ qualifications or keep it brief?

like

Why isn’t logistics a more competitive field? I feel like it isn’t well-liked by people, and most don’t even consider working here.

like

Hello everyone I am a Vue js developer
I am looking for some job opportunities
YoE: 2.8
Notice period: 30 days

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

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

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

likehelpful

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

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

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 :(

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

Excel Fact Of The Day:

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

like

Can anyone help me with this pls? I created a graph using data above (not shown) but for some reason “technology” here appears three times. I want sectors to be grouped together. Is there any way to fix this?

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

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

Post Photo
like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

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

like

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

like

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

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

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

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

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