Guys,

I'm new here and I need a macro will will allow me when ran to prompt me to choose a file once that file is chosen it needs to copy certain specific cells then copy that data into certain specific cells in different locations on the sheet i have open, is this even possible. Also on the worksheet im attaching it has calculators for measurement say 8lyr sheet references 8lyrdata sheet in 8lyrdata i have 4000 if and functions can someone look and see if there is an easier way to get this done? Never mind Can someone send me there email so i can show them the file.