I have a billing workbook that I'd like to set up so when a new billing comes in, I can copy the worksheet to a new sheet. I can do this easy enough, but I'd like to link the current billing information from prior sheet to the new sheet. On the example I've added I'd like to link H9 on the Sheet1 (2) to J9 on the Sheet1, so the billing information updates. How can I set this up so when I copy a new sheet, Sheet1 (3) that the new sheet will pull from Sheet1 (2) and not from Sheet1?
Thanks in advance
Bookmarks