Copy specific data from different sheets to new worksheet

[Majid2009]

Hi;

I have several sheets in one Excel file, I want to copy specific data from all these sheets to new worksheet. This is example of my sheet, I have highlighted the data to be copied:

Ex1:


EX2 of another sheet:


This is what I want to get to by creating macro:


Can you please help?

Note that columns F & G are not same range in all sheets.

Thanks in advance.

 

[ColinKJ]

Hi Majid2009,

I'm not going to be around for the next couple of days, but I would like to stay in touch with this challenge.

ColinKJ

 

[Majid2009]

Hi Majid2009,

I'm not going to be around for the next couple of days, but I would like to stay in touch with this challenge.

ColinKJ

I am still waiting for somebody to face this challenge.

 

[ColinKJ]

Hi Majid2009,

I'm sure I can help, but you will either need to copy and paste the examples, into a post so I can copy them to use as data, or you'll have to email me an example.

Regards

ColinKJ

 

[Majid2009]

Hi;
THis is the link to the xls file where I have the sheets to be summarised, note that I made small change and I included a macro of my trials:

http://up2.m5zn.com/download-2009-3-28-08-0cnjxqtuf.xls

and this is what I want to get to by having a macro, I have only done it for two sheets in this example:
http://up2.m5zn.com/download-2009-3-28-09-5a00wtfd1.xls

Thanks.

 

[Majid2009]

and this is how to download from that site:


Thanks again

 

[ColinKJ]

Hi Majid2009,

I've tried twice to download from both links, but I can't get past the security code.

I'll send you a private message with my email address, and you can email them to me.

ColinKJ

 

[Majid2009]

Hi Majid2009,

I've tried twice to download from both links, but I can't get past the security code.

I'll send you a private message with my email address, and you can email them to me.

ColinKJ

Thanks Colin for your help. You have solve it for me.
All the best.