#1   Report Post  
Posted to microsoft.public.excel.misc
Coltsfan
 
Posts: n/a
Default One Last Thing


Thanks for those who responded on my last one.

I am putting together a spreadsheet and at the top there is a pick list
with months. Is there away once you have selected the month for it to
automatically sort based off of that month on a different sheet and get
rid of the blanks that are not of that month? Hope that makes sense.


--
Coltsfan
------------------------------------------------------------------------
Coltsfan's Profile: http://www.excelforum.com/member.php...o&userid=19982
View this thread: http://www.excelforum.com/showthread...hreadid=501798

  #2   Report Post  
Posted to microsoft.public.excel.misc
Anne Troy
 
Posts: n/a
Default One Last Thing

Not sure if it does make sense. LOL.
But have you tried Autofilter?
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Coltsfan" wrote in
message ...

Thanks for those who responded on my last one.

I am putting together a spreadsheet and at the top there is a pick list
with months. Is there away once you have selected the month for it to
automatically sort based off of that month on a different sheet and get
rid of the blanks that are not of that month? Hope that makes sense.


--
Coltsfan
------------------------------------------------------------------------
Coltsfan's Profile:
http://www.excelforum.com/member.php...o&userid=19982
View this thread: http://www.excelforum.com/showthread...hreadid=501798



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro thing? Jerry Kinder Excel Worksheet Functions 6 October 21st 05 02:22 PM
How do I get one cell to type the same thing as another cell? Astrowalker Excel Discussion (Misc queries) 4 August 1st 05 07:27 PM
Is there such a thing... Tom Excel Discussion (Misc queries) 1 April 19th 05 01:38 AM
Strange thing happened with TOC RoxSn Excel Discussion (Misc queries) 1 March 11th 05 08:43 PM
The $ thing to lock cells at rows or columns [email protected] Excel Discussion (Misc queries) 2 December 27th 04 11:57 AM


All times are GMT +1. The time now is 11:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"