worksheet reference

  1. R

    reference to Sheet within a workbook is replaced by full file path after emailling the sheet to a colleague

    Good morning everyone Apologies in advance if this is a real beginners error but I just can't figure out why its doing this and its causing quite a problem. Background: I have a master spreadsheet that we use to plan transport based on product lines that have been requested by my customer and...
    • Reshaw
    • Thread
    • email active workbook formula worksheet reference
    • Replies: 0
    • Forum: Excel Questions
  2. M

    VBA - Insert Sumif formula into cell - formula contains references to different worksheets

    I am trying to have vba enter a sumif formula into cell E8 on the sheet named "EOC" Based on the sumif formula (below) here is the information I have: =sumif(range, criteria, sum range) Range: The range for the sumif formula is column AF of a particular sheet. The sheet however will change...
  3. T

    Help with VBA script to create excel reference to a cell in a different worksheet

    I am trying to create a budgeting spreadsheet that contains 26 worksheets that represent 2 week expense cycles. The worksheet will tally all the expenses in its 2 week cycle, compare them to a target budget, and calculate the remaining budget. I would like to roll the remaining budget over to...
  4. K

    Dependent Drop Down Lists Referencing Multiple Worksheets

    This is my first post so I hope to get some good easy feedback. I am making a document for quoting materials and the first worksheet is quoting, all others will be Material Data Sheets. I want to make a drop down list on the first worksheet that can choose from any of the available materials...
    • kreiter
    • Thread
    • dependent drop down lists drop down list worksheet reference
    • Replies: 4
    • Forum: Excel Questions

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