gary

  1. J

    Help with VBA

    Hello Folks Ive had help to get as far as I have from people on this forum, thank you. but I'm after a little more help please. the code does what I need it to I just need a little tweak. it allows me to copy but when I select the next cell but it won't let me paste because it locks the cell...
  2. J

    List column headers where value is true

    I have a list generated from another program of all of the locations one person worked at. It looks like this. The order of the locations is listed randomly: <tbody> Gary Linda Marissa Brad Xavier Lincoln Wausau Annapolis Laredo Bethesda Laredo Bethesda Waco Annapolis St Louis Wausau...
  3. S

    Matching 2 Cells to get the 3rd

    Hi, i'm hoping this is an easy one, i just can't get my head around the formula to use. Below is my spreadsheet with all my players on the left & every position they play in & their ratings. On the right is every individual player & their BEST rating. What i'm wanting is for on the right under...
  4. L

    Copying contents of a cell based on a 'match' from two columns

    Hello, I am trying to collect data from different sheets into a table. I’dlike the table to auto-fill based on the date of the day, and matching the name. The formula shouldn’t count entries, but rather report or copy the number entered in the cell for that person on that date. Example...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top