formula(s) for creating new sheet comprised only of highlighted cellsfrom another sheet?

[Jason Shapiro]

I currently have a workbook containing 15 worksheets with hundreds of cells per sheet. It contains data of which only a small portion will have future value for me. I have background-highlighted Yellow cells of important value (to revisit and analyze at a future point). Is there a way to create an additional sheet that itemizes only the highlighted cells from the other sheets? Is there a way to better 'echo' important data to a new sheet, or list?

 

[Don Guillett]

I currently have a workbook containing 15 worksheets with hundreds of cells per sheet. It contains data of which only a small portion will have future value for me. I have background-highlighted Yellow cells of important value (to revisit and analyze at a future point). Is there a way to create anadditional sheet that itemizes only the highlighted cells from the other sheets? Is there a way to better 'echo' important data to a new sheet, or list?

Send your file with version _____and a complete explanation and before/after examples to dguillett1 @gmail.com

 

[Puppet_Sock]

I currently have a workbook containing 15 worksheets with hundreds of cells per sheet. It contains data of which only a small portion will have future value for me. I have background-highlighted Yellow cells of important value (to revisit and analyze at a future point). Is there a way to create anadditional sheet that itemizes  only the highlighted cells from the other sheets? Is there a way to better 'echo' important data to a new sheet, orlist?

It's fairly straightforward in VB. It would be tedious and annoying in
only spreadsheet functions.
Socks

 

[Jason Shapiro]

Don, THANK YOU! Your services have proven to be invaluable and have saved me much time.