is there a way to make info from one cell migrate to another cell automatically?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 14 Mar 2008 03:04 GMT

I'm not sure how to describe this. I have a row of information and
some of the cells need to change daily. I'd like to keep a record of
the info for the past couple of weeks. Right now I'm doing the tedious
work of cutting and pasting the info in each cell before I change it.
is there a way to get the info from one cell to migrate to another
cell immediately after I type it, then the next time I type in the
cell for the info to migrate to the next successive cell?

Reply to this Message

prenfro - 14 Mar 2008 04:28 GMT

I have found that if you type the info into the first cell, then go to the
cell you want it copied to, type = and then click the cell you want the info
from, and hit enter. I hope that makes sense.

> I'm not sure how to describe this. I have a row of information and
> some of the cells need to change daily. I'd like to keep a record of
[quoted text clipped - 3 lines]
> cell immediately after I type it, then the next time I type in the
> cell for the info to migrate to the next successive cell?

Reply to this Message

RobN - 14 Mar 2008 05:10 GMT

Joe,

This macro may help.
You will need to consider and change the following in this macro:
Sheet1 and Sheet2 to the appropriate sheet numbers
A5000 is the Column letter and the Row number. The row number needs to be
well below any data or subsequent data. You may need to change the A to
another column ref if A is not correct, etc.

Private Sub TransferData()
Sheet1.Select
Range("A1:J1").Copy
Sheet2.Select
Application.Range("A5000").End(xlUp)(2, 1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
End Sub

Rob

>I have found that if you type the info into the first cell, then go to the
> cell you want it copied to, type = and then click the cell you want the
[quoted text clipped - 8 lines]
>> cell immediately after I type it, then the next time I type in the
>> cell for the info to migrate to the next successive cell?

Reply to this Message