Results 1 to 2 of 2

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

  1. #1
    New Member
    Join Date
    Oct 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    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
    Location
    London
    Posts
    8,254
    Post Thanks / Like
    Mentioned
    21 Post(s)
    Tagged
    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

    https://www.mrexcel.com/forum/about-...tachments.html

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
  •