Search results

How silly of me...!! :eek: It's working now :) Thank you very much vletm

Hi Vletm, First of all let me thank you for taking out time in helping me with this issue. Really appreciate your patience and support..! I have checked your file and have used same VBA in my sample file (which I attached at #3) and have also converted my sample file to .xlsb but it does not...

Unfortunately I could not replace my file as it has huge data which is calculated from different sources. I tried using table instead of pivot and am successful to some extent. The only issue now is when I click on any value in 'List Box (Form Control), the table would only apply the changes if...

Hi vletm, The file you shared does the work, however when i tried the same vba on my file it doesn't do anything. Could you please let me know how could I use this on my file?

Hi vletm I would not be clicking on Sheet2's cell D2? It is linked to list Box (Form control). So whatever value I click on, the cell value will automatically get changed to it. I have attached a sample file here 'Dashboard sheet is the where I have the pivot table and list box. My pivot has...

Hi, I've a workbook with two sheets. Sheet1 has PivotTable1 and Sheet2 has the cell (D2) with vlookup formula in it. Is it possible to get the pivot table filter automatically updated everytime when the value in Sheet2 cell D2 is changed? Sheet2 would be hidden, so no manual click would be done...

Thank you veryyyy much Luke :DD

One more question Luke. If I want to add more filter such as 'Name' and 'Sex' and add more columns in Sheet1. Then what are the modification I need to make in the VBA?

Thank you very much Luke...it works gr8..!! :) Appreciate your help...Thank you once again ;)

Hi All, I have my data in sheet1 (Id,Name,Age,Sex and Marital Status). Firstly, In Sheet2 I want to create two drop down, first one will show marital status ('married' or 'unmarried) and second will show age =>35 years after which I should get the data in sheet2 which matches both the...

Luke - Its works great...!! Thank you very much...!! One more thing as the vlookup formula is being filled in all the cells it makes the calculation very slow. Is it possible to run this faster..by using some functions instead of vlookup formula...????

Hi All I have a workbook which has data from two different source in Sheet1 and Sheet2 what I need here is vba code that will be assigned to a button in sheet3 which will do a vlookup in sheet2 cell B2 and drag is the formula until last row of column A (because the rows number will increase or...

Hi SirJB7 I want to modify the column header. Currently the name are Field1 Field2 Field3 Field4 Field5 which I want to rename to Field@1 Field@2 and so on. The reason why I can't open the file is because if I open the file it does not load all the rows which is there in the file. It omits...

Hi I am new to this forum and wanted some help related to vba. I have a csv file which is a dump from the database, I want to edit the file columns (column A,B,C,D & E)name without opening it. I can't open the file as the data is too huge and it can't load all the data b'coz of rows...