sheet names

  1. V

    "dragging" formulas to change sheets

    Hello, I've a spreadsheet with multiple sheets called "Obsevations (1)", "Observations (2)" ... "Observations (20)". I need a summary page, and want to copy cell E16 from each of the Observation sheets. I have tried by going: =Observations (1)!$E$16 and dragging, but the reference to the...
  2. M

    Rename sheet tabs

    The code below works for renaming all work sheets in the workbook, however I would like the ability to rename sheets 1 thru 10 and keep the current names in worksheets 11-20. Can anyone help with this. Sub RenameTabs() 'If cell A1 has no content, then that tab is not renamed. For i = 2...
  3. T. Valko

    List worksheet names using a formula

    I don't know if this topic has been posted before (I didn't do a search!) but if anyone's interested here's a formula method to list worksheet names. This uses an old macro function. Create this defined name: Insert>Name>Define Name: SheetNames Refers to: =GET.WORKBOOK(1)&T(NOW()) OK...

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