Macro to copy information into tab based on cell value

[ChrisOwen82]

Hi,

I am new to VBA and looking for some help with the attached file.

I would like to add some code that copies the information from the data tab into the relevant tab based on the value in column F of the data tab.

Any guidance on this would be greatly appreciated !

Chris

[Kaper]

Try such simple macro:

Please Login or Register  to view this content.

To work as expected add just single space or anyc character to cell A2 in all your output sheets, and of course additional lines to transfer all needed data

To increase speed one could disable screen updating and recalculation during the execution,

To increase more, consider filtering out each department first and then mass-copying whole dept data into it's worksheet.