Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
is there a way to make info from one cell migrate to another cellautomatically?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
is there a way to make info from one cell migrate to another cell
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. "Joe" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
is there a way to make info from one cell migrate to another cell
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 "prenfro" wrote in message ... 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. "Joe" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a cell copy the info from another (background colour i | New Users to Excel | |||
How do I make info. from one cell auto. feed in to another cell? | Excel Discussion (Misc queries) | |||
I HAVE SAY INFO ACROSS 10 COLUMNS. HOW TO MAKE THE COL-A CELL ACTIVE WHEN U HIT 'ENTER' | Excel Discussion (Misc queries) | |||
too much info in one cell in excel how do I make it 2 lines? | Excel Discussion (Misc queries) | |||
Tables, How do I make new info push existing info to the next row? | Excel Worksheet Functions |