Should I use a formula or Macro to pull specific data from one tab to another

Hello all,
I have a Raw Dump worksheet that all of my collected data goes into. I would like to have different worksheets within the same workbook that pulls specific rows from the Raw Dump based on the "CName" column. Would a formula work for this or would a Macro be best? I've attached a test sheet with a basic layout of what I am trying to do as well.

test.png

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

No problem, thanks for the change.

	A	B	C	D
1	A	Person	Date	ID
2	A	Anthony	43635	1111
3	A	Pete	43635	1122
4	A	Chris	43635	5763
5
6
7

What I did here was use your headings from Dump, but changed the 1st heading to show which letter you want (A1)
I then used this ARRAY formula...
A2=IFERROR(INDEX('Raw Dump'!A:A,SMALL(IF('Raw Dump'!$A$2:$A$9=$A$1,ROW('Raw Dump'!$A$2:$A$9)),ROWS($A$1:A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Copy this down as needed, then copy all of "A" across to the other columns.
You can then copy that whole range to the other sheets.

Note however, if you have a LOT of data (10 000's or rows), this may show your file down and VBA might be better.

Hi,

I'd do this problem using Advanced Filters. See the attached where I've done your problem using them. You will need to create a criteria range on each sheet and I've created a Dynamic Named Range for your raw data. See the attached. It should be much faster than the CSE suggestion above or even VBA since it is native Excel.

Advanced Filter for Each Sheet.xlsx

Hi,

See if this helps:

Advanced Filters For Sheets 2.xlsx

Originally Posted by devildogdad76

Thank you both. I wasn't able to get the CSE suggestion working unfortunately...

Did you replace CNAME on each sheet, with that sheet's name?
Did you use CTRL SHFT ENTER to enter the formula?

I got this method to work and it is doing exactly what I am needing without need for further automation. I looked back on it today with a pair of fresh eyes and realized that I had copied over the A2 in front of the formula which of course didn't work. Thank you both very much. I've never used advanced filtering before, so that was interesting to learn about and will be looking for something to use that on in the future.