Copying into empty cells 2 - macro

[butlerar]

Hi

Really hope someone can help.
I need to start from its most basic so i can see what the macro is doing & then adapt.

See attachment.
This will take the form of a button to be clicked on in sheet1.
Sheet1 is my input sheet, sheet2 is my history sheet.
I want to copy the cell range B4:F9 in sheet1 into sheet2 - starting from cell C3.

Next time i click the button, copy the cell range B4:F9 sheet1 into sheet2 again, but underneath the data already there in sheet2

Each time i click the button it just keeps adding the data in sheet1 into sheet2, to form a history.

Thanks,
Alex.

[alansidman]

Here is the code. Add a button to your sheet and link this code to it.

Please Login or Register  to view this content.

[butlerar]

Thanks so much, Alan.

All the best my friend.

[butlerar]

Hi Alan

A little problem if you can sort...

The data copied into sheet2 always starts at cell C2. (wanted cell C3)
I've tried changing the C3's in the code to C4 etc, but makes no difference.

Thanks,
Alex.

[butlerar]

It appears to be ignoring the first 2 lines of code under - Application.ScreenUpdating = False - & just using lr=, in this case, to begin with, starts at C2.
If i put + 1 at the very end of the lr= statement, it then starts at C3, yet adds a blank row between each set of data copied into sheet2, mmmm....

[alansidman]

Changed up the code a little bit. Not sure why it was ignoring that line. Try this:

Please Login or Register  to view this content.

[butlerar]

Genius, Alan

Thank you, i can now get cracking!

Alex