how do I get a macro to change a cell in multiple worksheets?

B

BB_XLNovice

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

any help is welcome!
 
T

Trevor Shuttleworth

Record the actions you take as you do this manually. Stop the recording and
look at the code. It won't be the most efficient and you will need to
modify it to copy with different months and years but it will be a start.

The recorded macro will always do what it did the first time you recorded it
so you *will* need to change it.

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top