numbered

  1. C

    Count & if Across All Sheets

    Good day! Looking for some help here please :) I have a workbook, with sheets Metrics, Master, numbered sheets 0001-0076 and Last sheet on the workbook is "Lists". Sheets 0077-1000 will be added at a later date. I'm looking to pull data from other sheets into my Metrics sheet. I have a...
  2. P

    Renaming Multiple Tabs

    I have hundreds of tabs in an excel file all labeled with #1 and so on. How would I go about renaming all the tabs in one go to just getting them numbered such as 1, 2, 3, ...
  3. C

    Excel can do it! Past Occurrence.

    <tbody> 5 5 2 10608 2 2 2 3 4 5 10607 1 1 1 3 4 5 10606 4 2 4 5 5 2 10605 4 5 3 4 4 3 10604 2 3 5 1 2 1 10603 4 5 4 4 1 2 10602 5 5 3 3 4 5 10601 5 4 2 5 3 4 10600 4 3 4 1 5 5 10599 5 4 1 2 2 5 10598 2 4 5 4 3 2 10597 3 1 3 2 3 1 10596 2 5 1 5 5 1 10595 2 1 5 2 5 2...
  4. P

    problem with relative references / anchoring when copying formulas from one range to another

    Hi. I'm using this line: Range("Scen_Active").Offset(0, (1 + Range("Scenario_Destination").Value)).Formula = Range("Scen_Active").Offset(0, (1 + Range("Scenario_Source").Value)).Formula to copy scenario inputs from one column/scenario (numbered as Scenario_Source) to another (numbered as...
  5. A

    stdole32.tlb

    Using Excel 2007 and getting this message on launch, followed by a long wait as configuration runs (every time). On Googling I see it's quite common and caused by some Windows update. But the instructions for fixing are many and varied. Some say repeat steps 5-8 but they're not numbered. Or you...
  6. A

    Numbered worksheets

    Hi I have a workbook with numbered tabs (sheet names). In Vba, when i want to refer to say sheet name 24 (tab name) , how would i do that using a variable. x = 24 Sheets(x) doesnt work, that gives me something else. Its not even the code name. Many thanks, Amit
  7. D

    numbered list ?

    is it possible to have numbered list in Excel, for each row, like in Word? I don't want a numbered list in a single cell, but this: [row1] 1.1 text [row2] 1.1.1 text [row3] 1.1.2 text which will be updated automatically depending on the indent level ?

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