$$Excel-Macros$$ Re: Filter Data based on Criteria

2013-04-10 Thread Mukul Garg
Hi Mr. Kumar, Please find below code , hope it will be help to resolve your issue. Sub Auto_filter() Dim sh As Worksheet Dim customer As String Dim invd As Date Dim po As String Dim amt As Long Dim gmt As String Set sh = ThisWorkbook.Sheets("Sheet1") Application.ScreenUpdating = False customer =

$$Excel-Macros$$ Re: Hyperlink by Sheets Name.........

2013-04-19 Thread Mukul Garg
Hi Kuldeep, Please use below formula to get output. =HYPERLINK("#Sheet"&ROW()-1&"!A1","Sheet"&ROW()-1) Regards Mukul Garg On Saturday, April 20, 2013 10:30:30 AM UTC+5:30, Kuldeep Singh wrote: > > > Hi Experts, > > I want to hyperlin