Hi All,
Being new to VBA I am currently attempting to construct something that will transfer data from one sheet to another based on a particular date.
So far I have managed to get as far as the below but I would like to be able to select only particular columns / cells from each row to copy from sheet 1 to sheet 2 as per my attached example. In addition I would also like to keep the formatting as a table which at the moment it also seems to disregard when copying to sheet 2 and commence the copy in column B rather than column A.
Many thanks for any assistance,![]()
Please Login or Register to view this content.
Gaz
Bookmarks