cricket1001
New Member
- Joined
- Dec 5, 2011
- Messages
- 12
- Office Version
- 365
- 2016
- Platform
- Windows
I want to copy a worksheet to another workbook where everything is linked.
For ex: I have a workbook called "Budget 2016" with a worksheet called "Credit Cards" and a worksheet called "Budget IL & FL". In the "Credit Cards" worksheet I have all info about each credit card like the balance, date due, promos, interest rate, etc. In the "Budget IL & FL" worksheet I have each credit card listed w/ current balance. I have the current balance in both worksheets linked together. What I want to do is start a new workbook w/ the "Credit Cards" worksheet copied w/ everything linked together to the new workbook "Credit Cards". In this workbook I'm going to make a new worksheet for each credit card that will have all my purchases for that credit card listed.
I bought a house in FL and am trying to sell my house in IL. I have had to do rehabbing on both houses and I want to group all purchases for IL house and FL house separately. I just want to have the "Credit Cards" worksheet in "Credit Cards" workbook link back to the "Credit Cards" worksheet in the workbook "Budget 2016". I know how to link each cell but was wondering if there was a way to just link the whole worksheet instead of doing it separately cell by cell.
Thanks
For ex: I have a workbook called "Budget 2016" with a worksheet called "Credit Cards" and a worksheet called "Budget IL & FL". In the "Credit Cards" worksheet I have all info about each credit card like the balance, date due, promos, interest rate, etc. In the "Budget IL & FL" worksheet I have each credit card listed w/ current balance. I have the current balance in both worksheets linked together. What I want to do is start a new workbook w/ the "Credit Cards" worksheet copied w/ everything linked together to the new workbook "Credit Cards". In this workbook I'm going to make a new worksheet for each credit card that will have all my purchases for that credit card listed.
I bought a house in FL and am trying to sell my house in IL. I have had to do rehabbing on both houses and I want to group all purchases for IL house and FL house separately. I just want to have the "Credit Cards" worksheet in "Credit Cards" workbook link back to the "Credit Cards" worksheet in the workbook "Budget 2016". I know how to link each cell but was wondering if there was a way to just link the whole worksheet instead of doing it separately cell by cell.
Thanks