I have a filter in my VBA code which works fine, and copies the output to a second table for me to perform additional steps with.
Range("Table_Data_Current_Wk_Schedule").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range("adminMilestonesFilterCriteria"), CopyToRange:=Range("Data_Current_Wk_Schedule!X1:AM1"), Unique:=False
My challenge is that I want the second (results) table to be between other rows in a instructions worksheet. (currently it is on it's own worksheet)
Example:
Text Row Before
Text Row Before
Text Row Before
blank row
FILTER RESULTS TABLE
FILTER RESULTS TABLE (length varies depending on the # of results from the filter)
Text Row After
Text Row After
Text Row After
Normally, when you add text to a blank row at the bottom of a Table the new row becomes part of the table. The problem I am having is that, when the filter results exceed the length of the results table they overwrite the "Text Row After" rows rather than dynamically adjusting the results table length.
PS. I have searched every keyword I could think of, on multiple occasions, and just can't seem to find a case similar to this to learn from.
Thanks in advance for your help/suggestions!
Casey
Range("Table_Data_Current_Wk_Schedule").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range("adminMilestonesFilterCriteria"), CopyToRange:=Range("Data_Current_Wk_Schedule!X1:AM1"), Unique:=False
My challenge is that I want the second (results) table to be between other rows in a instructions worksheet. (currently it is on it's own worksheet)
Example:
Text Row Before
Text Row Before
Text Row Before
blank row
FILTER RESULTS TABLE
FILTER RESULTS TABLE (length varies depending on the # of results from the filter)
Text Row After
Text Row After
Text Row After
Normally, when you add text to a blank row at the bottom of a Table the new row becomes part of the table. The problem I am having is that, when the filter results exceed the length of the results table they overwrite the "Text Row After" rows rather than dynamically adjusting the results table length.
PS. I have searched every keyword I could think of, on multiple occasions, and just can't seem to find a case similar to this to learn from.
Thanks in advance for your help/suggestions!
Casey