I had this question after viewing Index Match Vlook up for a master file
I have added some code to inform the user if the part does not exist on the master
For Each cell In rng
ws(4), cell.Value) > 0 Then
col = Application.Match(cell.Val
ue, sws.Rows(4), 0)
r = Application.Match(cell.Off
set(0, 2).Value, sws.Columns(col), 0)
If col > 0 Then
If Err.number = 13 Then
cell.Offset(0, 3).Value = "Part not in master"
cell.Offset(0, 3).Value = sws.Cells(r, myCodeCol)
i have been thinking about the first column and the issue getting all the invoices eventually to one sheet. The problem is that none of them put a column showing it is from them. I don't want the user to type in the company name becuase that would just open the door to problems So how about this. when the user open the invoice spreadsheet, they will run a vba script , and it will ask who the company is:
ZED .. Maple. etc. the available companies would be based upon ROW 4 in the master sheet in (sheet2). They choose the company and it is copied down in col A to the end of the data . I have run a few manual samples and it works good. So my question is , how do i get that list to show up in VBA ?