Thread
:
Find matches in different spreasheets then copy and paste to new s
View Single Post
#
5
Posted to microsoft.public.excel.programming
newlearner01
external usenet poster
Posts: 5
Find matches in different spreasheets then copy and paste to n
There are less than 20 possible matches per sheet, and I need to create new
sheet. The value is text.
Thank for asking.
"Don Guillett" wrote:
what kind of value, how many possible matches per worksheet? Is the new
sheet already there or does the macro need to create it?, etc..............
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"newlearner01" wrote in message
...
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
newlearner01
View Public Profile
Find all posts by newlearner01