Need to create three sheets with data from another sheet.

[bijicha]

Hi

I am attaching a work book with 5 sheets.

Sheet "Action" - Here i supposed to add few sales order numbers.
Sheet "Orders" - Here is the data, to be populated to Sheet "Ch Inv", "Ch PL" and "GM PL" based on the sales order numbers in Sheet "Action"

i did the Vlookup to get an idea, but i wish to get this with a vba, that if one sales order has two or more parts, then each part to be populated one below other in Ch Inv, Ch PL and GM PL sheets

Please help me.

 

[p45cal]

A start: At cell D2 of the Action sheet in the attached workbook is your table of Sales Order numbers that you want included in the other 3 sheets. Because this is a proper Excel table, when you edit this table make sure that all the order numbers you want included are within the confines of that table. If you add numbers directly at the bottom of the table it should usually expand to accommodate the new numbers. If it doesn't, you can drag the bottom-right grab-handle and manually move it (You can also use his technique to exclude rows at the bottom of the table without actually deleting values while your testing):



The tables on the other three sheets (they're each below your original tabes) do not update themselves, they need refreshing by either right-clicking each one and choosing Refresh, or you can do them all at once by clicking the Refresh All icon on the Data section of the ribbon:



Note that the data on the SKU and Orders sheets have also been made into proper Excel tables, and that I've deleted the calculated columns (V:Z) on the Orders sheet as they're no longer needed.

This suggestion uses Power Query. If I get the time and inclination I might have a go at producing a formulas-only version.