Copy cell information from a worksheet to another worksheet finding the matching unique number

[Jennifer Van]

I have a worksheet called Loan Request Return that gives information in rows V6, W6, X6, Y6

I would like this information copied to a worksheet called Equipment Library into rows J,K,L,M but not row 6 - I want the row to find the matching unique number which is located in column c for the Equipment sheet and in column M of the Loan Request Return

I have seen it done in an excel sheet before but just cannot get it! Can someone help please
Jen

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach screenshots (not pictures) of both sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[Jennifer Van]

Hi
Link Equipment Master.xlsm

In Loan Request Return worksheet, when rows V,W,X,Y are filled in
I want the information to automatically be copied over to the Equipment Library Worksheet entering the copied data into rows J,K,L,M

However, the bit I am stuck with is I want the copied data to match the equipment Unique code it refers to.
On the Request Return worksheet this UID is in column M
On the Equipment Library it is in column C

What I am doing is that when the "Loan Request Return" is completed, it automatically updates the Equipment Library showing the the piece of equipment is out
on loan, where it is, when it went and when it is due back - so we have a record of its current whereabouts.

When it is returned on Loan Request Return date AA it would be great if the information could be removed and status reads available but I think this is asking a lot!

I hope this all helps
Jen

 

[mumps]

Could you upload a version with columns Q:W unhidden?

 

[Fluff]

Duplicate to: Two or more VBA in one worksheet

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.