Two or more VBA in one worksheet

[Jennifer Van]

I already have a VBA which copies a line from worksheet Loan Request Return to another worksheet called WaitList if cell Q says yes.

What I need now is if another cell "AB" says Yes, to copy the cell to another worksheet "Repairs Remove"

And if possible, columns K,L,M data (if data is in there) only be copied to a sheet called Equipment Library and not only to an empty cell, it goes to the cell which holds the same UID (UniqueID) which then shows that the equipment is on loan etc?

Thank you, I know this is a lot to ask

 

[Jennifer Van]

Hi
Set wsLRR = Sheets("Loan Request Return") - It is showing an error Runtime error '9' Subscript out of range
Can you help again sorry
Jen

 

[vcoolio]

Hello Jennifer,

That error indicates that the worksheet can't be found and I'm assuming that this has appeared in your actual workbook. Check that the spelling, punctuation, spacing etc. is exactly the same as your tab name or simply re-write the tab name and ensure that the code entry is exactly the same as the re-written tab name.

Cheerio,
vcoolio.

 

[Jennifer Van]

Hi
I couldn't see any difference but copied your code and paste into tab name and was totally blown away when it worked!!!! Thank you so much this is awesome - going to save so much
time and stop errors.

Are you able to assist with one more code?
Jen

 

[vcoolio]

You're welcome Jennifer. I'm glad to have been able to assist.

Are you able to assist with one more code?

If it's related to this, then yes. Otherwise, you'll need to start a new thread.

Cheerio,
vcoolio.