ExcelBanter - To copy Data from a row in one wrokbook and insert in a sheet of another workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - To copy Data from a row in one wrokbook and insert in a sheet of another workbook (https://www.excelbanter.com/excel-discussion-misc-queries/446095-copy-data-row-one-wrokbook-insert-sheet-another-workbook.html)

harishchet

To copy Data from a row in one wrokbook and insert in a sheet of another workbook

I have 2 Workbooks...Workbook1 and workbook2.

I have to copy data from sheet1 in Workbook1 and insert to the 2nd row in sheet1 of workbook2.

Data can be of more than 1 row so this has to be inserted form Row2 of sheet1 in workbook 2.

Hoping I am clear with my explaination.

Thanks and Regards
HC

All times are GMT +1. The time now is 04:08 PM.