Posted to microsoft.public.excel.misc,microsoft.public.excel.programming

Greg B[_5_] Greg B[_5_] is offline

external usenet poster

Posts: 54

Worksheet lookup

I have a workbook with 140+ worksheets in it and I want to have a macro to
look up if the worksheet has the letter "m" in cell "i1". If the worksheet
has this then I would like it to look in column "A" and look up for the
number 2 and then copy the row to a worksheet called "roundm"

Thanks in advance

Greg

Reply With Quote

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

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
Lookup on worksheet	richzip	Excel Discussion (Misc queries)	1	May 1st 09 03:56 AM
Lookup on worksheet	richzip	Excel Discussion (Misc queries)	0	April 20th 09 10:51 PM
How do I lookup a worksheet name in excel?	RJL007	Excel Worksheet Functions	2	May 30th 08 02:29 AM
lookup for worksheet	Bradrok	Excel Worksheet Functions	1	April 2nd 08 11:04 PM
Worksheet lookup	Greg B	Excel Discussion (Misc queries)	2	August 4th 05 12:47 PM

All times are GMT +1. The time now is 05:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us