List of Parts for Kits

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.

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

Please guide me what the code exactly needs to look for?

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?

You are welcome

The results from the code are not accurate. Can you take a look please

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.

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.

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.

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..

Maybe you have a solution on how to move the data.

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.