I want to thank anybody who helps me 1st. I'm a novice to code writing.
I have created a spreadsheet that has formulas in a few cells. There will be times when a user might insert data into the cell, that has the formula. When this change occurs they will print the spreadsheet data. I have created a print button, with code, to print a selected area.
After this happens I need to go back to the original spreadsheet, before they changed the cell (or cells), so that all the formulas are present again. The reason I want to go back is, when they import data, the formulas can read the new data. They have to import, then print the new data about ten times before closing the workbook.
I need the formulas to be there every time they import, some how I need the spreadsheet to be the orginal one they opened, after they changed a cell and printed the data. I would like to add code to the print button, where the code takes me back to the original spreadsheet, if possible.
Thanks again for any help.
I have created a spreadsheet that has formulas in a few cells. There will be times when a user might insert data into the cell, that has the formula. When this change occurs they will print the spreadsheet data. I have created a print button, with code, to print a selected area.
After this happens I need to go back to the original spreadsheet, before they changed the cell (or cells), so that all the formulas are present again. The reason I want to go back is, when they import data, the formulas can read the new data. They have to import, then print the new data about ten times before closing the workbook.
I need the formulas to be there every time they import, some how I need the spreadsheet to be the orginal one they opened, after they changed a cell and printed the data. I would like to add code to the print button, where the code takes me back to the original spreadsheet, if possible.
Thanks again for any help.