halimi1306
04-05-2011, 01:00 AM
Hi All,
I want to lookup data from 85 sheets to a single workbook as summary and also to skip blank. My problem is every sheets have different no of row but same no of column. Now i used indirect funtion to lookup all those data but can't skip blank and i have to enter the formula manually.
FYI
Problem to solve:
Import data from sheet "'"-innitiative (85 template sheets) to Model Engine
Sorting data in order from 1 to 85 in Engine Model and also skip blank
Sort sheet in order after importing the sheets to model, now if you look at the order in model will be as follows : 01-, 10,11, 12, 13,14,15,16,17,18,19,02,20...03,30,31...04,40,41... and so onYou can download the workbook by clicking this url:
http://dl.dropbox.com/u/20522137/10MP%20Consolidated%20Initiatives%20Model%20v.2.zip
TQ in advance.
I want to lookup data from 85 sheets to a single workbook as summary and also to skip blank. My problem is every sheets have different no of row but same no of column. Now i used indirect funtion to lookup all those data but can't skip blank and i have to enter the formula manually.
FYI
Problem to solve:
Import data from sheet "'"-innitiative (85 template sheets) to Model Engine
Sorting data in order from 1 to 85 in Engine Model and also skip blank
Sort sheet in order after importing the sheets to model, now if you look at the order in model will be as follows : 01-, 10,11, 12, 13,14,15,16,17,18,19,02,20...03,30,31...04,40,41... and so onYou can download the workbook by clicking this url:
http://dl.dropbox.com/u/20522137/10MP%20Consolidated%20Initiatives%20Model%20v.2.zip
TQ in advance.