|Ok...very new to using macros, so bear with me. |
I have two sheets in my document, one with a list of inventory items (labeled Displays), and the other blank (labeled ISSUED). Each inventory item has information in columns A-F such as serial numbers, make and model, etc. As inventory items from within Displays are "issued", I copy the information from that items' row (A-F) into the first available row within the ISSUED sheet. This is obviously tedious data entry, and i'd like to automate it. What code would make this happen? I would ultimately want to do a search for the information in column a, select the specific item in column a and then hit a keyboard shortcut to copy the whole row (a-f) over to the ISSUED sheet.
I hope i've explained this clearly enough, and thank you in advance for any help.