#1
|
|||
|
|||
Need To Compare Two Worksheets, Update Current Records And Insert New
Hello,
I'm using Excel 2007 I have two reports (last months report and this months report) that I need to compare. If the account number is the same I need to compare two columns on each worksheet and if it they have changed update the two cells on sheet1. If the account number is new I need to add the whole row to sheet1 from sheet2. Let me know if I'm missing any needed information. A macro would be preferred, but I'll take what ever advise I can get. As always all any help is greatly appreciated, David 92595 |
#2
|
|||
|
|||
Without a sample of your data, to see how data is organized, you will not get a response... as you already noticed. Be generous on details, so you will not be the only one to know what you need, you will get a much faster response...
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to insert current date into default filename ? | czomberzdaniela | Word | 1 | 12-27-2011 07:18 PM |
Using COMPARE to compare more than two variables | Wyskers | Word | 1 | 12-03-2011 01:37 AM |
Compare and Update Macro | AaronMoss | Excel Programming | 2 | 05-06-2011 04:54 AM |
Cells from other worksheets apear on current worksheet | Equilar | Excel | 3 | 05-03-2010 01:40 AM |
Auto insert current month's name and current year | Styler001 | Word | 4 | 01-25-2010 06:40 PM |