sheetname

  1. R

    Compare a list with sheetnames and on match do copy-transpose operations

    Hi! I have a problem. I have a Workbook named 'SalesData.xlsx' which contains two sheets 'Demand' and 'Availability'. Column A of these worksheets contains CUSTOMER names and remaining thirteen columns contain month-year data. The following needs to be done with both sheets i.e. 'Demand' and...
  2. J

    Run-time error '9': SUbscript out of range?

    This error message pops up when I run the macro, "Run-time error '9': Subscript out of range" I was wondering what could be wrong with the code? "Sheets(sheetName).Activate" is highlighted. THANKS!!! Here is my code: Function calAutoNumber(sheetName As String, StartCol As String, startrow As...
  3. F

    use a formula to reference a sheet name. example... =(F3-14)!a1

    Hello, is there a way to use a formula to reference a sheet name. example... =(F3-14)!a1 Where F3 is a date and by misusing 14, the resulting product would be a new date. This new date would be a sheetname from which you would reference and use cell A1
  4. R

    Macro to copy only the numbers on a cell and making them numbers the Sheet Name

    Hi Guys, I nearly have my Macro finished stuck on one thing. I want to make Cell A4 my Sheet Name. Cell A4 contains both Letters and Numbers Cell A4 may start with a word eg 'property: 165666' I Just was the Number 165666 as my sheet name. Also After the property number I want the Letters...
  5. D

    Need cell formula to find sheetname of tab n-tabs before current

    Hi guys, I have a workbook which I'm not allowed to share or publicate. Inside the there are a lot of tabs, amongst them: '0' Start of Costcenter tab range '13134' one of the costcenter tabs '9' End of Costcenter tab range 'Config' a check/lookup/reference sheet. Between the '0' and '9' there...
  6. E

    Sum values until the active sheet

    Hello all, This is my first post here. I've searched the entire forum but couldn't find an answer for my situation. This is what I am trying to do; My sheet names are the dates of the month.. 07 Feb,08 Feb,09 Feb etc.. I want to sum up the values in a cell(for example L41) in every sheet from...
  7. K

    Formula to Return Excel Sheet Name

    =""&MID(CELL("filename",Sheet1!$A$1),FIND("]",CELL("filename",Sheet1!$A$1))+1,256) 1. Change filename to the your workbook's filename. 2. Change Sheet1 to your current sheetname where you have pasted the formula. This formula below which I found on many forums doesn't really work because...
  8. pedie

    VBA to Add a new sheet and name it.

    Hi, I need a code: If Sheet names in book1 which is opened does not match the value of F4 then add a new sheet and name it as f4.value Thanks for helping Pedie;)
  9. R

    cell linked to a sheetname created VBA

    Hi, The first part of my program is about a solver that creates a new sheet with the same format everytime it runs so the user can keep a trace of different scenarios. But now i have another sheet called "Data Comparison" and I want to define two cells where the user can add the name of the...
  10. S

    List Worksheets and select one (or more)

    I am sorry if I am repeating a thread here, but I've tried to find something that will help me, and can't. I have a model which produces a new worksheet each time it is run - and old sheets are hidden from the user. I need to write some code that will take the names of all spreadsheets and...

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