| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Copy Data from One Group of Cells to Another
I have five columns of data on two different sheets in the same workbook. One
set of columns is sorted in ascending date order the other in descending date order. When I enter data into the last row of Sheet 1, I need the data in that row in columns A, B, C and D to be copied into Sheet 2 columns A, C, D and E in a newly inserted row 14. Is this possible with the use of a macro? I can find the last cell in Sheet 1, but then need to go up one row and back to column A. I am having difficulty with that. Thanks is advance for any assistance offered! /s/ Alan Auerbach |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically copy previous cells in data entry in Excel | Excel Discussion (Misc queries) | |||
| Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
| How can I sort a group of numbers automatically as data is entere | Excel Worksheet Functions | |||
| How can i copy a group of cells in a row to a column? | Excel Discussion (Misc queries) | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
Threaded Mode
