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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

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,095,840
Messages
5,446,817
Members
405,417
Latest member
egrospe17

This Week's Hot Topics

Top