Find and Replace Based on a Table

farles44

New Member
Joined
Oct 14, 2016
Messages
7
Hi Everyone,

This is my first post. I am not great with excel (I mostly accomplish what I want via record macro). I have no idea how to start to write a VBA or Macro, but I have a request. Can someone help me get started on writing what I assume is a very simple VBA. If you happen to know how to write this, can you also help me with uploading into excel?

Ideally what I need to do is this:

Have a 2 sheet workbook. Sheet 1 would be a place users could past in their data. This data has a column that has information that isn't readable but corresponds to a key.

For example, the data pasted into sheet 1 might be a bunch of transactions (Any column or row), and the transactions are identified with

NA-24m
BC-23m
AD-55d



On Sheet 2 in the workbook, there is a key (A1:B335) that has the corresponding info:

NA-24M = Return Transaction
BC-23m = Discharge Transaction


I have used V-lookup for myself to easily identify what the codes refer to, but I want to create an excel document that has a macro build into a button that other users in my department can press to essentially find and replace all the codes with the corresponding transaction type based on the key table on sheet 2. Lastly, the sheet names could potentially change names...not sure if that is pertinent.

Any help would be appreciated!
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,223,236
Messages
6,170,912
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top