Hello,
On the BULLETIN# & KIT# sheet I would like to enter the kit in cell B4 and have the list of parts and their descriptions for that kit. Is this possible to do?
Thank you very much for your help
Hello,
On the BULLETIN# & KIT# sheet I would like to enter the kit in cell B4 and have the list of parts and their descriptions for that kit. Is this possible to do?
Thank you very much for your help
Hi,
Please try this file
Put your BULLETIN# & KIT# in Cell B4 and click on the Blue Box below it
Note: I have renamed the Sheet name by just removing #
Please Login or Register to view this content.
Cheers!
Deep Dave
Thank you so much that is amazing! My next task is to incorporate the other sheet into this one. Any ideas please? Or should I start another thread?
Hi,
I was just going through the sheet, let me bring to your notice that, the code only takes into consideration Columns G, H & I. I am not sure if you need the code to consider columns J - X.
If yes please let me know what exactly needs to be done
Oh yes I do and in fact I need to add more columns for the other sheet.
Please guide me what the code exactly needs to look for?
Not looking for but I just need to move the data from the other sheet first then utilize your code to allow for the extra columns of data.
I am kind of getting an idea, however, can you be a bit more specific with your requirement as I am still unable to completely contemplate what you expect the code to do.
I am understanding there are 2 separate requirements -
1) Move the data from the other sheet - I need more details on this
2) Allow for the extra columns of data. Currently based on the BULLETIN# & KIT# thats mentioned in Cell B4, my code scans through the I column and gets the corresponding values in Col G & I. You want me to scan through all the columns from BULLETIN# & KIT#1 - BULLETIN# & KIT#16 and get the corresponding values in Col G & I and paste it one below other in the table8 on Column D & E. Is my understanding correct?
I will return soon. Thanks for your help.
You are welcome
The results from the code are not accurate. Can you take a look please
Last edited by BobBrown60; 03-11-2021 at 08:41 PM.
Hi,
The result from my Code are accurate, although it only picks up from the I Column. That's what I have been saying in the past few posts and #8 has asked for clarification
Yes 2 requirements. I need to move the data from the other sheet but not sure how. There are parts listed with descriptions and the third column has the bulletin and kit numbers. These need to move to the sheet so there will be more than 16 columns to search for there. I hope you can help thanks.
Last edited by BobBrown60; 03-12-2021 at 04:28 AM.
HI,
Please see the file attached. This should take care of picking parts from those additional columns.
Can you confirm if the Parts & Description being returned is fine now?
Also, I have named a couple of cells. Its always a good practice to do so while working with ranges is VBA.
Note: I have assumed all the Column names will be BULLETIN & KIT #1, only the number after the # will change
VBA Code for reference -
Please Login or Register to view this content.
Last edited by NeedForExcel; 03-12-2021 at 04:54 AM.
Yes it seems to be accurate for the parts thank you. That takes care of one of the requirements. The next is to move the data from the other sheet please. I made some editing to highlight the cells that equal B4 to check all that apply.
Last edited by BobBrown60; 03-12-2021 at 05:30 AM.
Hi,
Glad the file worked for you.
Regarding the 2nd requirement, please explain me the logic how the data needs to be moved. What data should go where and all the things.. If you can explain me the requirement properly in depth, then it will be easier for me to code..
On the sheet that has the long 3 columns of data the 3rd column has the bulletin and kit numbers that when grouped will have the list of parts with their descriptions next to them. So in order to move the data to the other sheet the new bulletin and kit number will be added on the row for each part number. So there will be added columns to allow for these additions.
I hope I have explain the proper details.
Thank you very much for your fantastic help.
Maybe you have a solution on how to move the data.
Last edited by BobBrown60; 03-13-2021 at 05:24 AM.
Hi Bob, sorry for the late reply.
Moving data from one sheet to another is a pretty easy VBA code, but even after you explanation I am unable to understand what exactly needs to be done.
If you can maybe replicate only those 2 sheets in a sample file and demonstrate a Before and After sheet for me to understand what the code exactly needs to do, it will be really helpful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks