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
|
Similar Threads
