Forum Discussion
How to Copy Formulas From Different Worksheets
I am trying to simplify the inventory sheets we are using to make the process easier. In an excel file, I will have one sheet for each date we take inventory. We create the sheet each week that...
It is better you could use Power Query which will make your work become a mouse click.
In your case you want to copy the data of worksheet2 into worksheet3 but the formular is writen 'worksheet1'?
If it is, you could choose all cells in worksheet3 use replace buttom find worksheet1 (sheet name) and replace to worksheet2 (sheet name).
In your case you want to copy the data of worksheet2 into worksheet3 but the formular is writen 'worksheet1'?
If it is, you could choose all cells in worksheet3 use replace buttom find worksheet1 (sheet name) and replace to worksheet2 (sheet name).