Hi there, I am basically looking to do the following:
Copy several cells information (A16, H2, F2, D16) from sheet1 to sheet2's columns a,b,c,d starting from row 3.
I need this to be copied to a next empty row every time the macro is applied.
I am able assign this macro to a button but just have no idea how to write the code.
Hope this makes sense and someone can help.
Gav
Bookmarks