urgent reply needed

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 am trying to write code to copy a date range(with times included) to another worksheet in the same workbook. Example: eachdate range in column E would include only one month (say June dates) and only thatdata would go to a new worksheet. Then it would move to the next month incolumn E (say...

Please help! i have a spreadsheet i put together for a Manager (see below) Each column (H,M,R) represents locations on a job we need to close out. I used "CONDITIONAL FORMATTING" > HIGHLIGHT > DUPLICATES"..... showed to my manager, he loved it and wanted to know if we could highlight the...

<tbody> friday monday part qty date qty date 140880 25 6/20/2015 50 6/30/2015 140890 25 6/25/2015 7/15/2015 140891 30 7/20/2015 100 10/15/2015 </tbody> i have a report ran everyday for shipment dates i want to know if it is possible to pull in multiple dates...

Hi, I own a Salon and wish to set up a commission spreadsheet for my employees. I know that there has to be a way to do this in Excel. I want to be able to set it up with one side being 75% and the other 25%. Meaning, my employees pocket 75% of the sale and I pocket 25%. I would like to be able...

dear all, i have one text box and a search (command) button in one excel workbook (search workbook) and my database is in other workbook (data workbook).my problem is that user has to write few words in text box provided in search workbook and press search button,on search button macro has...