Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro help required for updating old sheet with new entries
I run a regular report on a daily basis everyday. Now, these report
contains at least 10,000 rows of datas with around 20 fields on th column (ie., the first column contains the field name). Now, I add th status for each row manually on a daily basis. When I run a new report the next day, some of the status of the old file would have move /progressed to a new status. Also, a particular unique key is assigne to each row. All the other numbers/data in the same row will b associated with this unique key. Now, I want whatever new unique key that is generated by the new repor to be imported to the old file by adding a new row in the old file. Also, each unique key has the latest status associated with it eg Despatched, Cancelled etc. Now, if the status of some old unique ke has changed to "Despatched", "Cancelled", I also want these to b updated in the old file by overwriting the status in the old file -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
forecasting sheet - macro required | Excel Discussion (Misc queries) | |||
Macro/VBA for filtering unique entries and pasting in another sheet | Excel Discussion (Misc queries) | |||
Easy entries short procedure required | Excel Worksheet Functions | |||
Updating entries on a spreadsheet via Userforms | Excel Programming | |||
Updating database from excel sheet with macro | Excel Programming |