New
#1
Want to copy data and formula from one Excel Sheet to another.
I have a budget workbook set up in Excel, and in that workbook there are many different sheets all part of the one book.
I have created a formula in one sheet from the data that is collected there, and that data is important for information collected on another sheet. I want to copy the formula and the data from that from that sheet and have it appear in the other excel sheet. I also want the data to change on the second excel sheet as the results from the formula change in the first sheet.
When i have tried to just copy and paste the formula from one sheet to the next I just get a ref error.
Many thanks for your help in advance.
Regards
Anthony