| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro copying cells to a list in another spreadsheet
I need to set up a macro on a button that picks up a list of values and
transposes them onto another spreadsheet by pasting them at the bottom of a list. I can do the first one but am finding it a problem in locating the end of the list via the macro. I.E. Name Jones Number 1011 Location Central 2nd Spreadsheet Name Number Location Smith 1001 West Betram 1004 East I want to automatically put Jones at the bottom of this list. Any help much appreciated Mac |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro copying cells to a list in another spreadsheet
use this idea dlr=sheets("destinationsheet").cells(rows.count,"a ").end(xlup).row+1 -- Don Guillett SalesAid Software "Mac" wrote in message ... I need to set up a macro on a button that picks up a list of values and transposes them onto another spreadsheet by pasting them at the bottom of a list. I can do the first one but am finding it a problem in locating the end of the list via the macro. I.E. Name Jones Number 1011 Location Central 2nd Spreadsheet Name Number Location Smith 1001 West Betram 1004 East I want to automatically put Jones at the bottom of this list. Any help much appreciated Mac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Cells in List | Excel Discussion (Misc queries) | |||
| copying just the macro from one spreadsheet to another | Excel Discussion (Misc queries) | |||
| Copying cells from one spreadsheet to another? | Excel Worksheet Functions | |||
| Copying data into alternate unprotected cells in another spreadsheet | Excel Programming | |||
| stuck on final prat of spreadsheet "macro copying cells" | Excel Programming | |||
Linear Mode
