musicninja
New Member
- Joined
- Jul 26, 2016
- Messages
- 8
I have a workbook consisting of two sheets that I want to move into a different workbook. One is the front end worksheet, the other is for data validation, including several tables (which I need as tables to make the front end work). I tried simply selecting both of them and using the Move/Copy to function, but it said that I can't do that since one of them contains tables. I tried copying them one at a time, but unsurprisingly the formulas on the front end page are now referencing the original file.
Is there a way to keep the formula links intact and move both worksheets?
Is there a way to keep the formula links intact and move both worksheets?