phoenix
Phoenix - Your AI Assistant (BETA)
Inactive session will be ended in 24 hours
End Session

Excel Filter Menu

  • Posted:
  • Proposals: 29
  • Remote
  • #1626352
  • Awarded
Aidan H.Narendra S.Pradeep S.Boyd W.Islam A. + 24 others have already sent a proposal.
  • 1

Description

Experience Level: Expert
Description of excel work: We have a spreadsheet tracking our sales. We have 4000 rows of products. I then filter them using 6 columns, eg one for style, second column for colour, third column for size, and so on.
My colleagues can use excel but it is time consuming to filter all 6 columns properly.
is it possible to have a front sheet that will have the filter options from the 6 columns of filter, so Style A, Style B etc in first column and Red, Yellow etc in next column. With a tick box that they choose. So they may choose Style M and Color Red and size 10, and the spreadsheet will auto filter to this. Or they may only tick size 10 to see all size 10 , or Color Blue to see all blue products

I hope i have made myself clear
Extra notes:

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • Tony H.

    I David,

    I cancelled my proposal as I had run out of time for today. However, I see that you still haven't found a freelancer for your project. So, if you would like to send me a copy of your spreadsheet we can discuss in more detail.

    Regards
    Tony H

  • TSOLUTIONS

    David

    Can you share a sample file with 2 or 3 records for viewing.

  • Tony H.

    Hello David,

    Would I be able to see a sample of your spreadsheet, perhaps 50 rows of products. I will then come back to you with options.

    I take it you manually add new product lines to the spreadsheet.

    Regards
    Tony H