1. E

    If value selected on dropdown then copy range

    Hi All, I have a drop down with 4 options, depending on which option is selected the corresponding sheetname would be selected and column A would be copied to the clipboard. e.g the dropdown values are as follows ebay, amazon, otto, tesco and the sheetnames are the same Any idea how this...
  2. M

    Indirect referencing Workbook and Worksheet and Cell - not working

    Hi, This should be straight forward but I can't see what I'm missing. On Sheet 1 in Cell O4 I have the name of a Workbook (not the one I'm in) but it is open. On Sheet 2 I have the name of the current Sheetname in Cell P1 (which will be identical sheet on the Workbook I have the name of in...
  3. B

    VBA Run macros on multiple sheets, not all sheets

    Hello, I have a button running three macros. I was to have this run through multiple sheets in a workbook, but not all the sheets. Just selected sheets. I have this code on the button. It seems to run through and select the sheets as the message box pops up. But it is not actually running the...
  4. G

    How to use Formula in DataValidation List Source

    Hi friends, I need to use a formula in the Source: of my Data Validation to include the Sheetname for my drop down list. The following formula should work if someone can please show me how to properly QUOTE it. I get very confused trying to put quotes within quotes. To be clear, the...
  5. S

    Sum of Amount with Amount Recieved and Amount Receivables with the Date Range entered in Textboxes respectively

    Hi Want your help to get a report on Date wise with Sum of Amount, Amount Received and Amount Recievables and as I’ve Two Textboxes ie TxtFromDate.Text and TxtToDate.Text and two buttons for generating each report on userform So will Enter 01-01-2019 in TxtFromDate.Text and 15-01-2019 in...
  6. O

    Activate A Sheet Based on a Cell in a Current Worksheet

    Thanks in advance for your help and I will let you know what it took to make it work. I would like to activate a sheet based on the contents of a cell. For example within Sheet "Simulation". Cell C3 contains "Evaluate1", I would like to activate that sheet. I tried the following, but I get a...
  7. N

    How to add new sheet with sheet name is the day of month

    Hi all I have workbook with some sheet(MAIN, BC1,BC2, PL1,PL2,....,PL30) and now Iwant to have a macro that when I type 201810 in sheet(Main).range(A1) then run macro workbook add 31 newsheets with sheetname is the day of month like: 20181001, 20181002,.....,20181031 Next month, I type 201811...
  8. K

    Countif, Index, indirect, Match

    The below formula is not giving me correct result, please help me. =COUNTIF(INDEX(INDIRECT("'"&SheetList&"'!C5:AM200"),MATCH(B5,INDIRECT("'"&SheetList&"'!C5:C200"),0),),"al") Note: SheetName = All the sheet name.
  9. S

    Return Sheetname for different Worksheet

    I know that the following function returns the Sheetname for the current Worksheet: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) But I'd like to return the Sheetname for the Worksheet that is one tab to the right. Is this possible? I add new Worksheets with each new day with...
  10. C

    Generate sheet by running macro through hidden sheets

    Hello peeps, I need some help here. When the COMMS & GO box are checked, and I click on Generate Form, it will move to the "COMMSGO" Sheet. I manage to do until here. But however, I just it to show only the "COMMSGO" sheet and the rest hidden. Same goes if i do it for other sheets. How do I...
  11. I

    Select sheet based on variable declared - VBA Code Query

    Hi All, I am new to VBA and this is my first post in this forum. I am currently stuck with an VBA error and can somebody help me on this plz. Case Scenario : Copy paste sheets ( from one book (test.xlsx) to another (book1.xlsm) with sheet names declared with variables C1, C2...
  12. A

    Remove Dashline from multiple sheets name using macro

    Dear Sirs, May I have your help on the following I received a workbook with multiple sheets I want to make an indexsheets with hyperlink to each sheets The problem the sheetname contain dashline which make the hyperlink not work. (Each sheets have different name with dashline in the sheetname...
  13. T

    VBA - run time error '13' type mismatch selecting sheet based on named range

    Hi everyone, Please can someone help me with the following, apologies if this is quite basic. I've not done any VBA for a long time and I'm out of practice. In my Excel workbook I have a number of buttons to take you to different sheets in the model, I'm trying to write code that can be...
  14. A

    External sheetname variable in VLOOKUP

    Hi I've googled for hours for a solution on this, but couldn't find anything that seems sustainable. In a given cell in Workbook 1 I have the following string: =VLOOKUP($D$2,'[SBE.XLSM]KPI 2017'!$A$9:$AC$20,COLUMN(B$9:B$19),FALSE) Both filename and sheetname should be a variable based on...
  15. M

    Issue incrementing a variable

    Hi Guys, I am hoping someone can pin point what I am doing wrong here. I am trying to auto generate 31 sheets, each sheet is named numerically from 1-31 My issue is that every 10th sheet gives me a number that is not correct. The sheets end up getting labeled like the following. (sheets...
  16. jim may

    Use of Indirect() to link to outside Workbook cells

    I always have problems with the ""'s in setting up the following link In my cell ref I have: F4 C:\Users\Owner\Documents\ExcelChest\ F20 MySourceWB.xlsx G20 Testing (My Sheetname) H20 A1 (contains text) This is my current attempt, which IS NOT working...
  17. G

    format of sheetname in cell is stopping my formula.

    Hi, In a cell G19 I have the following to get the sheetname: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,20) The format type is General but all the sheetnames will be numbers. This sheetname value is manually entered into column A of a table on another sheet called 'Summary'...
  18. V

    Specific Sheet Names Dropdown in Cell

    I am trying to figure out how to create a dynamic dropdown of specific sheet names in a cell. Once a sheet name is selected, the data on the selected sheet will be used to populate the active worksheet. I would prefer not to use Data Validation. A user may create any number of sheets with...
  19. J

    excel vba - Inserting sheetname into a range of cells

    trying to fill a range of blank cells with the name of the sheet that they are in. not sure why Range("ActiveSheet.Name") does not work? any help appreciated! Dim rng As Range Set rng = Range("B1:B100") For Each cell In rng If cell.Value <> "" Then cell.Offset(0, -1).Value =...
  20. K

    Sheet naming using String Variable

    Hi all, I'm fairly new to VBA and trying to write some basic macros to reduce some drudgery when working with a few of our standard spreadsheets. As part of this I'm trying to create a new sheet which needs to be named based on data in 2 separate cells. The code is pretty basis but I can see...

Watch MrExcel Video

This Week's Hot Topics

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
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 "".
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