Moving information to first available row

Microsoft Excel 2003 (full product)
May 15, 2012 at 13:13:48
Specs: Windows XP Professional
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.


See More: Moving information to first available row

Report •

#1
May 15, 2012 at 13:27:27
What triggers the copy? A manual entry into a specific cell?

Do you really want to copy it or copy and delete it?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
May 15, 2012 at 13:52:30
I don't know if its possible (again, i'm a complete newb), but i'd like to assign a keyboard shortcut that could trigger the copy. I don't know how else it would make sense to trigger it.

It would be nice to be able to copy AND delete...in that case I would want a second piece of code that would do the opposite...i'm checking out items that will eventually come back, so ideally I would have another set of code to send it back from "ISSUED" to "Displays".


Report •

#3
May 16, 2012 at 12:47:34
Try a library application. It may have what you are looking for.

Report •

Related Solutions

#4
May 16, 2012 at 12:51:59
re: "I don't know how else it would make sense to trigger it."

A macro could monitor a column, for example, and as soon as a keyword was entered, e.g. "Issued", the row could be copied to the other sheet and deleted from the original. It could also be hidden on the original sheet instead of deleted.

It could be moved back to the original by a keyword in the other sheet.

Just some ideas....

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question