Gingertrees
Well-known Member
- Joined
- Sep 21, 2009
- Messages
- 697
In a moment of poor planning, I published a workbook (set up like a form, for people to fill out) without having a page for me that compiles all the fields nicely for easy collation. So the form includes on sheet1:
Name: [--------------------]...Date: [------------]
Address: [--------- ------------------------------]
City: [---------------]...State: [---]...Zip: [------]
And more: [---------------]
(etc - it's long, that's just the start)
I've put together a sheet to pull all those fields together, combo of cell refs and Named Range references:
Name-------- | Date--------- | Address---------- | etc
=Custname |=Sheet1!E2 |=CustAddr
But I know if I copy that sheet to a new workbook it will refer to the old workbook. Any way to copy sheet, maintaining formulas but updating them to the new workbook?
(Using Office 2010)
Name: [--------------------]...Date: [------------]
Address: [--------- ------------------------------]
City: [---------------]...State: [---]...Zip: [------]
And more: [---------------]
(etc - it's long, that's just the start)
I've put together a sheet to pull all those fields together, combo of cell refs and Named Range references:
Name-------- | Date--------- | Address---------- | etc
=Custname |=Sheet1!E2 |=CustAddr
But I know if I copy that sheet to a new workbook it will refer to the old workbook. Any way to copy sheet, maintaining formulas but updating them to the new workbook?
(Using Office 2010)