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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

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,096,444
Messages
5,450,488
Members
405,614
Latest member
SJ789

This Week's Hot Topics

Top