I have a pivot table (Columns are Name and marks) and I have created a dropdown that contains a list (Alphabetical, High to low, and Low to high)
If I choose Alphabetical my pivot should get sorted in Alphabetical order by Name column
If I choose High to low my pivot should get sorted in...
i create daily stock distribution order and want to distribute a value (warehouse stock) based on 2 different values(pharmacy stock & pharmacy sales).
For example, my stock in warehouse is 20 units and in a pharmacy the stock for same item is 10 units but the sales of that item in that pharmacy...
Hello Everyone,
I am working on a Userform and need your urgent help on the same.
Purpose of this userform to open relevant workbook which are attached in workbook as Object
In userform
i have a drop down by the name of ComFruit
under that there are fruits name like Apple1, Apple2 and...
Hello Everyone,
Really need an assist on this. I am building a workflow management tool tracking availability and workload of several workers across many projects. I need to build a table, without vba if at all possible, that automatically populates comparing to separate copies of a report and...
Dear All,
There are two column mentioned below
<tbody>
Animal Name
Animal Type
</tbody>
In the column named "Animal Name" there is data validation of all Animal like
<tbody>
Goat
Cow
Horse
<tbody>
Lion
Tiger
Fox
</tbody>
</tbody>
There are two other column
<tbody>
Types...
hi, i have a code to calculate the total cost of international and then national calls and past it in a separated sheet called Synthesis. But it doesn't seem to work and i cant figure out why :confused:
Sub MC()
'Copy COST FOR INTERNATIONAL CALLS
ActiveWorkbook.Sheets("Sheet6").Activate
Dim...
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.