I've been doing manual work that I have a hunch could be completed with a
relatively simple macro. . .can somebody tell me 1. if it's possible and 2.
point me in the right direction toward writing the macro?

The task is this: I have two separate worksheets with the same accounts on
them. For each account, I have to take the new information from one document
and use it to revise the totals of the second in one to three steps,
depending upon the current balances of the account within the second document.

For example, let's say one of the accounts on both worksheets is 11112. One
worksheet (worksheet A) has changes in 11112 over the past month. . .let's
say $100 total. My task is to update the account 11112 in the second
worksheet (worksheet B). My update takes anywhere between 1 and 3 steps
because each account has balances in different areas. For my example, let's
say 11112 has a $20 in area X, a $25 in area Y and $1000 in area Z.

I take the $100 update from Worksheet A, use up the $20 in area X, the $25
in area Y and put the balance ($55) in Area Z of Worksheet B. . .then move on
to the next account.

The pattern for each account is consistent--if there is a balance in area X
I use that up first, Y second and put the balance in Z.

This is an easy enough task, but mind-numbing when done thousands of times.
Would a macro be able to help me automate this task?

thanks