Hello -

Previously I got help from this forum with the code below. In a nutshell, it allows the used to select a template from a drop down and when the form is submitted it pulls all matching items from the Templates sheet and copies them over to the Invoice sheet.

I need to move the Templates sheet to another workbook (on a shared drive). How would I modify the code below to make this work?

Thanks again for all your help! 

Please Login or Register  to view this content.