RAECH
02-12-2021, 01:35 AM
Hi Everyone!
I'm new here (and to VBA programming). And I could use some help to fix a little problem.
I am working with weekly accounting data, where I import data and need to make some correction in the accounts manual. So I have a cell (Defined as "COR5010" where I enter my corrections, and then I would like to subtract the cell from my imported data. So I want to be able to do my correction in my cell COR5010 and then automatically subtract it from the individuals account from my newly imported data.
How can I do this?
I've tried with some paste special subtracting function - but then I need to rerun my macro every time I make adjustments in my corrections. If possible without "new" cells where I transfer my data to, and then do the calculation.
Furthermore, as other people uses the same sheet I need the formula to be visible in the formula bar (instead of just doing the calculations as with the paste speciel I use now).
In summary...
I import data into eg. "D27" (say the value 150,000) and then I would like to subtract the cell "COR5010" from that very cell. So that in my formula bar my co-corkers can read "=150000-COR5010".
Any suggestions?
Best regards,
Rasmus
I'm new here (and to VBA programming). And I could use some help to fix a little problem.
I am working with weekly accounting data, where I import data and need to make some correction in the accounts manual. So I have a cell (Defined as "COR5010" where I enter my corrections, and then I would like to subtract the cell from my imported data. So I want to be able to do my correction in my cell COR5010 and then automatically subtract it from the individuals account from my newly imported data.
How can I do this?
I've tried with some paste special subtracting function - but then I need to rerun my macro every time I make adjustments in my corrections. If possible without "new" cells where I transfer my data to, and then do the calculation.
Furthermore, as other people uses the same sheet I need the formula to be visible in the formula bar (instead of just doing the calculations as with the paste speciel I use now).
In summary...
I import data into eg. "D27" (say the value 150,000) and then I would like to subtract the cell "COR5010" from that very cell. So that in my formula bar my co-corkers can read "=150000-COR5010".
Any suggestions?
Best regards,
Rasmus