| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
update sheet with data at bottom of present data
I have 2 excel 2003 workbooks. Workbook one has 5 column with headings.
Workbook 2 has same five colums with headings. 2 gets updated every month with data in A2:E5 (under the headings). I need this data range to go into the workbook 1 at the bottom of the last entry. This is 4 rows and five columns of data. I Need it to update only when called to update. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
update sheet with data at bottom of present data
On Mar 9, 9:42*pm, outrigger
wrote: I have 2 excel 2003 workbooks. *Workbook one has 5 column with headings.. * Workbook 2 has same five colums with headings. *2 gets updated every month with data in A2:E5 (under the headings). *I need this data range to go into the workbook 1 at the bottom of the last entry. *This is 4 rows and five columns of data. *I Need it to update only when called to update. something like this Set ws1 = Sheet1 Set ws2 = Sheet2 lastrow = ws1.Cells(Rows.Count, 1).End(xlUp).Row + 1 ws2.Range("A2:E5").Copy ws1.Range("A" & lastrow).PasteSpecial |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add data from other sheet to the data present in this sheet | Excel Discussion (Misc queries) | |||
| Go back to update my data with my data entry sheet | Excel Programming | |||
| Update sheet one if data is not present. | Excel Programming | |||
| Delete all rows below my data to the bottom of the sheet | Excel Programming | |||
| Go to last row of data and delete the rest to bottom of s/sheet | Excel Programming | |||
Hybrid Mode
