amanda

  1. M

    New tab when name changes in column A

    Please can you help with a script. I have a spreadsheet that goes on for numerous lines - I would like to create a news tab every time there is a name change in Column A - and copy the contents of all columns (B - G) - the name could appear on several rows. ie in the example below 3 new tabs...
  2. H

    Two-Way look up with criteria between two dates

    Below is a mock example of my spreadsheet. Column B has the names of Tutors who deliver training hours to the Students listed in Column A. And Colums C1:I1 have all the dates for every month (showing is just 23Jan-31Jan). SS#1 <tbody> A B C D E F G H I 1 Student Tutor 23-Jan 24-Jan 25-Jan...
  3. C

    Extracting usable data from DOS

    Good Morning, I am able to export some data from a DOS program I use at work that includes names and hours on work orders completed. I want to be able to pull the total by name into a separate, sortable column. I appreciate your help in advance. <tbody> What I would like Exported Data...
  4. M

    Repeat 1 cell as many times as there are entries in another column

    Hello! My ultimate goal is to pull 3 types of information from n number of worksheets into a summary page. I was successful with copying and pasting unique values (see below), however, I am having issues copying one cell from each worksheet and having it repeat multiple times. I have multiple...
  5. S

    Excel calendar_Pivot?

    Good afternoon!!! I have data with a bunch of dates for different people in Excel (see below for sample). I wanted to highlight these dates on a calendar. I downloaded a template calendar and used conditional formatting to highlight the dates on the calendar for each person. My issue now is...

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