Automatically copy new data to next sheet

T

Tjomster

New Member
Joined
Oct 5, 2018
Messages
8
Hi all!
I have two different sheets and i want the new data i put into sheet1 each month to be automatically copied over to the next sheet. The main problem is that is should be only for one column (X) and that only the new data should be copied and transferred to the same range in sheet2. How can i write a macro that does this for me?
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
You must log in or register to reply here.

Similar threads

Q
  • Question Question
Macro needed to insert 4 rows in table, copy data from above, copy data from another sheet and paste special (transpose values) to those new rows...re
Replies
1
Views
272
sijpie
sijpie
R
  • Solved
Actively Copy Cells From Multiple Worksheets
Replies
8
Views
158
Ryusui
R
L
  • Solved
copy cell and cell above onto different sheet, under the next available line.
Replies
5
Views
184
Alex Blakenburg
A
Z
  • Question Question
Vba - create new sheet and copy date into it.
Replies
1
Views
65
zerofeng
Z
T
  • Question Question
Automatically Copying Data To A New Workbook When Closing A Workbook
Replies
4
Views
428
Tmini
T

Forum statistics

Threads
1,223,911
Messages
6,175,323
Members
452,635
Latest member
laura12345

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top