Hi,

I am a novice to intermediate user with vba. I have two worksbooks, one that
contains the assignment data and the other that contains the raw data.

assignment book (file A)
fields - workQ (col A)
- BeginRange(col B)
- EndRange (Col C)
- Name (Col F)
raw data (file B)
Fields - WorkQ (using variable name "workq" via find function)
- SecDesc (using variable name "secdesc" via find function)

We currently have a macro that formats file B. I need to modify this macro
to look at file A and where there is a match to bring over the person who is
assigned the task.

We need to match 3 columns from file B with file A, work queue, begin letter
range, end letter range. To get the letter range, I am using the left
function and pulling the first letter of an account(secdesc) from file B. On
file A,
certain workqueues have subaccounts and that is where the letter range comes
in.

What would be the best way to perform the matches between workbooks and if
possible could you provide me examples. I hope I made sense explaining this.

Any assistance would be greatly appreciated.

--
Thank you

Dave