I have data that is set up in a summary sheet as follows:
I have seperate worksheets for each Ad that have the information in Column A ex:
w1 = [Summary] A4=1=Allstate
I would like to link the worksheets tab to reflect the summary number in column A just in case I would like to make changes to the order of each Ad
Any advice or help would be gracias!
Sean
LMN Detail.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
4 | 1 | 0.00 | 0.00 | 127.27 | 375.51 | |||
5 | 2 | AmericanFamily | 0.00 | 0.00 | 0.00 | 0.00 | ||
6 | 3 | 0.00 | 0.00 | 0.00 | 0.00 | |||
7 | 4 | 0.00 | 2,665.80 | 2,878.09 | 2,651.52 | |||
8 | 5 | 0.00 | 0.00 | 0.00 | 95.86 | |||
9 | 6 | 0.00 | 0.00 | 0.00 | 0.00 | |||
10 | 7 | 0.00 | 0.00 | 0.00 | 0.00 | |||
DUE TO ABC |
I have seperate worksheets for each Ad that have the information in Column A ex:
w
I would like to link the worksheets tab to reflect the summary number in column A just in case I would like to make changes to the order of each Ad
Any advice or help would be gracias!
Sean