Posted to microsoft.public.excel.programming

newlearner01 newlearner01 is offline

external usenet poster

Posts: 5

Find matches in different spreasheets then copy and paste to new s

Hi,

I am a new in VBA and I am wondering whether someone can help me?

My workwork has 45 sheets. I would like to create a macro which will search
for string value in the second column ("B") of the first 41 sheets and if it
finds the matches it will copy entire row and paste to new sheet in same
workbook.

Thanks in advance.

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
Range to find matches to copy values	talonega149	Excel Programming	7	November 4th 09 09:57 PM
Range to find matches to copy values	Dwayne Pelletier	Excel Programming	0	November 4th 09 08:07 PM
Find, Copy and Paste	Fabian	Excel Programming	2	November 25th 08 08:59 PM
Find/Copy/paste.. then Find/Paste - not working ... at all....	[email protected]	Excel Programming	9	November 30th 06 08:49 PM
Find Copy and Paste	RigasMinho	Excel Programming	4	July 17th 06 09:32 PM

All times are GMT +1. The time now is 04:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us