multisheet

  1. C

    Totals by categorized sheets

    Hey, so i've been trying to figure this one out for a fair bit and have been really scratching my head. I've got a workbook containing multiple sheets of reporting, each one follows the same format, something like this USERNAME NONRELEVANT HEADER NONRELEVANT HEADER SECTION SCORE SCORE...
  2. G

    Need guidance on finding duplicate data in a multisheet workbook

    I have a 25 sheet workbook, that I need to highlight duplicates in only 1 column (the same column) in each sheet. Each sheet has another 15 columns of other data. The data is a 4 digit number. But maybe changing that to a string of text in the future. I have tried using conditional formatting...
    • gray_b
    • Thread
    • duplicate excel 2019 highlight multisheet vba
    • Replies: 23
    • Forum: Excel Questions
  3. S

    If sheet 2 cell b2= sheet 3 cell b2 and not 0 then show in sheet 1 cell b2 the number of cell b2 in sheeet 2 or sheet 3

    Hello, I have an issue with a code in this excel file I have done from the past. Basically I have sheet 1 which is doing the deduction of cells in sheet 2 and sheet 3. i.e Sheet 1 = Pending Sheet 2 = Order, Sheet 3 =Deliver So cell Pending cell B3 in sheet 1 is the pending amount of the...
  4. S

    mismatch error, pivot build automation, multisheets specific

    Hi, I am trying to create a pivot table on specific sheets. Initially, I had hardcoded the name of my sheets in the below line myarray = Array("ws1","ws2",etc) But now that I have created a dynamic named range, it does not work anymore. The problem returned at this point is a 'mismatched on...
  5. A

    If/then formula using multiple columns/sheets?

    I am working with two separate data sheets. One lists all the products in one column with pricing usage and vendors in columns next to it. In the new data sheet that I'm creating, I listed all the vendors in separate columns with the part numbers all in column A. I need to show (by highlighting...

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