My company sometimes requires a street map of the job location on our drawings. Typically we would just search mapquest, or a similar website, and paste that image onto the sheet.
I'm wondering if there is better way to accomplish this, the method I use is cumbersome, not very clear and slows...
Is there a macro or any other way to create a copy of a sheet (eg. Page1) with a successive page number (eg. Page2) everytime the macro is run?
Also, is there a way to reference a worksheet only if the sheet exists?
i.e.
='P-to-P #1'!A62+'P-to-P #2'!A62+'P-to-P #3'!A62+'P-to-P #4'!A62
but...
I have been given an assignment to create an all encompassing Voltage Drop calculator that will also create a material list and battery calculation for a low voltage system.
The problem i find myself running into is the amount of data i need. it appears i would need a unique file for each...
