multple sheets

  1. B

    Lookup data from multiple sheets within a date range

    Hi, I’m hoping you can help me, I stupidly said I could help a colleague with his excel sheet but this is proving way beyond my knowledge. I have multiple sheets for tracking spending from different budgets. On the final sheet I want to be able to pull all the row information from across all...
  2. D

    Copy named ranges from multiple sheets to summary sheet

    Hi I have a workbook that contains multiple worksheets some of which have named ranges that I want to copy into a sheet called 'Combined'. I have created some simple VBA code that does that but it copies the source formulas into the destination cells rather than the values. Checking through...
    • DYB
    • Thread
    • copying named ranges multple sheets
    • Replies: 3
    • Forum: Excel Questions
  3. zakasnak

    average array across multiple sheets

    I have this array formula that works perfectly. =AVERAGE(IF(N(INDIRECT("'"&$W$4:$W$11&"'!E4"))>0,N(INDIRECT("'"&$W$4:$W$11&"'!E4")))) My problem is that when I copy this formula thru the thousand or so rows (sorry, 969 rows to be exact), the *row* indicator '!E4 does not update. Is this...

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