Using Excel Macros For Inventory

[Hightechinnovations]

I currently run contract for DIRECTV and I am using excel to manage all of my inventory. I have created an excel file to keep track of all of my equipment that I issue out of my warehouse. I currently have a couple of sheets including: "In Warehouse", "Returns", "Issued", etc.

What I am trying to do is be able to scan a serial number, have excel search through the "In Warehouse" sheet, copy the corresponding row and paste it into the "Issued" sheet. I have created a macro that will do just that, but the issue is that it takes too long for it to paste the entire row into the "Issued" sheet. I would like it to just paste the information from columns A through D in the row that the serial number was found. I would also like the macro to delete the row in which excel found the data from on the "In Warehouse" sheet.

Here is what I currently have:

Please Login or Register  to view this content.

I would appreciate any assistance. =0)

[Hightechinnovations]

Im sorry, the correct macro that I currently have is:

Please Login or Register  to view this content.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[jslavens]

Hello,
Here is an example of what should work or give you an idea or two.

Best regards,

Please Login or Register  to view this content.

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!