Macro to add rows from wbk1 to end of wbk2 (1 Viewer)

dcavaiani · Oct 27, 2015

Found this sample code but I don't know exactly how to designate the "file" name ??

Error below is "subscript is out of range"

Sub CopySheetToOtherWbk()
Dim CopyFromWbk As Workbook
Dim CopyToWbk As Workbook
Dim ShToCopy As Worksheet

Set CopyFromWbk = Workbooks("virginweeklysummary.xls")
Set ShToCopy = CopyFromWbk.Worksheets("Sheet1")
--- ERROR --- Set CopyToWbk = Workbooks("c:\bobs excel only\hoursbilled.xls")

ShToCopy.Copy After:=CopyToWbk.Sheets(CopyToWbk.Sheets.Count)
End Sub

Trevor G · Oct 27, 2015

The code you have found is copying a sheet not a row, if you can supply a little more information then you get a better response.

Questions:

Which sheet is the data to be copied from
Which row is to be copied
Which workbook is to be opened and its file path to be included
Which sheet is the row to be pasted to
Any extra information please add here.

dcavaiani · Oct 27, 2015

Trevor G said:
The code you have found is copying a sheet not a row, if you can supply a little more information then you get a better response.

Questions:

Which sheet is the data to be copied from (virginweeklysummary.xls - ALL OF SHEET1 (although there are some "blank/incomplete" rows contained in that sheet which I would like skipped over too)

Which row is to be copied - (THE ENTIRE SHEET1)

Which workbook is to be opened and its file path to be included (the copy FROM wbk is c:\bobs excel only\virginweeklysummary.xls) which I have open and am coding the macro inside of this wbk)

Which sheet is the row to be pasted to (C:\Bob excel only\hoursbilled.xls and the sheet name is also hoursbilled)

Any extra information please add here.

(I was also wondering if the column heads have to be is the EXACT same sequence left to right in each wbk - The column HEADINGS are the same but fields are flip flopped)

Trevor G · Oct 27, 2015

To make it easier for the code to follow correctly it would be better to have the Column Headings to be laid out the same.

dcavaiani · Oct 27, 2015

To explain further, the virginweeklysummary.xls / sheet2 is the data entry - of weekly time card data. The sheet1 of that workbook is an auto summary layout of the time card IN/OUT times/data entered into the sheet2. Once all input is clean/edited nd totals balanced, then the sheet1 can be "auto" (via the VBA macro) added to the BOTTOM of the hoursbilled.xls - which is a history file of all the time card weekly summaries.

Macro to add rows from wbk1 to end of wbk2 (1 Viewer)

dcavaiani

Registered User.

Trevor G

Registered User.

dcavaiani

Registered User.

Trevor G

Registered User.

dcavaiani

Registered User.

Similar threads

Users who are viewing this thread