editfarahas
New Member
- Joined
- Jun 29, 2018
- Messages
- 1
Hello everyone!
I'm fairly new to Excel, and completely self-taught, so please bear with me.
I have an Excel table with formulas in it, and I'd like the source data to come up in a new sheet if I click in the cells (much like with a pivot table). I have seen this working in a similar table, but I cannot, for the life of me, figure out how it's happening (not a macro for sure), and googling hasn't helped much.
So far, if I click in a cell it just takes me to the sheet with the complete source data, but I need it to show me just the date range represented by the number in the cell, in a new sheet.
I appreciate every suggestion you might have!
Thanks,
Edit
I'm fairly new to Excel, and completely self-taught, so please bear with me.
I have an Excel table with formulas in it, and I'd like the source data to come up in a new sheet if I click in the cells (much like with a pivot table). I have seen this working in a similar table, but I cannot, for the life of me, figure out how it's happening (not a macro for sure), and googling hasn't helped much.
So far, if I click in a cell it just takes me to the sheet with the complete source data, but I need it to show me just the date range represented by the number in the cell, in a new sheet.
I appreciate every suggestion you might have!
Thanks,
Edit
