Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I get a macro to update dates in multiple worksheets?
I have a workbook that pulls data from another file and generates 4
additional worksheets (e.g.: W1A 4_27, W1B 4_27, W2A 4_27, W2B 4_27). The data pulled is loaded onto pre-formatted sheets. I then have to manually update the current and previous month names (and year if previous month was December) for sheets 1, update the month names for sheets 2, save the sheets with the updated data and include the date of the pull in the tab name. Every sheet retains the last entered month name/year prior to being updated. I need to create a macro that can automate most of the manual steps and do the following: Find out what the last entries were for the listed Months and years€¦ A) Sheet1A 1) Update the Current Month Name in cells B6 (e.g.: Mar Balances) 2) Update the Previous Month Name in E6 (Feb balances). 3) IF the Previous Month Name in E6 = "Dec balances," Update the listed YEAR in cells B7 and C7 4) Update tab/worksheet name (e.g.: if it were W1A 3_3, and pull was made on 04/27, new name will be W1A 4_27) B) Sheet1B 1) Update the Current Month Name in cells B7 (e.g.: Mar Balances) 2) Update the Previous Month Name in C7 (Feb balances). 3) IF the Previous Month Name in E7 = "Dec balances," Update the listed YEAR in cells B8 and C8 4) Update tab/worksheet name C) Sheet2A 1) Update the Month Name in cells B7 (e.g.: Mar) 2) IF the last entry for Month Name in B7 = "Dec" Update the listed YEAR in cells B6 3) Update tab/worksheet name C) Sheet2B 1) Update the Month Name in cells B8 (e.g.: Mar) 2) IF the last entry for Month Name in B8 = "Dec" Update the listed YEAR in cells B7 3) Update tab/worksheet name |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto update to multiple worksheets | Excel Discussion (Misc queries) | |||
How to update multiple worksheets? | Excel Discussion (Misc queries) | |||
How to update multiple worksheets | Excel Worksheet Functions | |||
How do i update multiple data ranges across multiple worksheets? | Excel Discussion (Misc queries) | |||
Update multiple worksheets | Excel Discussion (Misc queries) |