Need a macro that finds specific text in all sheets of a workbook

**aerodragana** · 03-10-2013, 05:34 AM

Hi,
My problem is actually very simple. I need a macro which will find all cells containing text "date:" and then insert value of cell B3 of the first sheet in cell on the right...
Example: cell C5 in the sheet2 contains text "date:", so in C6 should be value of cell B3 in sheet1.
Thanks in advance!!!

**dilipandey** · 03-10-2013, 06:40 AM

Hi aerodragana,

welcome to the forum.

Example: cell C5 in the sheet2 contains text "date:", so in C6 should be value of cell B3 in sheet1.

would it be C6 or D5 ?

Regards,
DILIPandey
<click on below * if this helps>

**aerodragana** · 03-10-2013, 07:25 AM

Oh, my mistake!
You are right, D5.
Thanks a lot!!!

**dilipandey** · 03-10-2013, 09:22 AM

Okay.. try using below macro:-

Please Login or Register  to view this content.

see attachment:- Searching a value across workbook and filling next cell.xlsm

Regards,
DILIPandey
<click on below * if this helps>

**aerodragana** · 03-10-2013, 09:44 AM

Thanks a lot! However, what if sheets change their name? It doesn't work than

**dilipandey** · 03-10-2013, 09:48 AM

I considered this.. but somewhere we need to start, so given you a code with sheet 1 as my assumption.

Okay.. it is related with only b3 value and you can anytime revise below code:-

b = Sheet1.Range("b3").Value

apart from this, rest of the code is independent of the sheet name

Regards,
DILIPandey
<click on below * if this helps>

**aerodragana** · 03-10-2013, 10:26 AM

Thanks, however in my workbook doesn't work

It highlights this row:
b = Sheet1.Range("b3").Value

**AB33** · 03-10-2013, 11:04 AM

Try this one

Please Login or Register  to view this content.

**aerodragana** · 03-10-2013, 11:23 AM

Hi guys,
Thank you! I think it's my Office, it's in Spanish so all the functions are in Spanish...

**dilipandey** · 03-10-2013, 01:46 PM

okay.. can you upload your workbook ? thx

Regards,
DILIPandey
<click on below * if this helps>

**downtown1933** · 03-10-2013, 02:05 PM

Please Login or Register  to view this content.

**AB33** · 03-10-2013, 06:30 PM

My code is based on DILIPandey's attached sheet.

**aerodragana** · 03-11-2013, 05:04 PM

Thanks to all! I have tried all your codes and they work, so I really appreciate possibility to see different approaches

Thanks a lot!

**dilipandey** · 03-12-2013, 10:34 AM

Great..!!

Please mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey
<click on below * if this helps>

Need a macro that finds specific text in all sheets of a workbook

LinkBack

Thread Tools

Rate This Thread

Display

Need a macro that finds specific text in all sheets of a workbook

Re: Need a macro that finds specific text in all sheets of a workbook

Re: Need a macro that finds specific text in all sheets of a workbook

Re: Need a macro that finds specific text in all sheets of a workbook

Re: Need a macro that finds specific text in all sheets of a workbook

Re: Need a macro that finds specific text in all sheets of a workbook

Re: Need a macro that finds specific text in all sheets of a workbook

Re: Need a macro that finds specific text in all sheets of a workbook

Re: Need a macro that finds specific text in all sheets of a workbook

Re: Need a macro that finds specific text in all sheets of a workbook

Re: Need a macro that finds specific text in all sheets of a workbook

Re: Need a macro that finds specific text in all sheets of a workbook

Re: Need a macro that finds specific text in all sheets of a workbook

Re: Need a macro that finds specific text in all sheets of a workbook

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions