Update Sheet 2: specific data is copy and pasted to next row on sheet1

Report
-
Posts
1311
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
July 28, 2021
-
Hello,

Please Help!

I would like to copy and paste daily data I get onto sheet two. Then using a macro button, copy and past select data from sheet 2 cells onto next available line on sheet 1.

Additionally, everytime I enter new data, and hit the macro button, it takes the new data from sheet 1 and adds it to a new row on sheet 1.

1 reply

Posts
1311
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
July 28, 2021
233
Hello Excelnoob,

We are going to need some clarification.

"Additionally, everytime I enter new data, and hit the macro button, it takes the new data from sheet 1 and adds it to a new row on sheet 1."


Do you actually mean:-

"Additionally, everytime I enter new data, and hit the macro button, it takes the new data from sheet 2 and adds it to a new row on sheet 1." 


Is there a criteria that you use to determine which rows to copy/paste? If so, in which column is the criteria?
Are you copy/pasting entire rows or just certain column data per row?

Cheerio,
vcoolio.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!