copy data in the previous cell to the next blank cell and to repeat
this process till the last blank cell has been filled with the data of
the previous cell

---

Clarification of Question by bob2005-ga on 09 Jun 2005 13:36 PDT

To make a clarification.  Here's an example:

I have $ 1000 credit (negative figure) in a cell called "unallocated
Cash" (cash received but needs to be allocated to the different "aged
debts" mentioned below).

Next I have the following amounts (debit balances, so positive
figures)in different cells in a row as follows:
Current, not due for payment = $ 25
Due for payment = $ 250
30 days overdue = $ 50
60 days overdue = $ 75
90 days Overdue = $ 475
120 days Overdue = $ 150
150 days overdue = $ 25
180 days overdue = $ 35

I want to allocate the $ 1000 sitting in the "unallocated Cash"
to pay the various overdue amounts starting with the oldest debt first
(in this example its $ 35 in the "180 days overdue" cell.  If there is
still money (a credit balance), the next Overdue should be tackled
(i.e. the 150 days overdue cell).  This should repeat itself till all
the money in the "unallocated cash" cell has been used to cancel the
debts in the various aged amounts.  If all of the aged balances are
"recovered" and there is still a credit balance, this should be in the
"due" cell (or column), but in the final result, the unallocated cash
colum (or cell) should be NIL>

Hope this is now clear.

---

Clarification of Question by bob2005-ga on 09 Jun 2005 13:38 PDT

One more clarification

The spreadsheet that has this data has approximately 25,000 rows -
hence either a Macro needs to be written or a formula

Could you possibly give a little bit more detail as to what you
ultimately want out of excel? Would you like the answer in macro form,
formula, procedure? Also, how is your data currently structured? Is it
setup in rows going across or columns going up and down? Do you have
chunks of data that you would like repeated without replacing existing
data or would you like the contents of one cell repeated throughout
the entire worksheet?

Microsoft has this page:
http://support.microsoft.com/default.aspx?scid=kb;en-us;213740
on realtive reference.



You could also just paste this rough code into a macro, just goto the
'Tools' Menu, select 'record new macro', stop the macro by the little
form that pops up or back on the tools 'menu'. On the tools menu
choose 'Macros', select your macro, and 'step into'. and paste this:

 

Dim counter As Long
    
On Error GoTo Over_Last_Column
    
counter = 1
Do While counter < 256
    
    counter = counter + 1
    
    ActiveCell.Select
    Selection.Copy
    
    ActiveCell.Offset(0, 1).Range("A1").Select
    ActiveSheet.Paste
Loop
Over_Last_Column:
    Exit Sub

Hey, just to add, the counter number can be changed, in case you don't
want 256 copies of the same cell,.
Also you might want a button for the macro, just
go to 'view' menu select forms, click on the square, draw a button.
connect to the macro.

Just copy your cell using Ctrl + C 

then mark where you want your text/data copied to

then paste using Ctrl + V

If your data-output depends on other rows, this will change automatically

Regards, 

Rasmus