| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tracking changed cells in two identical worksheets
Hi,
I have two worksheets with the same columns. File 1 is my master sheet with all my rows of data, while File 2 contains only specific rows in File 1. For example, File 1 (1000 rows) Name... City... Age... Group File 2 (20 of the 1000 rows) Name... City... Age... Group File 2 has the most up-to-date data for the 20 of the 1000 rows. Can I update the data from File 2 into File 1 (for changed cells only) by using a macro? I'm not too familiar with VBA code. Thanks in advance for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identical Cells in Multiple Worksheets in one Workbook. | Excel Worksheet Functions | |||
| How do I compare two worksheets to see if they're identical? | Excel Discussion (Misc queries) | |||
| Why did Excel create two identical worksheets? | Excel Discussion (Misc queries) | |||
| How do I match identical data from two different worksheets in one | New Users to Excel | |||
| Protection of identical cells on multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
