Find / Replace : Can it be used in Pull Downs to make a change to an entire sheet?

[picataggio]

In a workbook I created for tracking all my CC spending, I have a sheet where I put all my Transactions for the month.

Date, Month, Description, Amount, Category, Sub-Category, Category Type, Who

Category and Sub-Category are PULL DOWN choices.
Depending on the choice you make in the pull-down box on CATEGORY will then give you the correct choices for the SUB-CATEGORIES pull-down.
(Hope that makes sense)

I noticed I got a bit too Granular in the SUB-CATEGORY choices.
What I want to do is consolidate. I am hoping I can do this with a simple FIND/REPLACE.
But before I do, I figured let me post this before Blowing a bunch of the Cells up

For instance, if in the CATEGORY pull down, I choose ENTERTAINMENT / SUBSCRIPTIONS the SUB-CATEGORY Pull Down will give me the following choices.
Streaming
Movie
Books
Memberships
Amusement
Software Subscriptions
Concert / Event
NewsPapers & Magazines
Movie - Streaming
Steaming - Subscription
Storage
PPV
Game

As you can see a bit to granular.
I was going to start with consolidating all transactions with the Sub-category "Movie Streaming "into the "Streaming" option.

Will a simple FIND / REPLACE work on this or will I need to go to each Cell and use the pull-down to make the change?

Any thoughts would be great.

[Sam Capricci]

A simple find and replace should work, just make sure you use entire cell contents as the selection so it doesn't necessarily go after other "streaming" options you don't want changed.
Also, remember that if you are not satisfied with the results don't save upon exiting or save your original and work with a copy to make sure if you don't like the results you don't have to rewrite the whole workbook.