Sorting a sheet with referencing cell in different sheets

Bexcel11

New Member
Joined
May 10, 2019
Messages
5
Hi All,
I have a work book with 2 sheets
Sheet 1 has a bunch of dates
Sheet 2 has other info but also has these dates there but are referenced from sheet 1
If I want to sort by a column with all the info in sheet 2 how do I get the referenced dates to follow the row ?

Thanks
 

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

Panda514

New Member
Joined
Mar 11, 2019
Messages
37
If sheet 2 is referencing dates on sheet 1 then when you filter on a column on sheet 2, the dates should move with the rows.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,606
Messages
5,469,650
Members
406,664
Latest member
Bruister

This Week's Hot Topics

Top