I asked these questions the last couple of days, but didnt get the response
I needed so I decided to try once more.

First Question (easy I believe):
Can someone please tell me how to get Excel to prompt me for a desired
folder (inside my macro) instead of always requiring me to hardcode the
desired folder itself into the macro?

Second Question:
How do I make a cell equal to another cells value (and hardcode it) and not
that other cells revolving formula (without using a macro)? For example:
Cell X is set up to read the current date
Cell Y is an empty cell that the user will either leave blank or place an €œX€�
I need cell Z to read cell Y and if there is an €œX€� then I need the date in
cell X to be HARDCODED into cell Z.

I received some helpful information on the second question, but it stopped
short of telling me how to hardcode the desired information. Can someone
please help?