Hi all,
First of all, I hope this is in the correct forum and that you can assist with a semi-urgent query.
I have been given an MS Excel 2003 spreadsheet from a customer which has two sheets to it, one is the raw data (taken from their database) the second is a summary sheet showing financial totals.
Within the summary sheet is a drop down box (cell B6, FYI) listing all of the account holders within the data. Once an account holder is chosen, the data within a couple of tables on that summary sheet is updated using VLOOKUP and this is all fine.
What we would like to do is have a button that once pressed, takes that Summary sheet with the account holder information and saves it to a new Excel file and closing that file immediately. The file name needs to include the name of the account holder, held within cell B6 as detailed above. However, we can't have the raw data included in this new file and we also need to disable any drop down boxes, buttons, macros, etc.
Is this possible? And if so, is there any information you would require to assist me?
Kind regards,
Mooski.
First of all, I hope this is in the correct forum and that you can assist with a semi-urgent query.
I have been given an MS Excel 2003 spreadsheet from a customer which has two sheets to it, one is the raw data (taken from their database) the second is a summary sheet showing financial totals.
Within the summary sheet is a drop down box (cell B6, FYI) listing all of the account holders within the data. Once an account holder is chosen, the data within a couple of tables on that summary sheet is updated using VLOOKUP and this is all fine.
What we would like to do is have a button that once pressed, takes that Summary sheet with the account holder information and saves it to a new Excel file and closing that file immediately. The file name needs to include the name of the account holder, held within cell B6 as detailed above. However, we can't have the raw data included in this new file and we also need to disable any drop down boxes, buttons, macros, etc.
Is this possible? And if so, is there any information you would require to assist me?
Kind regards,
Mooski.