Cartillo
asked on
Copy additional data from column
Hi Experts,
I would like to request Experts help modify “SendToMaster_Out” module at UpdateData_2 workbook to allow data at Column F copied to MainData Workbook at Column F. Currently only Column A to E (CopyWB) are copied at MainData workbook. Hope Experts will help me to add this function.
UpdateData-2.xls
MainData.xls
I would like to request Experts help modify “SendToMaster_Out” module at UpdateData_2 workbook to allow data at Column F copied to MainData Workbook at Column F. Currently only Column A to E (CopyWB) are copied at MainData workbook. Hope Experts will help me to add this function.
UpdateData-2.xls
MainData.xls
ASKER
Hi Scifo_dk,
I'm referring to "“SendToMaster” module
I'm referring to "“SendToMaster” module
Haven't checked thoroughly but is it enough to change the 5 to 6 at the end?
With shtListing
Set rngListing = .Range(.Cells(3, 1), .Cells(.Cells(.Rows.Count, "A").End(xlUp).Row, 6))
End With
With shtListing
Set rngListing = .Range(.Cells(3, 1), .Cells(.Cells(.Rows.Count,
End With
ASKER
Hi StephenJR,
Have tested, the data (column F) was not copied to MainData workbook. Please assist.
Have tested, the data (column F) was not copied to MainData workbook. Please assist.
ASKER
Hi StephenJR,
The formula works after I amend this line:
For i = 1 To 6
The only problem I have now is the 3rd row of the UpdateData_2 sheet also copied at MainData workbook. How to prevent this. The data should only copied from row 4.
The formula works after I amend this line:
For i = 1 To 6
The only problem I have now is the 3rd row of the UpdateData_2 sheet also copied at MainData workbook. How to prevent this. The data should only copied from row 4.
Hi Cartillo - have been busy but will look at your problem shortly.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hi,
Thanks for the help
Thanks for the help
Is this what you want?
//Scifo_dk
UpdateData-2.xls