Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple worksheet
When adding new data to the main worksheet I am wanting it to go onto other
specific worksheets. However, the row number of the main database is considerably higher, therefore when the data is copied to the other chosen worksheets they do not carry on from the list of data present on that work sheet but go to the row number that the data was entered on. I am wanting the new data to continue on as a list. Hope this makes sense |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple worksheet
Not sure your questions. I guess below is the an example of VBA that you
could copy the cell that your point stay in sheet 1 to sheet 2 cell a(x). a(x) is the next 'blank cell' count from A1. Sub Macro() Selection.Copy 'select the area your want to copy Sheets("Sheet2").Select Application.Goto Reference:="R5000C1" Selection.End(xlUp).Select ActiveCell.Offset(1, 0).Select ActiveSheet.Paste End Sub "Wellington" wrote: When adding new data to the main worksheet I am wanting it to go onto other specific worksheets. However, the row number of the main database is considerably higher, therefore when the data is copied to the other chosen worksheets they do not carry on from the list of data present on that work sheet but go to the row number that the data was entered on. I am wanting the new data to continue on as a list. Hope this makes sense |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
Excel should let me format worksheet tabs in multiple rows. | Excel Worksheet Functions | |||
Multiple worksheet master | Excel Discussion (Misc queries) | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
How do I auto-filter multiple ranges on one worksheet? | Excel Worksheet Functions |