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

Closed
excelnoooob - Updated on Apr 30, 2021 at 06:40 PM
vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 - Apr 30, 2021 at 06:49 PM
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.
Related:

1 response

vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 262
Apr 30, 2021 at 06:49 PM
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.