Thanks Paul, I'm not sure I was being thorough enough with my
explanation. In any case...Through trial and error today I kept
working at it, and this is what I've come up with. It looks like it's
providing me with what I need. Maybe it will be of help to someone
else.
Sub ESTSearch()
Do Until
Hi Java,
If your specifications are vague, then I can only speculate and
simplify...
I assumed first row contains column headings, so I start on row 2 (you
can change that if necessary) in both sheets...
I assumed the numbers to match are located in both sheets in the first
column [if not, you ca
Hi...I applied this code, and nothing happened. I think I may need
more instruction. You mentioned variablesI have 857 different
numbers in sheet A (QB) that I need to find the corresponding number
and line of data in Sheet B (EST) which has over 3800 lines of data.
I recorded the actions, I
Hi JavaOnLine
This method works always and you can insert any specific criteria
without limit...
Good luck. Let me know if it was useful...
Paul Willekens
'===
Sub ESTSearch()
Dim cValue
Dim lDoneA
Dim lDoneB
Dim nNumberA
Dim
