Macro only goes to row 43

D

dreamerz679

I'm using the macro from the following site, which works great but wil
not go beyond row 43. It will create all the sheets necessary but i
will not populate those sheets with the corresponding data beyond ro
43.

http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter t
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 t
this in searching
 
W

Walter Briscoe

In message <[email protected]> of Tue, 19 Jun 2012
17:46:35 in microsoft.public.excel.programming, dreamerz679 <dreamerz679
(e-mail address removed)> 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.;)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top