Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet set-up/programming
I have three worksheets: CurrentUpdates, YTDUpdates and
Account_Info_Master_Sheet. On a monthly basis, new account information will be entered into the CurrentUpdates sheet. This sheet is programmed with data validation drop down lists. I would like the data field from this spreadsheet (Account Name, AE, Region, etc) to auto-populate at the bottom of the YTDUpdates sheet. So, the YTDupdates sheet will keep a running total of the information. The CurrentUpdates sheet will be deleted on a monthly basis & new data entered. Also, not sure if this can be accomplished, but I would like the CurrentUpdates sheet to automatically make any changes to the Account_Info_Master_Sheet or add new data (depending on the scenario). I'd like to keep the CurrentUpdates sheet clean, so that once additions are entered, they are either hidden or deleted from this sheet. This Account_Info_Master_Sheet needs to populate data in other Excel spreadsheets. I'm not well versed in Access. Wondering if Excel can handle this project or if I should tackle it in Access. Any help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programming | Excel Discussion (Misc queries) | |||
WORKSHEET FUNCTION or PROGRAMMING. | Excel Worksheet Functions | |||
CD Programming | Excel Discussion (Misc queries) | |||
Help programming new chart into a new worksheet | Charts and Charting in Excel | |||
programming | Excel Discussion (Misc queries) |