carolinera
Registered User.
- Local time
- Yesterday, 23:55
- Joined
- Oct 15, 2001
- Messages
- 20
I'm exporting a report from Access into excel which has a different name each time during the export function. This worksheet then becomes part of another worksheet by being referenced into certain cells.
My question is: I would like the user to be prompted to type in the new worksheet that was exported from Access and then all those cells that are reference in the other worksheet be updated automatically.
Having never done a macro with this sort of criteria I'm needing a little help.
Thank you to all that have a look at my question and thanx to those that are able to help.
- Caroline
PS: I you should need a copy of the worksheet I'm trying to update please let me know and I'll send a copy
I have also posted this in the Excel forum.
My question is: I would like the user to be prompted to type in the new worksheet that was exported from Access and then all those cells that are reference in the other worksheet be updated automatically.
Having never done a macro with this sort of criteria I'm needing a little help.
Thank you to all that have a look at my question and thanx to those that are able to help.
- Caroline
PS: I you should need a copy of the worksheet I'm trying to update please let me know and I'll send a copy
I have also posted this in the Excel forum.
