Excel Query for data Consolidate

[Dnyan]

Hi,

I am preparing a Tracker for five teams.
In one excel file there are five sheets which is filled by data of five teams.

Wants to Consolidate all sheets some selected column data in one main sheet.

So searching for formula or coding.

Regards
Dnyan

 

[VoG]

Hi. This should help you

http://msdn.microsoft.com/en-us/library/cc793964.aspx

 

[Dnyan]

Hi

Thank you Vog, I will check this code.

Thanks again

Regards
Dnyan