Macro to Copy Data to appropriate Sheert

I have Data on Sheet "Imported Data"

Col E contains the sheet names

I need a macro to copy the data from Col A to E on to the appropriate sheet based on the sheet name in Col E


Your assistance in this regard is most appreciated


I have attached sample data

Give this a try.

Please Login or Register  to view this content.

BSB

Thanks for the help, much appreciated

Hi BSB

I have used your code on another workbook and need a small change.

When The Data is copied from sheet "Imported Data" row2 onwards to the appropriate sheet, Where do I amend the code so that it is pasted on the appropriate sheets from row 1 onwards


Your assistance is most appreciated

Give this slight rewrite a try:

Please Login or Register  to view this content.

BSB

Many thanks for the help

I changed the "E" to a "D" in code below

Please Login or Register  to view this content.