+ Reply to Thread
Results 1 to 14 of 14

Matching Correct Box Item Numbers Based on Lookup

  1. #1
    Registered User
    Join Date
    06-23-2022
    Location
    USA
    MS-Off Ver
    Professional 2019
    Posts
    7

    Matching Correct Box Item Numbers Based on Lookup

    I don't really know where to post this or if its even possible. So I'm a baker making products for local customers in my area. I calculate the items I need to bake by putting orders into excel to total them up. I'm making set boxes for the first time and I wanted to know if it was possible to have an item like 4th Of July Box, and when I put 1 into the cell it will add the correct number of products per box into the cells. (See picture) I can also attach the actual file if needed.

    So when I put the 1 in the 4th of July box cell I want the above cells filled in with the corresponding numbers so I can tally the end of how many pasties are need in total for all the boxes... This is hopefully going to save me from manually adding each item. I do have some customers getting 2-3 boxes so if it could increase as I put 1, 2, 3, etc and the items doubling, tripling etc per the box quantity. I'm not sure if this makes sense. I don't really know enough about excel to know if this is even possible. Thank you for any input on this. I've been trying to figure it out for weeks. Thanks in advance!

    Attachment 784883

    The blue is where I'd like to put the box input and the red is where I'd like for the output quantity per product to be above in the red circle.

    I don't really need it done for me I just need to know what this type of function is classified as so I can further research it. Thank you!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by AliGW; 06-23-2022 at 01:57 PM. Reason: Solved tag added

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,736

    Re: Matching Correct Box Numbers Based on Lookup

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

    Administrative Note:

    Your thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. As you are new here, I have done it for you this time.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    06-23-2022
    Location
    USA
    MS-Off Ver
    Professional 2019
    Posts
    7

    Re: Matching Correct Box Numbers Based on Lookup

    Thank you for your understanding - I've attached the workbook

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,736

    Re: Matching Correct Box Item Numbers Based on Lookup

    Unfortunately, you haven't done it correctly and the attachment is reporting as invalid. Please try again using the instructions in the yellow banner at the top of the page. Once I can look at the workbook properly, I shall have further questions for you.

    EDIT: It has now appeared correctly - I am taking a look.

  5. #5
    Registered User
    Join Date
    06-23-2022
    Location
    USA
    MS-Off Ver
    Professional 2019
    Posts
    7

    Re: Matching Correct Box Item Numbers Based on Lookup

    Thank you for your patience, I'm still learning

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,736

    Re: Matching Correct Box Item Numbers Based on Lookup

    Mmm ... That hasn't really helped! Where will I find a list of the items that are included in a July 4th box? I am not clear how you expect this to work exactly.

    A reminder: a good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

  7. #7
    Registered User
    Join Date
    06-23-2022
    Location
    USA
    MS-Off Ver
    Professional 2019
    Posts
    7

    Re: Matching Correct Box Item Numbers Based on Lookup

    I'm looking for the information of how I can put a 1 into a cell - and then have it automatically populate the numbers I have per pastry box per item.

    I don't need specifics for this specific box, I just need to figure out how to do this generally so I can customize it as needed for future projects. Is this considered a macro? Can I use the record action feature to do this? Maybe I'm actually too new to know how to even explain this. I'm sorry

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,736

    Re: Matching Correct Box Item Numbers Based on Lookup

    Yes, I understand that. And it COULD be done with a formula, but it depends entirely on how the workbook is being used.

    For example, is it possible that someone will ALSO in the A1 column manually enter other items for this order?

    We will need to know EXACTLY how this sheet is meant to work, otherwise we haven't a hope in hell of being able to advise you.

    It might require a macro - I don't have enough information yet to be able to say.

    I don't really know enough about excel to know if this is even possible.
    This is the problem, yes, and as you have no previous experience, what you are probably asking is going to be beyond your capabilities, so you are going to need to have someone build an example for you to follow. For this we need specifics.
    Last edited by AliGW; 06-23-2022 at 10:07 AM.

  9. #9
    Registered User
    Join Date
    06-23-2022
    Location
    USA
    MS-Off Ver
    Professional 2019
    Posts
    7

    Re: Matching Correct Box Item Numbers Based on Lookup

    Great, thank you for your time and input. I will work on this and try again. Thank you for your response.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,736

    Re: Matching Correct Box Item Numbers Based on Lookup

    Please let us know when you have more specifics to share.

  11. #11
    Registered User
    Join Date
    06-23-2022
    Location
    USA
    MS-Off Ver
    Professional 2019
    Posts
    7

    Re: Matching Correct Box Item Numbers Based on Lookup

    Okay so hopefully this will illustrate the indented use of what I'm looking for. I wouldn't need to have the ability to add more to each order (column) other than the generated set quantities per box. I apologize for being so ignorant with using excel.. maybe I just need to go through several basic courses and figure it out.. I don't think I understand enough to even ask what I need.
    Attached Files Attached Files

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,736

    Re: Matching Correct Box Item Numbers Based on Lookup

    OK - this is very helpful.

    If the ONLY manual input will be the box numbers (row 11), then we can set up a formula to fill out the item details.

    I have set up an example of how this would work using this formula:

    =IFNA(VLOOKUP($A3,$A$36:$B$39,2,0)*B$11,"")

    I suggest you have a good look and then come back when you are ready to ask questions and/or try to scale this to work in your actual workbook.
    Attached Files Attached Files

  13. #13
    Registered User
    Join Date
    06-23-2022
    Location
    USA
    MS-Off Ver
    Professional 2019
    Posts
    7

    Re: Matching Correct Box Item Numbers Based on Lookup

    This is awesome - I think this is exactly what I'm looking for. Thank you for your time and patience through helping me communicate what I was looking for. I really appreciate it <3

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,736

    Re: Matching Correct Box Item Numbers Based on Lookup

    You’re welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Dynamic macro name / Concatenating macro name / Call a string variable as a macro name
    By vwhite in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-18-2020, 03:36 AM
  2. [SOLVED] macro showing error ( macro not found ) while trying to execute macro every 1 minute
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2018, 07:58 PM
  3. [SOLVED] Define variable in macro than calling that macro inside another macro
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2015, 10:58 AM
  4. [SOLVED] Macro to show Which macro didnt work in a nested macro
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-10-2013, 03:21 AM
  5. Perform macro "on open" specific file- store macro in Personal Macro Workbook?
    By thompssc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 12:38 PM
  6. lookup macro, solver macro, realtime macro
    By xelhelp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2011, 06:14 PM
  7. Cannot find macro error when running a macro from a macro in a diffrent workbook.
    By Acrobatic82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 09:22 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1