Sherlock69Holmes's channel

@farouk450

Hi , does this VBA worked , it worked for me exactly as shown . but when i closed it and opened again , picture does not change dynamically with the name.

what format does i need to save my file ?? please help

@Sherlock69Holmes

while tasting he got that no salt was added and covered. But i tried curry is awesome.

Plz Plz guide me Mike

Its Great .., But In a workbook i have say 100 sheets

So i maintained a Index sheet ( which has table , which has two columns , one for sheet name , second for hyperlink) . Now In same index sheet i maintain a drop down list to select sheet name & formulated one cell to get corresponding second c...

Hello Mike ,

Applied the same logic , but turned dataset to table & created two lists for Column & Row Headers.

Below is my function

=INDEX(Table1[[2009]:[2012]],MATCH(I7,MonthNameList,0),MATCH­(I6,YearNameList,0))

---when selected Apr in i7 - MATCH(I7,MonthNameList,0) returns 4 But MATCH(I6...

@ExcelIsFun

Thanks for Reply.got the related video i am looking for.

Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula