search an array for values contained in another array

C

Cheer-Phil-ly

I have two workbooks, one named 'Reps' and the other named 'Dealers'. The
'Rep' workbook has a sheet for each rep (sheet name is the rep name). The
'Dealers' has a listing of 1000 dealers in column A and in column R there is
a rep name for that dealer.

I have created an array of sheet names ('sheetnames') in the 'Reps' workbook
and I have also created an array of unique reps that are in Column R called
'repnames'.

Now I want to lookup each rep name from the repnames array in the sheetnames
array to see if that rep already has a sheet. If he doesn't have a sheet,
then I need to make a copy a master sheet that is already formatted and name
the new sheet with the rep name.

What is the best way to accomplish the above? Many thanks for a prompt
response!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search an array of sheets for an array of numbers & return count of numbers 11
Create sheet with records for each rep in filtered list 3
NEED HELP! Macro loop 7
Macro Help 2
Repeat Range for select Records 0
Cell values to an array, then array transpose to another workbook 8
Checking for a minimum of 5 rows 2
Array code only works on selected sheet 14

Top