vba find replace

I feel like this is a basic question but can't figure out how to automate it with a macro. Example of what I'm trying to do: Column A has Cities and Column B has the time zone. I need to replace the time zone based on the city to the state it belongs in. I know how to set it up the slow way of...

Hi All I am trying to write a code to analyse a column and lookup each value in turn on a seperate table. I would like it to look at the value (text comment) and if it contains a key word in a lookup table return the corresponding value and input it into the adjacent column. So far my code...

Hi, I hope somebody can help with this issue that im struggling to solve. I have a list of data in sheet1, I need to find text in a column within "Sheet1" and replace it with text that is in a range located in sheet2. For example, the range is C5:D34 (sheet2), i need to find what is in C5 of...

I have a column called "specialty" with about 2,000 rows. Each row can be one of about 20 specialties (the specialties are professions, such as analyst, chef etc etc). Each of these specialties must be re-grouped further into 5 upper level headings (e.g. office, services, trade etc) What I...