Results 1 to 2 of 2

Thread: Complex function
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2019
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)

    Default Complex function

    Good afternoon Dear All,

    Firtsly i would like to apologize if my question contains any misunderstandings.
    I have a workbook where there are many sheets with many informations but i want to take a specific value from all those sheets.
    Imagine that there are lists of products per category in each sheet and i want to take the values from the cells with the purchased qty to a another sheet(in order to gather all those quantities to this sheet).,if each qty is bigger than 0.
    I tried to achieved that through Vlookup but it seems that it will be very complex(in matter of fact, i confused a lot)
    Do anyone have any idea ? by using Vlookup or through developer?

    Thank you all very much in advance

  2. #2
    Board Regular
    Join Date
    Nov 2006
    Post Thanks / Like
    21 Post(s)
    2 Thread(s)

    Default Re: Complex function

    Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
    You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts