VBA IDEAS for Loop - Please

[mole999]

I pull data from an SQL backend, which has to be processed, I have no ability to update the stored data, apart from CASE / REPLACE TYPES.

I have an Excel Sheet with updated values, and data that is important but not collected in the SQL.

Basically I have two tables, I have one common value that looks like Y0777 (23,000) of them

I need to look at my updated table, and then check around 15 columns cell by cell (not necessarily ABCDE type order) to see if a value exists, and if it is empty or different I need to replace the value. before I can continue to process the main updated file.

Any thoughts on a VBA loop that will scan down one column (Sheet 1) , find the appropriate main ref (Sheet 2) compare to the columns until that loop finishes.

The combination will then be processed to determine a range of values for reports

I don't mind if it takes 20 minutes to run through

my other option is index match into a third table, but I'd like to avoid doing that

 

[SteveO59L]

try posting a sample of your data, and what you would like to do with it

 

[mole999]

SteveO59L
can't do real data i'm afraid

In essence

scan down Sheet1 Col A, compare against Sheet2 Col A, where a match exists for Col A, then look along into Col B and check if an identical values exists, is so ignore, if the col is blank or different value, copy the related value across. (No replacing values with BLANKS}

Excel Workbook
	A	B	C	D	E	F	G	H
1	Sheet 1				Sheet 2
2	Col A	Col B	Col C		Col A	Col C	Col B
3	Y0001	18/08/2017			Y0001	e	18/08/2017
4	Y0002	17/07/2017	s		Y0002	s	18/08/2017
5	Y0003				Y0004	f
6	Y0004		d		Y0005	e
7	Y0005				Y0006
8
Sheet1

 

[Fluff]

Not sure if I've understood you correctly, but could you use a dictionary?
Put the values in sheet1 col A as the key & the relevant row number as the item.
Then loop through the sheet 2 columns & if it exists in the dictionary compare the Col B value in sheet2 with sheet using the item?
Hope this is clear

 

[mole999]

potentially over 30,000 rows at a max, and 10 columns, and I know nothing about dictionaries, but have read a few thesauruses' .. I was thinking something slower FOR FOR with comparison NEXT NEXT, but don't have a good view in my head. I will get there eventually