selecting data from ranges and pasting into new excel sheet 2

[smurf01]

I have an excel work sheet that uses 240 columns, every four columns containg data relating to a specific day and I have 40 rows set up to contain the info, the columns use the following headings

Customer Order Number Quantity Username

As you will quickly work out that means that the columns store data for 60 days ( 240 / 4 = 60). What I want to do is to copy the data from cols A,B,C,D and the rows that contain data into another sheet then I want to copy the data from E,F,G,H and the rows and paste them below the data from A,B,C,D, and so on until I have copied all the data. So in my new sheet I will only have four columns using the headings as shown below to form a table. this table will then be linked to an access query for further data extraction.

Can anyone help me
Regards

Paul

 

[smurf01]

Combo,
Thanks for the information, I know that perhaps I am trying to be too clever sometimes with my limited knowledge of VBA, but I am learning especially from people like Mike and Your Good Self

Regards

Paul