Got a little problem here that some might be able to solve for me.
I'm creating a spreadsheet that takes data from another file and includes it on this spreadsheet. So far no problems. Now I want to be able to use cells D1 and D2 to name the workbook in the other file where the data comes from.
The current formula is
='[Budget2002.xls]February 2002'!B14
I want to be able to use D1 and D2 like this:
='[Budget2002.xls]D1&" "&D2'!B14
Is there a way to do this without using VB or macros? (Haven't really gotten the hang of them yet)
Also, how do I stop the users from going to a protected cell? Right now if I protect it, the user can still click on it but not change it. (a dialog box comes up) Is there a way of protecting the cell where the user can not select it at all in Excel 2000?
Thanks;
I'm creating a spreadsheet that takes data from another file and includes it on this spreadsheet. So far no problems. Now I want to be able to use cells D1 and D2 to name the workbook in the other file where the data comes from.
The current formula is
='[Budget2002.xls]February 2002'!B14
I want to be able to use D1 and D2 like this:
='[Budget2002.xls]D1&" "&D2'!B14
Is there a way to do this without using VB or macros? (Haven't really gotten the hang of them yet)
Also, how do I stop the users from going to a protected cell? Right now if I protect it, the user can still click on it but not change it. (a dialog box comes up) Is there a way of protecting the cell where the user can not select it at all in Excel 2000?
Thanks;