Make a Summary Sheet

[BSOD14]

Hi,

I would like to pull certain rows from a sheet based on a "Completion Status" in one of the columns to a new sheet that will serve as a summary of the larger (and original) sheet. Please could someone point me in the right direction with this.

Thanks.

[Pete_UK]

I've demonstrated this a number of times on this forum. You can achieve it with 3 basic formulae - one sets up a unique ID on the data sheet (usually based around COUNTIF or MAX), a second one on the summary sheet then identifies the rows on the data sheet where those unique IDs occur (using MATCH), and then the final one brings the data from the appropriate column(s) based on the row (using INDEX). If you attach a sample workbook I can give you the exact formulae to use, based on how your data is arranged - the FAQ describes how to attach a workbook.

Hope this helps.

Pete

[BSOD14]

I've demonstrated this a number of times on this forum. You can achieve it with 3 basic formulae - one sets up a unique ID on the data sheet (usually based around COUNTIF or MAX), a second one on the summary sheet then identifies the rows on the data sheet where those unique IDs occur (using MATCH), and then the final one brings the data from the appropriate column(s) based on the row (using INDEX). If you attach a sample workbook I can give you the exact formulae to use, based on how your data is arranged - the FAQ describes how to attach a workbook.

Hope this helps.

Pete

Thanks a lot for your input: it's very much appreciated. I won't be able to upload the workbook, but any example you can attach would be great. It's as simple as if a cell (in a column) contains "Not Ready" or "Nearly Ready" or "On Hold", I would like to copy this entire row to a new sheet. I'll try and have a go at it myself now.

Thanks again.

[BSOD14]

I've had no joy so far and I'm not sure why.

"Excel for Dummies" is going on my Christmas list...

[Pete_UK]

Here's a link to a recent thread on a similar topic where there are two attachments:

http://www.excelforum.com/excel-form...html?p=3019833

Perhaps you can amend one of these to suit your requirements.

Hope this helps.

Pete

[BSOD14]

Thanks again for your help.

I ended up playing with that macro button and got the thing to work. Splendid.