• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    VBA to apply auto update pivot filter when cell value changes in another sheet

    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...
  2. A

    Excel file with dropdown and datasheet editable from the other sheet

    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...
  3. A

    Vlookup to go down until the last cell with data and copy unmatched data

    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...
  4. A

    Edit .csv file without opening the file.

    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...
Back
Top