Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro only goes to row 43
I'm using the macro from the following site, which works great but will not go beyond row 43. It will create all the sheets necessary but it will not populate those sheets with the corresponding data beyond row 43.
http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb Sorry if this has been answered before, I didn't see anything close to this in searching. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro only goes to row 43
In message of Tue, 19 Jun 2012
17:46:35 in microsoft.public.excel.programming, dreamerz679 <dreamerz679 writes I'm using the macro from the following site, which works great but will not go beyond row 43. It will create all the sheets necessary but it will not populate those sheets with the corresponding data beyond row 43. http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb Sorry if this has been answered before, I didn't see anything close to this in searching. I decided to look at this problem in Excel 2003. From Fl0013, I downloaded AdvFilterRepFiltered.zip I appended 50 rows to the data. None was extracted. I stepped into ExtractReps I found it used Database - a named range of 43 rows. I changed that definition and the title line and my 50 rows were extracted. It did not help that the button text was not fully displayed. I leave removing the dependence on Database to you.;) -- Walter Briscoe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy and paste values (columns)I have a macro file built | Excel Programming | |||
AutoRun Macro with a delay to give user the choice to cancel the macro | Excel Programming | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |