Posted to microsoft.public.excel.programming

No Name

Posts: n/a

Copy row when value NOT found?

Excel 2003. This one has me stumped. Not sure where to start, since I'm
relying on data being *not* found*

I need to read each row in "Feb_Sheet" looking up the value in column H
(known as PTN) in "Jan_Sheet".

If the PTN is NOT FOUND in Jan_Sheet, then
copy the row from "FebruarySheet" to a just add sheet "Feb_New"
End if

Thanks a ton.

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
Copy Cells Found	S1L1Y1	Excel Discussion (Misc queries)	2	May 19th 08 05:31 PM
Macro to compare then copy if string found	Stuart[_3_]	Excel Programming	11	April 20th 07 10:25 AM
copy row when matching colums found	lancastergeneral[_2_]	Excel Programming	3	December 15th 06 11:11 PM
FOUND LOST FILE BUT COPY IS MISSING	NITRAM RENRAS	Excel Worksheet Functions	0	January 26th 06 08:03 PM
Copy after Autofilter with no rows found	Jeff B[_2_]	Excel Programming	7	July 27th 05 01:26 PM

All times are GMT +1. The time now is 06:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us