Billa7
asked on
Copy Data
I need Experts help create macro to copy data from Source sheet to Data sheet. If data available in Column I (Source), copy data of the row (Column A,B,C and I) to Data sheet. The copy process should always take the new row at Data sheet, should not overwritten the old data . Hope Experts could help.
Count.xls
Count.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I found that the data is copied to much lower (around row 1,900) of the data sheet due to I used "sd.UsedRange.Rows.count" which sets the last used row in the Data sheet.
If you want to put the data to begin at row 2, you need to delete all the data except the header row (row 1).
If you want to put the data to begin at row 2, you need to delete all the data except the header row (row 1).
ASKER
Hi,
Thanks a lot for the help.
Thanks a lot for the help.
ASKER
I have tested, the data was not copied to Data sheet.
Count1.xls