LaBamba
06-17-2014, 09:38 AM
Hey guys...and maybe some girls out there! hah.
Great forum so far; hopefully it will be my go-to going forward =)
I know you will have questions as you dig into my project; but i want to give you the gist of it and see if you can provide some guidance.
I want to create a command file; a lookup file in a sense.
I want this file to contain criteria in which, when met, a certain action is taken in my open worksheet.
Both files will contain a unique number in which I could use for my Lookup. But its not just a simple lookup I want returned...I want the my current workbook to compare its information to my Lookup file and determine a value.
A simple example is: *My actual project will contain more variables*
My Lookup File will contain:
Item Number Price Max Quantity
12345 $50 100
The file in which i am working will contain Item Numbers, a price, a quantity, and also a quantity in which I return (this is where our value will go.)
I want my current workbook to compare itself to the data in my look up file....so if item number #12345 is in my current workbook it compare its data to my master. When the price is the same, and the quantity requested is lower than or equal to 100...it will return a value...either 100 or lower if the quantity requested is lower.
Let me know your thoughts guys.
Thanks in advance!!! you guys roxx!
Great forum so far; hopefully it will be my go-to going forward =)
I know you will have questions as you dig into my project; but i want to give you the gist of it and see if you can provide some guidance.
I want to create a command file; a lookup file in a sense.
I want this file to contain criteria in which, when met, a certain action is taken in my open worksheet.
Both files will contain a unique number in which I could use for my Lookup. But its not just a simple lookup I want returned...I want the my current workbook to compare its information to my Lookup file and determine a value.
A simple example is: *My actual project will contain more variables*
My Lookup File will contain:
Item Number Price Max Quantity
12345 $50 100
The file in which i am working will contain Item Numbers, a price, a quantity, and also a quantity in which I return (this is where our value will go.)
I want my current workbook to compare itself to the data in my look up file....so if item number #12345 is in my current workbook it compare its data to my master. When the price is the same, and the quantity requested is lower than or equal to 100...it will return a value...either 100 or lower if the quantity requested is lower.
Let me know your thoughts guys.
Thanks in advance!!! you guys roxx!