Searching for a value/word in workbook, then changing an offset cell based on a criteria.

[Schaltz]

Hello dear fellow forum folk!

I am new to these forums so please be gentle :-)

I need some help creating a macro that does the following:

Firstly I need it to search the entire workbook for a certain word. When this word has been found the macro should then check if the cell above it equals another certain word (in my case "Salaries"), and if this is true then change the value/word of the first cell to something else (in my case "Social Securities"). If this is not the case then just continue throughout the workbook. The word can appear several time in each sheet, but it isn't always needed to change the value of the cell.

I've been trying to hatch patch a macro myself, and I've gotten it to find the word but then I got kind of stuck. Currently it's working but when i try and add things, it just isn't running correctly. Hope someone out there has an idea :-)

Here is my hatch patch macro:

Please Login or Register  to view this content.

[Sc0tt1e]

You will get a post stating you are breaking one of the rules with such a vague heading.

Please amend and be more specific (I think it can be done under "Thread Tools".

[Sc0tt1e]

I'd work along the lines of

Please Login or Register  to view this content.

[FDibbins]

post deleted, Fotis beat me to it

I have added code tags for both, please use them ion future

[Schaltz]

Apologies for not reading the rules. This will not happen again.

Thanks for adding the code tags Fotis1991. I also changed the title to attempt a more appropriate title.

I will try and use the code you posted sc0tt1e thanks

[Sc0tt1e]

Lol, oh the irony

Apologies, saw an error or two and reposted overwriting the tags, won't happen again boss