Macro to copy the data under the specified name from one sheet

[hattisaeed]

hi i am using varColumn right now the code is as follows

Please Login or Register  to view this content.

Write now it copies the data under the name which is in a merged cell i want it to copy all the 4 columns i.e the next three as well and then paste it into specified cells on another sheet

[barryleajo]

Hi hattisaeed
In Module 2 (sub finds()), replace this code:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

This assumes that you want the three extra columns positioned AFTER the "Expiry" column.
You will need to unhide column L in sheet "Emp Ind HSE" or amend the code to skip this column if it is important.
Also you will need to add the headings on sheet "Emp Ind HSE" to identify the new data that has been copied.
Barry