Hi,
I am looking to copy a range ("Y9:AH9") from sheet 1,
and paste values into the next empty row within a range ("C5:L33,C48:L76") on sheet 2.
Your help is really appreciated.
Hi,
I am looking to copy a range ("Y9:AH9") from sheet 1,
and paste values into the next empty row within a range ("C5:L33,C48:L76") on sheet 2.
Your help is really appreciated.
Hi,
You might use a loop like this
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
Many thanks, can you change the code so it pastes the values only into sheet 2 please, it is copying the formulas.
Certainly- change this
to thisPlease Login or Register to view this content.
Please Login or Register to view this content.
Brilliant, thank you so much
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks