M
mkerstei
I need to do three things, if you can answer any of them that would b
great.
First, is there a way to make a macro that goes directly to the "Ope
File" screen? What about linking it to a folder name?
Second: I have a worksheet set up to pull information from a secon
sheet, which needs to be imported first. All the equations return #RE
until the text file is imported, which is named Sheet1 by default.
wrote all my equations to pull from Sheet1, but if a new sheet get
imported, I need it to pull from that sheet, Sheet2 (default). M
equations won't change to Sheet2, or Sheet3, or whichever, is there
way I can do this?
Third. I am trying to set up a summary sheet that pulls from separat
workbooks. Is there any way or macro that will let this summary boo
automatically pull the same cells from ANY new excel file put in th
folder? If not, is there a way to have the summary page automaticall
update off of the workbooks put into it every time it opens?
Let me know if you think of anything...thanks
great.
First, is there a way to make a macro that goes directly to the "Ope
File" screen? What about linking it to a folder name?
Second: I have a worksheet set up to pull information from a secon
sheet, which needs to be imported first. All the equations return #RE
until the text file is imported, which is named Sheet1 by default.
wrote all my equations to pull from Sheet1, but if a new sheet get
imported, I need it to pull from that sheet, Sheet2 (default). M
equations won't change to Sheet2, or Sheet3, or whichever, is there
way I can do this?
Third. I am trying to set up a summary sheet that pulls from separat
workbooks. Is there any way or macro that will let this summary boo
automatically pull the same cells from ANY new excel file put in th
folder? If not, is there a way to have the summary page automaticall
update off of the workbooks put into it every time it opens?
Let me know if you think of anything...thanks