automatation

  1. J

    Remove cell contents based on date - VBA

    Hi everyone, Basically, I have a list of names and reasons for people being on a list. Plus the date their names were added to the list. What I'm wanting is for the line with their info to be removed after 7 days when we open the spreadsheet. Referring to the image, lets take row 2-4. Their...
  2. S

    Mass extraction of multiple Pivot table setup conditions

    I inherited 5 excel files between them have >100 individual pivot tables across multiple worksheets. Some sheets have multiple tables. I’d like to extract the file name, worksheet, cell location and most importantly, pivot table setup conditions (filter selections, rows, columns & values) for...
  3. E

    Advice on how to streamline/improve this spreadsheet?

    Hi all, For context, we use a spreadsheet to track the progress of specific work we do for clients. Each client has an assigned prepared and reviewer, and there are a bunch of steps in the process that we complete. This involves manually adding dates on the date that the specific task has been...
  4. A

    Apply Macro/VBA to All Sheets Based on Multiple Sort Conditions

    Hi, I have a excel with several tabs. I need to automate the sorting logic for all tabs. Sorting order should be as follows: 1) Based on Highest Score - Column Name 'Score' 2) Based on Highest Change in Score - Column Name 'Change in Score' 3) If after doing the above 2 sorts there are 0s at...
  5. X

    Separate Pivot chart for each Pivot table sheet from "Show report filter pages"

    Hi, I created 20 pivot table reports on separate sheets - 1 for each department - showing compensation for staff members in a team from a data table using the "Show report Filter pages" features menu in Pivot tables. Is there a way to automatically create separate column charts on...

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