PDA

View Full Version : How to Lookup data from different sheets to single workbook



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.

GTO
04-05-2011, 03:53 AM
...You can download the workbook by clicking this url (http://www.vbaexpress.com/forum/...)

Hi there,

As long as the size is not excessive, you can attach a wb to your post. Click the <Go Advanced> button, and in the new window, scroll down and you'll see the <Manage Attachments> button.

halimi1306
04-05-2011, 10:23 AM
Hi there,

As long as the size is not excessive, you can attach a wb to your post. Click the <Go Advanced> button, and in the new window, scroll down and you'll see the <Manage Attachments> button.


I've tried few time but fail to upload due to wb size is 4.4MbManage Attachments Upload Errors10MP Consolidated Initiatives Model v.2.zip:
Upload of file failed.