Hi there

I am trying to carry out a relatively simply copy/paste type function between two sheets based on the following criteria:
- range to be copied is from sheet 1A, column G, used range only (from row 6 onwards)
- data is to be "pasted" onto sheet HA2, same row numbers as the data on sheet 1A. The destination column is based on looking up and finding the value "1" in row 6 between columns 9 and 213.

I've tried the following code, using a function defined below, but it doesn't seem to work...

For the lookup of the destination column, I've just tried to find the last (only) column with data....

Please bear in mind, I'm a VBA absolute beginner, and the code I've hatched together is from other code a friend has prepared for me!

Thanks in advance

Please Login or Register  to view this content.



Please Login or Register  to view this content.