# Condense Information from 3 Different Sheets to a Summary Sheet in the Same Workbook

#### jk426

##### New Member
I am setting up a workbook in Excel 2010 where information will be put into three different worksheets by different people. Each sheet is set up to populate a cell two columns over with a unique three character identifier (over 22000 different possibilities between the three sheets) if the cell in column A has information in it.

I am trying to condense the information from those three sheets into one summary sheet. Since each sheet has over 7000 possible rows, I would like to pull out any blank cells from the original sheets when it is being copied over to the summary sheet. So far I have the following formula:

=IFERROR(INDEX('Crew 1 Plan '!A8:A7349,SMALL(IF(ISBLANK('Crew 1 Plan '!A8:A7348),"",ROW('Crew 1 Plan '!A8:A7348)-MIN(ROW('Crew 1 Plan '!A8:A7348))+1),ROW(A1:A22032))),"")

This works to bring the information over how I want it from the first sheet (Crew 1 Plan), but I haven’t been able to work out the nested formula to bring in the information from the other two sheets (i.e. Crew 2 Plan and Crew 3 Plan).

Thank you in advance for any help.

Here is a link to the workbook on OneDrive:

https://onedrive.live.com/redir?resid=91FF733170F37244!544&authkey=!ANWGyOAsjlv7Fak&ithint=file%2cxlsx

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Replies
0
Views
1K
Replies
1
Views
166
Replies
30
Views
2K
Replies
1
Views
394
Replies
7
Views
284

1,196,369
Messages
6,014,884
Members
441,854
Latest member
Amstaff

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back