Hi
can I get some help to make a macro?
The macro that reads column J (Pick) if there is an 'x', then return adjacent cell value in column K(Data) to a list in column M (result)
JKLM3PickDataResult4xCarCar5HouseCat6xCatDog7xDog8Cabin
I am trying to use a forumla to look at the value in column b then create a unique id in column a based off of that value. In the table below I have a 3 digit value (in column B) that may be repeated any given number of times and if so I want the corresponding text in column "A" to equal that...
I have an order number such as 012, 013 in a separate sheet with details like
<colgroup><col><col><col></colgroup><tbody>
Order No
012
Status
UserName
Action
Process
Tom
Await Approval
Process
Richard
Await Approval
Process
Swetha
Await Approval
Process
Michael
Rejected
Process...
I have an order number as (o12) in a separate sheet with details as
<tbody>
Status
UserName
Action
Process
Process
Process
Process
Marimuthu
Rejected
Process
Gopi
Approved
Process
Gopi
Approved
Process
Process
Process
Process
Gopi
Approved
Process
Gopi...
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.