Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO TO GET BALANCE FIGURE
Situation:-
I have Data in column "G" and "H" (please see belwo) G H G68 3980.00 C47 -4000.00 ME4 -200.00 ME4 200.00 PG2 1200.00 I have "VLOOKUP" formula in column "B" that when ever I put value in any cell of column "A" then it should lookup that value in columns "G" and "H" and get value from 2nd column or column "H". Like if I put "G68" in any cell of column "A" then in column "B" formula should bring up value next to "G68" which will be "3980.00". Then in column "D" I have another formula which is "=B1-C1". Which gives balance when I put any value in coloumn "C". Like if I have value of "3980.00" in one of column "B" cells and when I put value of "1000.00" in next cell of coloumn "C" then I get balance of "2980.00" by formula in column "D". Macro needed:- I need a macro that when I get balance in column "D" as above mentioned "2980.00" and if I put "G68" again in any cell of column "A" then macro should bring up the balance in column "B" which was "2980.00". Because of the orginal budget was "3980.00" and I have taken "1000.00" as mentioned above and now I want macro to bring balance of budget if I put "G68" again in column "A". Please note that I mentioned "G68" just to explain the situation but it can be any value from column "G" (see table above) I hope you understood what I am trying to say can any one please help me in this. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reduce balance | Excel Discussion (Misc queries) | |||
HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE | Excel Worksheet Functions | |||
Can't figure out why Macro wont work???? | Excel Worksheet Functions | |||
Can you help me figure out why my macro is running slowly? | Excel Programming | |||
rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) |