Gone Bananas
New Member
- Joined
- Sep 30, 2014
- Messages
- 1
Hi all,
I have tried searching the various threads but have come up with no solutions so here it goes.
I have a Weekly Sales sheet which I include all my daily sales - eg Week 1 contains sales from Sun-Sat. I then transfer this info to a yearly sales sheet where I keep all totals of the weekly sales. I have linked these workbooks together however when I try autofilling the data just repeats. Is there anyway that the link changes from =Weekly Sales 2014\[Week 40 2014.xls]Sales'!$K$62 to for example Weekly Sales 2014\[Week 41 2014.xls]Sales'!$K$62
Any help on this would be appeicated.
I have tried searching the various threads but have come up with no solutions so here it goes.
I have a Weekly Sales sheet which I include all my daily sales - eg Week 1 contains sales from Sun-Sat. I then transfer this info to a yearly sales sheet where I keep all totals of the weekly sales. I have linked these workbooks together however when I try autofilling the data just repeats. Is there anyway that the link changes from =Weekly Sales 2014\[Week 40 2014.xls]Sales'!$K$62 to for example Weekly Sales 2014\[Week 41 2014.xls]Sales'!$K$62
Any help on this would be appeicated.