Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to save data in one cell and add new data in cell below etc
Hi,
(Using xl03) I work on 3 worksheets. When I input data on w/sheet 1, it is automatically entered onto worksheet 2 & 3. I run a macro on w/sheet 2 to retain the data from w/sheet 1 but to also insert a new line (hence data moves down 1 cell and if I input new data from w/sheet 1, this is now in the 'inserted' line in w/sheet 2 and so on. My problem is with w/sheet 3. I need a macro that retains the data from w/sheet 1 (similar to above macro), but rather than inserting a new line, I want the new data in the cell below it and so on. Any suggestions will be muchly appreciated. -- KLEM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save cell data as text? | Excel Discussion (Misc queries) | |||
How do I get excel to save after data is entered in a certain cell | Excel Discussion (Misc queries) | |||
enter data in cell but cannot save until click off cell in excel | Excel Discussion (Misc queries) | |||
enter data in cell which will start macro to move data to sheet2 | Excel Discussion (Misc queries) | |||
I need a macro that copies that data from one cell on one sheet to a cell on another? | Excel Programming |