2011-07-14, 11:42 #1
- Join Date
- Jan 2001
- La Jolla,CA
- Thanked 35 Times in 34 Posts
Macro for expanding filtered list; non-contiguous columns; chart
I use a recorded macro button to update a sheet by creating a filter.
I need a macro that will enable me to select only those rows showing in the filter to create a chart on another sheet. The chart needs to be created from the visible rows beginning with the 4th row in columns D, F, G and H (skipping E).
Thanks in advance for any help.
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2011-07-14, 13:40 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 338 Times in 331 Posts
Create the chart with all the rows. When it is filtered the chart should only display the visible values.