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!
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!