![]() |
#1
|
|||
|
|||
![]() Hi, I would like to make a 'master list' of all data in other lists. Column A is a timestamp Macro watching B and C for data. Timestamp cell is locked. Column A is "date/time", Column B is "Customer Name", Column C is "Customer number". Sheet1 is City1, Sheet2 is City2. Sheet3 is State. As data gets entered in B and C, the Timestamp, name, and number from either city is copied to the State sheet. Pasting of Values preferred, occasionally the customer number is blank. All data in this Master State List would naturally be sorted by the timestamp. Essentially the State List sheet would be a changelog list of data entered in both cities, and additional cities if necessary (scalable). Is this possible with formulas? Thanks. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Rule to forward email using rule to me@onenote.com | anony1 | OneNote | 2 | 02-04-2023 02:39 PM |
![]() |
dcriollo | Mail Merge | 1 | 07-21-2015 01:44 PM |
Setting a rule for a mailing list, driving me nuts! | ib1000 | Outlook | 0 | 05-22-2015 01:10 AM |
Rule to turn off a rule | tiger10012 | Outlook | 2 | 02-23-2013 09:50 AM |
Rule runs once, but not later | stlsailor | Outlook | 0 | 07-28-2009 08:18 PM |