Searching Multiple Worksheets for Multiple Entries & Combining into one worksheet

Gentlemen,

I've hunted high and low on this, and many other forums without success - I need assistance in completing my spreadsheet it would seem.

I'm trying to create a spreadsheet, that through the use of 'user forms' will allow one of my clients to enter the dimensions of the various cupboards he wishes to make - all slightly different in size thanks to the Architects of the world...

Once these dimensions are added into the form (W x H x D) they are put into a 'summary' list on the front page. Once the client has finished creating all the cupboards he wants to add, at the press of a button I need excel to check the main summary page (name 'Architectural_Cabinets') for what sort of cabinet it is - (this data is listed in column A, rows 2 and below). Once this has been done, I need Excel to go to the next worksheet (named 'Architectural_Components') and copy the components of the defined cabinet (either Rail top, or Solid Top - these components include tops, backs, sides, shelves etc) and then paste this list of components into a third and final worksheet (named 'Architectural_Cabinet_Output').

Finally, just to make it really confusing I need the quantity that was entered on the main summary page to be put into all the components aswell.

I've tried using If, Then Else statements unsuccessfully. Unfortunately my Excel - VBA and basic Formula understanding is fairly low, so I'm open to any and all suggestions.

To make it as easy as possible I've included a sample of the sheet I'm working from. To all you Excel & VBA purists - I apologise for hacking your code - as above I'm still learning...

Thanks and Regards,

Nick

Nick

I've created a macro which will copy each workpiece for each of the Part IDs listed on the sheet 'Architectural_Cabinets'. But I'm not sure how the dimensions specified on the 'Architectural_Cabinets' sheet affect what you want to be output.

Have a look and let me know if you need some changes.

Dion

Thanks Dion,

I appreciate your help. After a very long sleepless night I managed to rangle something that does what I need, but your code looks alot cleaner than mine - might actually see how to do it properly...

Thanks again, if I have any more issues I'll be sure to pop another thread up.

Cheers,

Nick

-ADMIN- -- Please mark as solved.