VB code - To Speed up process

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

Hi,

For a quick start ...
Turn on the macro recorder
and proceed with your actions once ...
then you will visualize how VBA has coded your actions

then will come the time to add a loop for VBA to repeat the routine 90 times


HTH
Carim

Carim,

That has helped, Such a simple way and i cant believe i didnt think to do it. However i now realise that in when i copy the cells there may be some blank cells. Is there a way to get rid of these cells in the master sheet when im running my code?

Test

Hi,

Once your code is up and running, you will always be in a position to include a routine to test and delete blanks ...

HTH
Carim