rockdrigotoca
New Member
- Joined
- Aug 24, 2010
- Messages
- 23
Hello everyone!
I would like to see if you can help me with this that I cannot manage to deal with it...
I have a macro that (thanks to Alpha Frog) consolidates and summarizes the debts and pastes this into a new spreadsheet. Then, I would like to put formulas on column H that will differentiate amounts of 10 or less, 10 or more... but only paste formulas UNTIL the last cell is blank... because I can receive one day 10 debts and another day 20... so to populate until there's no more data on the sheet...
Column A has the name
Column B the account
Col C other data
Column D has the Amount
I would like to input on Column H: =IF(D3<10,"Small Debt","Big Debt")
But rather than prepopulating the worksheet with 60K formulas, is there any way to put it with a macro until there is no more information on Column D?
Please?
I would like to see if you can help me with this that I cannot manage to deal with it...
I have a macro that (thanks to Alpha Frog) consolidates and summarizes the debts and pastes this into a new spreadsheet. Then, I would like to put formulas on column H that will differentiate amounts of 10 or less, 10 or more... but only paste formulas UNTIL the last cell is blank... because I can receive one day 10 debts and another day 20... so to populate until there's no more data on the sheet...
Column A has the name
Column B the account
Col C other data
Column D has the Amount
I would like to input on Column H: =IF(D3<10,"Small Debt","Big Debt")
But rather than prepopulating the worksheet with 60K formulas, is there any way to put it with a macro until there is no more information on Column D?
Please?