Hi All,
Goodevening,
I have the following a set of Data on sheet1 and look table in sheet 2. My goal is to look for job ref numbers listed in Column A on sheet1 and once these job numbers are found on sheet 2 in column A, I want the value corresponding in Column B on sheet 2. Basically I am trying to find job numbers in current invoice which might be invoiced to us in previous months. Sheet 1 has jobs invoiced for the current month(max rows:1000) and sheet 2 has got a report of all job numbers invoiced on previous 12 months approx rows:4000).I have tried recording macro(if, isna, vookup functions) for this, it works fine for just one data set, but the limitation is that every time i feed in new data sets, i get run time errors and date format problems, basically i always have to do manually my IF(isna(vlookup...... I am looking for VBA code so I can just assign a button and all results(invoiced months from sheet 2) can be feeded in columnB in sheet1 and are marked in red colour.
Data Set:
On Sheet1 On Sheet 2
Column A Column B Column A Column B
3600012345 June 3600011111 April
3600012346 3600022222 May
3600012347 July 3600012345 June
3600012348 3600033333 June
3600012349 3600012347 July
3600012350
So i know that in above case 3600012345 & 3600012347 has been invoiced to us before in June and July respectively so I will block the payment.
any help would be greatly appreciated.
thanks & regards
Manav
Bookmarks