Hi All
Am looking a formula or vba that can search data in two sheets, the control sheet what ever data is entered in column B in respect of their headers in column A ,should be able to LIST all data corresponding to data entered in column B ,
however the data entered in column B in control sheet may not tally with their corresponding headers that is as example itemno '0000537 is entered and 'ITEMDESC 'FIBERNET 1M20 GRIS - RL30 / AU METRE is entered You will noticed that these data may have not relationship but it must show their respective data
from both sheets .
Is this possible as sheets 2014 and 2015 may have up to 30000 rows and formulas in it for sake of example they do not appear
the search is very painful and slow. Everyday I got crazy with this tedious task
Can anyone help me.
thanks
Bookmarks