file search/auto import in excel 2000

[vassili]

i need to get excel to automate some things. i want to create a spreadsheet where, when opened, it prompts the user for a reference number, then based on that number, it pulls up another spreadsheet inside the hard drive somewhere with that ref. number being part of the file name.

then, i need to have excel auto calculate totals from the spreadsheet it just pulled up.

what's the best way about doing this? i haven't touched macros in years and don't know where to start with VBA.

any help would be appreciated.

[geekgirlau]

I would start by recording the steps that you've outlined (i.e. open the spreadsheet related to the reference number, then calculate totals from that spreadsheet), and then we can look at the next steps.