On Feb 16, 10:19*pm, Dave wrote:
Hi MVP's,

I have currently an issue that I am not getting any bites on , I would
really appreciate if you could please look at it and give me a macro
for it. The thread is at

http://groups.google.com/group/micro...rogramming/bro...

Thanks in advance,

Dave

You need to cycle through your worksheets:

For each sht in ThisWorkbook.Sheets

Next

Inside that loop you neet define on column of each each database. Use:

Set R1=Range("B1").CurrentRegion.Offset( 1, 0)
Set R1=R1.Resize(R1.Rows.Count - 1,6)

....where 6 represents any suitable column

Now do the same for R2 your csv fie.

For each c1 in R1.cells
For each c2 in R2.cells

Next
Next

....and use Offset to reach out to other data in other columns.