excelhelp123
New Member
- Joined
- Feb 20, 2009
- Messages
- 2
Hello all, I have a fairly difficult question.
I have two sheets, one with general data like employee name, address, phone, and another column for a "Yes/No." This sheet can contain up to 50 lines of data.
On the other sheet, I have a table in the middle of the spreadsheet (there's information above it and information below it). I need the information on the previous sheet to populate this table automatically if there is a "Yes" filled in.
Now obviously I can do an "IF" statement, but there could be up to 50 lines on the previous sheet, and I only have room for 10 people on the second sheet. Also, I need them to be in order, so that there aren't any blank lines in between the "Yes" ones.
In a way I need excel to crawl through the first sheet and pick out, line for line, which one has Yes. And then populate the second sheet with this information. I hope this makes sense and I thank everyone in advance for any help.
Thanks!!!
I have two sheets, one with general data like employee name, address, phone, and another column for a "Yes/No." This sheet can contain up to 50 lines of data.
On the other sheet, I have a table in the middle of the spreadsheet (there's information above it and information below it). I need the information on the previous sheet to populate this table automatically if there is a "Yes" filled in.
Now obviously I can do an "IF" statement, but there could be up to 50 lines on the previous sheet, and I only have room for 10 people on the second sheet. Also, I need them to be in order, so that there aren't any blank lines in between the "Yes" ones.
In a way I need excel to crawl through the first sheet and pick out, line for line, which one has Yes. And then populate the second sheet with this information. I hope this makes sense and I thank everyone in advance for any help.
Thanks!!!
