Excel - I want to link sheets in excel to a master sheet in excel

Asked By RASHID EXCEL QUERY on 08-Apr-10 02:51 AM
I have 12 sheets, 1 fr each month of the year showing hourly data. I want to
create 13th master sheet with advance filter linking the 12 sheets so that i
can get data form criteria "date from, date to" and "time from, time to". How
do i Link the Sheets? for Advance filter? I use Excel 2007.




ozgrid.com replied to RASHID EXCEL QUERY on 08-Apr-10 02:59 AM
AdvancedFilter wont link your sheets, but Consolidation might;
http://www.ozgrid.com/Excel/consolidate.htm