Hi i need help currently, i have 2 rows on data that i need to pair up according to the quantity. For those with quantity i would need to pair them with the 3rd value from the current value. I have an excel module that was written by someone who left the company and i need to convert it to access module as i need to retreive data from access table to generate the quantity for certain items.
i have attached the excel file and need help with converting the module vba code to access module vba codes. i am clueless about vba codings and i am still learning and i tried out coding some in access and attached it too. Thanks any help is much appreciated.