thanks for the reply. the difference in the file types is the really the core of the problem.
i've considered just tracing over the image, just wondered if there was a better solution.
again, thanks for the reply
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...
Thank you everyone for your replies.
The repitition I come across is mostly from the different formats for the same information in different worksheets. on my voltage drop I need certain info, on the material list other info but some is the same for the exact same items. I should probably...
This is the explanation of the array formula I used for the same type of multiple criteria counting. Worked really well for me.
http://www.mrexcel.com/tip031.shtml
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...
