JJJ010101 Wrote:

Your problem is not very clear. Col B of WS2 has IDs and there can be
duplicates. That means more than one row, say two rows, under col B of
Ws2 have same ID- say ID001. Now you want to go to WS1 scan Col A and
look for same ID ID001. If it finds any row in this col A with ID001
then you want to scan that row for blue cells. Can it encounter more
than on blue cell? upto how many cols you want to scan? ( Does WS2
table has fixed number of cols?). If there are say two blue cells in
row with values "1" and "2". Should it go for further scanning of col A
for more occurences of ID001? If it finds more such occurences and more
corresponding blue cells, what do you want to do? e.g for ID001 you may
get data from WS2 like
ID001  1  2
ID001  3  4

You said you want to copy this data to Col E of WS1 in the row where
colA has ID001. But data obtained from WS2 will require two rows and
two cols ( total number of values obtained are 4 - "1","2","3" and "4"
). Should this data be pasted in col E and ColF and two adjacent rows?
Since colB of WS2 may have multiple occurence of ID001 should this be
repeated every time ID001 is encountered in ColB? Similarly not clear
what you want to copy to WS2. Please define your problem clearly.
Especially with the assumption that there can be multiple instancess of
same ID in ColB of WS2 and ColA of WS1 and again multiple instances of
blue cells across an ID in WS1, it is not clear what you want to do. We
will try out something once problem is clear.

A V Veerkar