About Us

Don Guillett

select the entire range

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"HectorLPerez" wrote in message
...
The auto filter seems to do exactly what I am hooping to do but it doesnt
sort the whole spreadsheet. it gets cut off where the subtotal is.

"Don Guillett" wrote:

You need to tie the dropdown to a worksheet_change event found in the
sheet
module.

If desired, send your file to my address below along with this msg
and
a clear explanation of what you want and before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"HectorLPerez" wrote in message
...
This is a master sheet that has tons of more information than what I
listed.
I would definitely need something that will still work as I add or
delete
information, columns or rows. The drop down/macro idea seems like it
would
work. How would I do that?

"Don Guillett" wrote:

If you select the engire range and then autofilter on NY or mobile or
both
& you can use subtotals at the top. DO look in the help index for
SUBTOTALS
to see the difference between filtered/non filtered data. A dropdown
could
be tied to a macro to automatically do this. I would use a defined
name
for
the range to account for additions/deletions.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"HectorLPerez" wrote in
message
...
here is what my spreadsheet looks like

STATE PROGRAM FUNDING Budget
NY Mobile 311 $ 2,132
NY Mobile 311 $ 6,563
NJ Stationary 311 $ 8,125

Total $16,820

CT Mobile 425 $5,623
FL Stationary 425 $2,244
CA Stationary 425 $8,265
NY Mobile 425 $1,898

Total $18,030

NJ Mobile 366 $16,000
CA Stationary 366 $2,000

Total $18,000

I need to create drop down menus so that if I need to run a report
on
all
the programs in NY, it will automatically filter out all the rest.
or
if i
need to run a report on what type of program etc. For some reason, I
cant
figure out the filter option. and the rows in between that show the
totals
for each Funding Code is also throwing me off. I have seen another
office
use this format with no problems but they didnt create the
spreadsheet
so
they cant help me.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Modifying Data in Drop Down Menu	GooseMA	Excel Worksheet Functions	2	May 23rd 09 08:43 PM
Data drop down on the menu bar missing	sdunmire	Excel Discussion (Misc queries)	1	September 26th 08 03:18 PM
Drop down menu with Dynamic data	kal4000	Excel Discussion (Misc queries)	0	June 20th 08 08:30 PM
help with drop down menu data	wilecoyote	Excel Discussion (Misc queries)	1	February 23rd 05 04:06 PM
Filtering Data with a Drop Down field	Patricia Martinez	Excel Worksheet Functions	3	November 28th 04 02:00 AM

Menu

About Us