dkurschner
New Member
- Joined
- Feb 25, 2009
- Messages
- 3
Hi All! I am BRAND NEW to this board and my Excel skills are quite marginal compared to the Think Tank on this great message board. I have an ongoing project that has many questions I'd like to pose. I will only start with one question and hopefully you guys/gals are willing to help me "learn how to fish" a little bit better.
As seems to come up fairly often in Excel message forums, I've built (but not completed) a spreadsheet used to organize multiple Bill of Material lists. This list is a row-by row list of products with information relating to a specific part number including: Mfg, Part#, Qty Used, Cost Ea, Vendor, among many more.
Here's what I'm trying to accomplish first. As this list grows, my intension is the be able to recall a row of data (or control what columns of the row are recalled) from this list and be able to easily add them to the list. I would like to be able to do this by typing in data in one cell in the row (like the Part#), and then have a macro or VB code that will automatically fill in a defined number of columns with the descriptive data like: Mfg, Cost Ea, Vendor, etc.
Currently, the data for the rows (if it already exists) would reside higher up in the list on the same worksheet but could also potentially be on another tab in the workbook.
Is this a daunting task or is it do-able for a excel user without any VBA or much macro experience? Your help would be greatly appreciated .
As seems to come up fairly often in Excel message forums, I've built (but not completed) a spreadsheet used to organize multiple Bill of Material lists. This list is a row-by row list of products with information relating to a specific part number including: Mfg, Part#, Qty Used, Cost Ea, Vendor, among many more.
Here's what I'm trying to accomplish first. As this list grows, my intension is the be able to recall a row of data (or control what columns of the row are recalled) from this list and be able to easily add them to the list. I would like to be able to do this by typing in data in one cell in the row (like the Part#), and then have a macro or VB code that will automatically fill in a defined number of columns with the descriptive data like: Mfg, Cost Ea, Vendor, etc.
Currently, the data for the rows (if it already exists) would reside higher up in the list on the same worksheet but could also potentially be on another tab in the workbook.
Is this a daunting task or is it do-able for a excel user without any VBA or much macro experience? Your help would be greatly appreciated .
Last edited: