Hi all,

Ok here’s my query, I have a price book with around 90 sheets and 10 columns of X lines of data in each sheet. I want to write a piece of code which will Take columns G and K out of each sheet and paste them into a new file (say SAP.xls). I only want the code to pick up cells with numbers in and copy them only. The data from sheet 4 should be below sheet 3 and the after 4; sheet 5 will dispense its data below.

This has been bugging me for days and I know you guys can help me.

Please ask me for more information if you need it, I'll be online waiting.

Thanks all; I would appreciate any kind of comments.

Test