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...
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."
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...
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...
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...
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...
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...
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...
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...
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...
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 =...