Linking Tabs

seenfresh

Well-known Member
Joined
Jul 12, 2006
Messages
1,141
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
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Watch MrExcel Video

Forum statistics

Threads
1,111,908
Messages
5,541,531
Members
410,547
Latest member
htran4
Top