macro to find from one cell and replace using inputbox (multiple tabs)

[bwaite87]

Hey all,
I have several tabs (1004, 1009, 1109, 1201, Change Week-Period)
In the change week period tab I have:
Cell F3: Week 1
Cell J3: Period 8

I would like a macro that would “find” week 1 from that tab [Change Week-Period Cell F3], and “replace” the phrase “week 1” in all tabs (1004, 1009, 1109, 1201) with whatever I type into an input box.

Can you help me out?
Thanks!

[Mumps1]

Can I assume that you want to replace whatever you enter in cell F3 in all the other sheets with the value you enter in an input box?

[bwaite87]

yes, that's correct

[Mumps1]

Try this code. Change the sheet name "Master" to match the sheet name that contains your data.

Please Login or Register  to view this content.

[Winon]

Hello bwaite87,

Mumps1 gave you a neat piece of Code.

However, if you do not have, or want to use a "Master Sheet", you could change the Code to:

Please Login or Register  to view this content.

Also see the "Please consider" note at the bottom of this post.

[bwaite87]

Hi guys,

Thank you both for your contribution. Unfortunately I gave Mumps1 incorrect info.
I don't want whatever is typed in cell F3 in all the other sheets with the value entered in the inputbox.

I want the entire sheet (range A21:AX21 would suffice) in all other sheets (1004, 1009, 1109, 1201) to find only the phrase "week 1" and replace that phrase with what I enter in the inputbox.
The purpose of this is to update the filepath in my vlookup formulas every week.

Any additional help would be greatly appreciated.
Thanks!

[Winon]

Hello bwaite87,

Will this do it for you then?

[bwaite87]

Sorry but no it didn't.
Here's my formula (in multiple cells in all sheets)

=IFERROR(VLOOKUP("cake fresh",'S:\RSR Settlement\RSR Settlement - WEST\Outlet-Texas\Outlet TX Weekly Recaps\2013\P8\Week 1\[1004.xlsx]WEEKLY RECAP'!$A:$C,2,FALSE),0)

I want something that can just replace "Week 1" with, "Week 2" for example, without clearing the entire contents of the cell in the process, and without having to highlight all worksheets and "finding" and "replacing" Week 1 with Week 2. A macro makes it much simpler and my colleagues are less likely to screw it up that way

Any other ideas?

[Winon]

Hello bwaite87,

Mumps1 has aked you

Can I assume that you want to replace whatever you enter in cell F3 in all the other sheets with the value you enter in an input box?

and you replied in Post No3;

yes, that's correct

From that confirmation we have been giving you what your requirements appeared to have been.

The contents of your last post is entirely different from your initial request, and since you do not seem to be exactly clear as to what you really require, I feel myself obliged to unsubscribe from this Thread.

I help where I can, as everyone else on this Forum does, but when the "bar" gets raised with every response, without an example demostrative sample WorkBook, showing the exact requirements, I lose interest in the topic.

Good Luck!

[Winon]

Hello bwaite87,

Mumps1 has aked you

Can I assume that you want to replace whatever you enter in cell F3 in all the other sheets with the value you enter in an input box?

and you replied in Post No3;

yes, that's correct

From that confirmation we have been giving you what your requirements appeared to have been.

The contents of your last post is entirely different from your initial request, and since you do not seem to be exactly clear as to what you really require, I feel myself obliged to unsubscribe from this Thread.

I help where I can, as everyone else on this Forum does, but when the "bar" gets raised with every response, without an example demostrative sample WorkBook, showing the exact requirements, I lose interest in the topic.

Good Luck!

[Mumps1]

Will this do it?

Please Login or Register  to view this content.

[Mumps1]

Will this do it?

Please Login or Register  to view this content.

[bwaite87]

yes, thank you!

[Mumps1]

My pleasure.