Hello to All!
So I am confused on where to begin. I currently have a macro that compares data between a database worksheet and copies over information.
Ex. Say you have connector 1234 on spread sheet it takes that connector and compares it to the Database and returns random information such as "Label Name, Terminal, Seal, Wire Length..."
This is part of the code
This returns the data for the Label.
Well what I would like to do is:
If a label is returned then go to the "LabelDB" workbook and add to column L whatever is in L plus 1. What this will do is give me a count of how many times this part has been requested.
I just can't figure out how to store the location of the vlookup data that is on a seperate workbook then go to that workbook and add that value to column L.
Any ideas?
So I am confused on where to begin. I currently have a macro that compares data between a database worksheet and copies over information.
Ex. Say you have connector 1234 on spread sheet it takes that connector and compares it to the Database and returns random information such as "Label Name, Terminal, Seal, Wire Length..."
This is part of the code
Code:
Range("B" & i + 1).Formula = "=IF(ISNA(VLOOKUP(A" & i + 1 & ",'" & LabelDB & "'!$B:$Z,2,FALSE)),A" & i + 1 & ",VLOOKUP(A" & i + 1 & ",'" & LabelDB & "'!$B:$Z,2,FALSE))"This returns the data for the Label.
Well what I would like to do is:
If a label is returned then go to the "LabelDB" workbook and add to column L whatever is in L plus 1. What this will do is give me a count of how many times this part has been requested.
I just can't figure out how to store the location of the vlookup data that is on a seperate workbook then go to that workbook and add that value to column L.
Any ideas?