Hi All,In one of the sheet we have a pivot table, for B3 cell we have a filter, need to select All and unselect "#N/A, (blanks), 0. Please find the below screenshot and do the needful in achieving this step.
Hi All,I have 40K rows of data in excel after applying the vlookup formulae. I want to Convert selected cell range to text ,I tried with the below vba codes, But which is veryslow.. Can someone please help me with the code which works fast..Dim ws a...
I have to compare 2 sheets, which has around 1 lakh data. Two sheets ( A & B) A has two columns A1 and A2. B has two columns B1 and B2. In my case Some of the value in A and B1 are same, for such cases I want to update B2 = A2. So A2 should take the ...
