Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
auto copy old data to new cell
How does one automate the copying of old data in cell A to cell B when new
data is entered in cell A? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
auto copy old data to new cell
It's not strictly possible to achieve this because entering new data into a
cell destroys the old data but you could use something like the following which copies the existing data on selection of the required cell before you type new data in. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Select Case Target.Column Case 1 If ActiveCell.Value "" Then ActiveCell.Offset(0, 1).Value = ActiveCell End If Case Else End Select End Sub "walt007" wrote: How does one automate the copying of old data in cell A to cell B when new data is entered in cell A? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
How do I copy data from one cell to the next occurrence of data? | Excel Worksheet Functions | |||
Cell data format | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
Set default in auto fill options, I always want to copy cell, som. | Excel Discussion (Misc queries) |