Pull data from the mainsheet based on the condition on subsheet and display the result on the outputsheet

[tomsh]

I have an excel file that has 3 sheets (Mainsheets - That has all the data)
sheet 2 - (Sub - this sheet has a particular column id that matches column id in the mainsheet).
Sheet 3- Final output sheet which shows the data pulled from the main sheet for the ids mentioned in the subsheet.

 

[hiker95]

tomsh,

Welcome to the MrExcel forum.

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?


To start off, and, so that we can get it right on the first try:

Can you post screenshots of the three actual raw data worksheets?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?


To post a small screen shot try one of the following:

Excel Jeanie
Download

MrExcel HTML Maker
https://onedrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189

Borders-Copy-Paste
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

To test the above:
Test Here


Or, you can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.