• 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. M

    Create macro that inserts variable number of rows into tables

    Yeah I knew I would make this confusing. Not sure how to upload, but here is a googledocs link to my file as it currently is. https://docs.google.com/open?id=0B-Bd0UJtnQ0RS1N0Wm8wRUpTbDJBNHkwYmFoV1lHUQ To clarify, each new sheet being created will have the format from a previous sheet...
  2. M

    Create macro that inserts variable number of rows into tables

    Actually, when using your line of almost exactly, but changing Worksheet(ksparameters) to Worksheet(Control) I receive the following error. "Application defined or object defined error."
  3. M

    Create macro that inserts variable number of rows into tables

    Actually, now that you mention it.. Ideally it would update each worksheet, excluding the first 3 or so (which contain data, a control tab, etc.) I have a macro that will auto create these sheets, and if I can fit your code into it while excluding the first few sheets that would be...
  4. M

    Create macro that inserts variable number of rows into tables

    Thank you for the reply! I can definitely see where this code is going, however there is one hang up for me. The sh variable is declared as worksheet, but my code needs to look like this... ()For Each sh In ActiveSheet() This is because my E2 of parameters will change every time I go to...
  5. M

    Create macro that inserts variable number of rows into tables

    Hello, I am trying to insert a variable number of rows into several tables, based on a dynamic value. Here is a link to the file I am working with: https://docs.google.com/file/d/0B-Bd0UJtnQ0RSVp3TjNZUjlRQkdWcjRhd2xJU3VpUQ/edit?pli=1 Each table is in a new tab (Blank, Blank1,Blank2...
  6. M

    Dynamic Ranges for Dynamic Dashboards

    You sir, are a genius, and have solved my problem. Thanks so much!
  7. M

    Dynamic Ranges for Dynamic Dashboards

    That still just returns the #Ref error. I am using a data validation for the list from input tabs, to refer to a dynamic range in the data tab. If that helps clarify. I am thinking this has something to do with the way Kyd sets up dynamic ranges. With a name range on the column header...
  8. M

    Dynamic Ranges for Dynamic Dashboards

    Sure thing! =SUMIFS(INDIRECT($C$20),Data!aSalesperson,B24,Data!aProductName,$C$18,Data!aMonth,$C$19) This formula is in the dynamic table, which feeds the dashboard. The table is modeled after CH1 tab in Dynamic Dashboard Illustration Spreadsheet from the walkthrough. The Indirect value...
  9. M

    Dynamic Ranges for Dynamic Dashboards

    Thanks for the tip! The evaluate button helped me identify some trouble spots... But it appears that keeping the value in INDIRECT() a dynamic range is causing the issue. If I change this one range to static, everything works. All the other ranges in the SUMIF function are dynamic. But...
  10. M

    Dynamic Ranges for Dynamic Dashboards

    I've been working on creating my own dynamic dashboards using the 4 part series on this site, and it has been going very well (Thank you!). However, I have decided I want the ranges on my data to be dynamic as well, which this series does not cover. I have utilized several resources to help...
  11. M

    Defining a new range in macro based on cell match in two worksheets

    Thanks Luke! I can see that this is likely going to do the trick. The range I am pasting to is actually the exact same range I am copying. The reason is because I need to clear out the formulas so when Sheet 1 is updated with new data, the previous days row does not return to blank or zero...
  12. M

    Defining a new range in macro based on cell match in two worksheets

    I am looking to write a macro that will copy a row of cells in Sheet 2 (Database) if the value in column B of 'Database' matches A1 in 'Sheet1'. I have compiled the following incomplete macro: Sub Stock() Set i = Sheets("Sheet1").Range("A1") Set e = Sheets("Database").Range(B) Set f =...
Back
Top