LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How do I use the font as a filter


I am struggling with a export problem purely due to the size of task.

I have over 50000 rows of text in excel. I would like to copy all th
text that is a certain font size to a new sheet, in th same position a
found, this would leave behind all other data.

Another macro would bring out all data based on a word.

Effectively the fonted data would copy first then the 2nd macro woul
look for an instance of the target word, if found then copy that wor
to under the previous fonted data. The first macro would then continu
to look for more fonted data and so on.

Can any one help I am on a very tight schedule and lack of sleep i
driving me mad

--
Karlo
-----------------------------------------------------------------------
Karlos's Profile: http://www.excelforum.com/member.php...fo&userid=2864
View this thread: http://www.excelforum.com/showthread.php?threadid=48361

 
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
Can I change the font on auto filter? CFI Excel Discussion (Misc queries) 2 July 28th 09 04:32 PM
in the drop down filter box how do you increase font size? Stevie Excel Worksheet Functions 1 January 8th 09 07:47 PM
Font of advanced filter Catherine Excel Discussion (Misc queries) 3 June 25th 08 04:35 PM
filter by font color Chris Excel Discussion (Misc queries) 3 June 21st 06 02:05 PM
can you increase the font of the drop downauto filter Cab Max Dave Excel Discussion (Misc queries) 3 January 26th 06 11:27 PM


All times are GMT +1. The time now is 12:41 PM.

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"