Hello

I would like to create a series of worksheets that will act as modules that can be imported into a master template to create an equipment list for a commercial building. Each module represents a type of equipment such as an air conditioning unit or a water heater, while the equipment list can have multiple pieces of the same type of equipment. The modules are formatted with borders, text boxes and form check boxes.

Using the Import Data command does not import the check boxes or the formatting other than the font formatting. Borders and text boxes do not import. Cut and Paste works reasonably well, without the check boxes, but it would be cumbersome and prone to error for a user to cut and paste potentially over a hundred files.

What I would like to do is use a command key or button to activate a macro or VBA code to open a dialog box containing the modules to be imported, and allow the user to select the module and import it to the last active cell, with all formatting and check boxes intact.

I can live without the checkboxes if need be, but I do need to find a way to automate this process. Any thoughts would be greatly appreciated.

Thanks
Doug