Search for a value and if the value is found copy the whole row. And repeat the proces

**beamonemo** · 08-13-2012, 07:42 AM

Hello,

I am trying to do two things

First in the sheet "All Numbers" using the value in column A, search this value in the sheet "internal numbers" in column A.
If the value is found in the sheet "internal numbers" write the word "OCCUPIED" in column E of the sheet "All Numbers"
Else if the value is not found in the sheet "internal numbers" write the word "FREE" in column E of the sheet "All Numbers" and repeat for all the rows in sheet "All numbers""until the value in column A is empty

Second
First in the sheet "All Numbers" using the value in column A, search this value in the sheet "internal data" in column A.
If the value is found in the sheet "internal data" copy the whole row (A:AX) total of 50 columns from the sheet "internal data" and append it to the row "All numbers" from column F ( so column A from "internal data" becomes colum F in sheet "All numbers"
Else if the value is not found in the sheet "internal numbers" goto the next row and repeat for all the rows in sheet "All numbers""until the value in column A is empty.

Many thanks in advance

Regards Kevin

**mike7952** · 08-13-2012, 08:36 AM

Give this a try

Please Login or Register  to view this content.

**beamonemo** · 08-13-2012, 09:08 AM

Mike,

Many Thanks!!!!!!!!

**beamonemo** · 08-13-2012, 01:21 PM

Dear Mike,

Thanks for your help this morning. I was wondering if you could help me again? I included a new example sheet ( numbers2) and was wondering if you could help me accomplish question 2 for the first request. I modified the request a little.

Many thanks

**mike7952** · 08-13-2012, 02:01 PM

Not sure if this is what your meaning or not

Please Login or Register  to view this content.

**beamonemo** · 08-13-2012, 02:34 PM

Dear Mike,

Many Thanks Again!!. It does exactly what i was looking for.

Again Thanks.

Regards Kevin

Search for a value and if the value is found copy the whole row. And repeat the proces

LinkBack

Thread Tools

Rate This Thread

Display

Search for a value and if the value is found copy the whole row. And repeat the proces

Re: Search for a value and if the value is found copy the whole row. And repeat the proces

Re: Search for a value and if the value is found copy the whole row. And repeat the proces

Re: Search for a value and if the value is found copy the whole row. And repeat the proces

Re: Search for a value and if the value is found copy the whole row. And repeat the proces

Re: Search for a value and if the value is found copy the whole row. And repeat the proces

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions