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

Question

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.

vcoolio · Answer

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.

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

1 response

Similar discussions

Subscribe To Our Newsletter!