First I'm to VBA code. I have a workbook that has three tabs (Medications) (Hard Items) and (Emergency Supply Request). Each item in the Medications and Hard items has an ID #. What I am looking to do in the Emergency Supply Request is put the ID# starting in column A9 and have it search the other two sheets, find the ID# and copy the row, until my request is filled.
I have searched and read many of the old post but can't seem to find one that fits my needs or able to change it and work for me. Any assistance will be greatly appreciated.
Thanks in advance for you time.