I am currently starting learning how to program with VBA. I am able t
see how powerful a tool it can be. This is my problem. I currentl
create spreadsheets where I have to repeatedly enter a value in on
cell and subtract the three cells to the left of it. To state m
problem clearly, I am given the annual operating information for
company and need to "back out" each quarter's results. Therefore, whe
looking at an annual report, I only have the annual results for the 4t
quarter, not the observed amount. Therefore, to back out this value,
have to subtract the previous three quarters from it (three cells t
the left of it).

Ultimately, what I would like to do is type the "running annual total
in the appropriate Q4 cell, type a shortcut, and have it subtract th
values in the three cells to the left of it. However, to my limite
programming knowledge, I have been trying to use VBA to recognize th
value in the cell and then subtract it from the cells to the left
however, it is not functioning properly. If need be, I would even b
willing ot have a input box prompt me for the annual total to be use
in the formula.

Since I would be performing this action often, I believe this is
relative reference issue, and not an absolute cell reference.
Additionally, assuming that the code is relatively simple, I think
have enough knowledge (or at least be able to figure out) how to creat
another macro that lets me subtract only two columns to the left, the
only one column to the left.

I apologize for the long explanation. As you can see, I perform th
task, for example "9.5 - A1 -A2 - A3" repeadtely in my workbooks an
want to simply the process to increase the efficiency of m
keystrokes.

Any help will certainly be appreciated.

Thanks again and Best Wishes,

Broc

--
Message posted from http://www.ExcelForum.com