Copying specific data from one workbook to another

sth289

New Member
Joined
May 2, 2018
Messages
3
Hello,

I've two workbooks and one of them is a stock workbook that has new stocks once every week. In the stock workbook It needs to copy starting from (A2:J2) to the other workbook sheet1(A2),then (A3:J3) to sheet2(A2) and all the way to sheet100 (A2).

However, if by any chance that copying the next line has the same order number they will be place in the same sheet instead of seperate sheets.

Thanks
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,108,973
Messages
5,525,978
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top