how to compile updated data in a new work book using macros

alias1_1

New Member
Joined
Dec 22, 2005
Messages
3
Hi all,
i need to compile some data and here's the problem im facing:

i have worksheet in which i regularly update my data. as i upadate i overwrite the information in the cells. Now i need to track all the changes in another work book such that every time i open my "tracking workbook" the updated data appears below the existing one.
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,118,070
Messages
5,570,018
Members
412,304
Latest member
citrus
Top