Find & Replace on workbook " HELP " :(

[jetlee]

hi everyone, and first thinks first, thanks for having me .

ok, i got a workbook with 7 worksheets and i want a Macro on 8th page of the workbook to search for a product, and replace the price that is located on same row, but different column.
there is below an example so you can understand what i need :
column(A) Col(B) Col(C) Col(H)
SKU commodity product Price

so, i want a Macro search, that will scroll on all sheets (7) and find the product name from column C and replace his price on column H.

is that possible to happen?
Thank you in advance for your help

[abduljaleel.mca]

Something I can't understand, send me an example file with highlighted expected output in it.

Abdul

[HaHoBe]

Hi, jetlee,

use FIND to build a range object which may be used to replace as it would deliver a range to use for Offset to replace. Will it only be one product on one sheet, one product on multiple sheets or multiple founds on sheets?

Ciao,
Holger

[jetlee]

Something I can't understand, send me an example file with highlighted expected output in it.

Abdul

i am sending you a PDF with a comment, and explenation
i hope this helps.
thank you so much for your reply.
Page 1.pdfPage 1.pdfPage 1.pdf

[jetlee]

hi, i have tried this way, but is too much to keep going to different sheets from the find search and change the prices, but thanks for the reply.

[abduljaleel.mca]

Just to confirm, is this the o/p you are looking for?...It is just an example file for 1 sheet.....Please confirm so that I can start work for you...

[jetlee]

Just to confirm, is this the o/p you are looking for?...It is just an example file for 1 sheet.....Please confirm so that I can start work for you...

yes, the macro needs to find the product name i will type, and then go to column H and change the price i give.
Macro then will scroll all sheets, and where is same product name, will change his price.
Product is located on all sheets on column C, and price on same row as the product, but on column H.

thanks in advance

[abduljaleel.mca]

OKay....clear now....wait for sometime....


Abdul

[jetlee]

OKay....clear now....wait for sometime....


Abdul

Thank you !!

[abduljaleel.mca]

Use the attached macro.....

[jetlee]

Use the attached macro.....

hi, i will do soon as i get home, because on the excel im using, i havent got the developer tub to see the code.

thank you very much, and i will let you know later the results

[jetlee]

Use the attached macro.....

Many Thanks !!!!!

works like a charm !!

very much appreciated !!!

[abduljaleel.mca]

Thanks for the feedback....Mark this thread as Solved...

[jetlee]

Stock Sheet V 4.xlsm

Thanks for the feedback....Mark this thread as Solved...

hi again,
when i put it to work on my sheeet, gives me : Error run time 91
object variable or with block variable not set.
i'm sure is an easy fix, but i am sending you the workbook too.
thanks again and sorry.
this is where the code is highlihted:
ch = Cells.Find(What:=prdname, After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate

[abduljaleel.mca]

I am looking in to this....

[abduljaleel.mca]

This is because of no product found in the excel file you entered, will send you the updated file shortly..

[jetlee]

This is because of no product found in the excel file you entered, will send you the updated file shortly..

thank you, that's great !!

[abduljaleel.mca]

Use this one...Let me know if any more concerns...

[jetlee]

Use this one...Let me know if any more concerns...

THANK YOU !!
that's what i wanted !!
you are a star !!