variable worksheet name

  1. I

    Active Sheet name as variable and looping to next sheet

    Ok... The code works fine on one sheet, but I can't get it to move to the next worksheet and continue carrying out the code. What the code does is start on a worksheet after a known worksheet name (EvaluationData). On all sheets after EvaluationData, the code loops down through cells starting...
  2. C

    Posting to next available of variable worksheet

    Hello I've got code which creates a new worksheet with the name of your choice (an employee's name) with a view to creating a staff database with individual records. The next stage of the process is to input all their details. At the moment, these details are inputted on to the next available...
  3. G

    Vlookup on a table with Multiple Worksheet references

    I have a question dealing with a variable column and cell reference I’m using. To make it simple here’s what I have done. On the FRUIT tab I have the following table in location BU132 – BV161 Name Column Apples A Pears B Corn ‘VEGGIE’!A Peas ‘VEGGIE’!B I’m using the following...
  4. L

    Referencing Variable Worksheet names in chart source data

    Forgive me if I am wrong but I cannot find the answer to my question on other threads so I am going to ask. Background Info: Using - Excel 2007 through windows xp I am accessing a SQL server to retrieve a table of data. I am then using a macro to open a userform in which the user inputs data...

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 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
Top