macro to copy range of data between worksheets

B

beginxl

Joined
Oct 30, 2007
Messages
1
Reaction score
0
Can anyone help me in creating a macro to copy specific range of data from one worksheet to another?
Example:
sheet 1 has the following data from A2:Y10
shift Job place
1 FL dallas
2 PT houston
2 FL austin
1 PT dallas

Now, I need to copy data


from sheet1 copy shift1 and job=FL to sheet2 from cell 2 to cell 9;
from sheet1 copy shift1 and job=PT to sheet2 from cell 10 to cell 14;
from sheet1 copy shift2 and job=FL to sheet2 from cell 15 to cell 19;
from sheet1 copy shift2 and job=PT to sheet2 from cell 20 to cell 24;

Is it possible? if so, can anyone send me a macro template?
thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPY DATA IN SPECIFIC WAY 5
loop to copy paste 5
Copy data from Single cell to Merged cell 4
Copy Range of data using VBA 0
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Excel 2013 Merge Data 2
sort macro not working 1
copy cell B19:J19 Range data’s from sheet1, and to past in sheet2 4

Top