I am currently uploading many items on to a website. I have a spreadsheet with all the different suppliers on a separate worksheets, which shows each of the items from each supplier. I have conditionally formatted each sheet to clearly see which items have and have not yet been uploaded.
What I need, is a sheet at the front, that pulls all the items from each sheet that have not yet been uploaded to create an overview.
It's easiest if you upload your file using a filesharing site like www.speedyshare.com and post back the link.
Then tell me which color needs to be copied to the front sheet (overview).
Do you only want to copy the colored cell or the entire row?
Please be as clear as possible as to what you want to achieve.