vassili
06-05-2007, 08:30 PM
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.
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.