Excel help required! [Closed]

Report
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
-
Hello,

Hoping you guys and gals can help.

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.

Is this possible.

Phil




1 reply

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
Hi Phil,

This is possible.

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.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!