Hello All
I am hoping someone will be able to help, I have searched the internet for similar problems but have come up with nothing.
I have a form set out in excel and I have started writing a macro adapted from another working macro I found and adapted. I need the macro to find each heading on the form (sheet 2) then copy the data in the cell to the right of those headings. Then paste it into a table on the next sheet (Acquisition) under the appropriate heading without copying over any data that may be already there. The Macro I started below works in part but isn't specific enough, either way I think of changing it, it either copies the whole row or column.
I have attached the worksheets in question (hopefully)
Thank you in advance for any help.
Bookmarks