single cell reference

  1. E

    Pulling two pieces of info from table into one cell

    Hello All, Is it possible to enter two pieces of text information into a cell and have it calculate an answer? For example, I'm trying to make it so an employee can simply punch in a code word for a "job" and have it compile the total time in an adjacent cell. The problem is that I need the...
  2. E

    Autofilter with multiple criterias from a single cell

    Hi, I have a spreadsheet that that I am trying to run a macro that does an Autofilter on a range Sheets("Criteria").Range("A1:L2"). Here is the VBA code that does the autofilter: Sheets("Source").Range("A1:L108784").AdvancedFilter Action:=xlFilterCopy, _...
    • Ernest_PLM
    • Thread
    • autofilter criteria multiple criteras single cell reference
    • Replies: 0
    • Forum: Excel Questions
  3. M

    Referencing a single cell in a named range across several sheets in a formula

    Hello, I am a beginner to excel who is learning everything from bottom up for a project! I need help building a formula that will sum a specific cell in a named range across several sheets. This cell will be in a constant column, but will be changing row locations depending on where it is...

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