Auto populate master list

[onbeillp111]

I am looking for either a macro or some formula that will auto populate a master list. I have attached a small example of my master list. I have multiple tabs, all named for what is in column A of each sheet. Each month I get a new list to paste into Sheet2, I am looking for a way to have each sheet look into sheet2 for the value in column A and copy and paste, or even better cut and paste, the rows that have the same value in Column A, into the next field of each sheet.

search Example is what I have before
search Example_outcome is what I am looking for.

I don't really know where to start with this one.

Any help would be greatly appreciated.

[p24leclerc]

You'd be better with a VBA solution that deletes data from sheet2 and copy it in the appropriate one. This way, you end up with en empty sheet2 which is good for your next month.

If the sheet is not yet created, would you like the macro to create it automatically?

[p24leclerc]

The following macro should do it for you.
It delete data from Sheet2 and create sheets if they don't exist.

Please Login or Register  to view this content.

[onbeillp111]

This works great. Thank you.

One question, is it possible to just look through the worksheets and see if the value in A2 exisits? The name of the sheets change month to month to include a percentage so for instance last month the a sheet would be named 071-000-438 (20.73) and next month it could be 071-000-438 (22.73).

[p24leclerc]

I don't understand your question here. Can you explain?

[oneillp1]

Your code worked perfectly for the example that I posted. But what I am wondering is if it will work for workbook that has worksheets that automatically change sheet names. For Instance, all my worksheets are named with a part number such as 071-000-438 and a changing percentage such as (20.37). So a sheet will be named something like "071-000-438 (20.37)" for the month of January. Then during the next month, that percentage will change and the tab name will also change. So in February that percentage becomes 23.73, the tab name will now be "071-000-438 (23.73)". Your code looks for a sheet named "071-000-438" and if it does not find one, it creates one. I am wondering if this can be modified to look for a sheet that just contains "071-000-438".

[p24leclerc]

Probably, but where would you put your data? In which sheet? The one with 23.73% or the one with 20.37%?
Why do you want to create multiple sheets of the same part number? If it is for the month, why don't you add the month name at the part number?