seperate sheets

  1. M

    How to reference a data validation answer in a cell in another sheet

    Hi, I am recieving a #VALUE ! error when trying to copy the result of a data validation drop down in another sheet and dont know why. e.g. In sheet 1 I have a a drop down box in a cell (A1) that has recent dates in. On sheet 2 I want the chosen date to show in a cell. I have put the formula...
    • mr_samd
    • Thread
    • #value! error cell referecing dropdown box seperate sheets sheet
    • Replies: 5
    • Forum: Excel Questions
  2. C

    Autopopulation

    I manage projects. I have a Workbook with a master sheet i named details. I want excel to populate a sheet called savings every time i change the project status on the details sheet to Completed. is there anyway to do this?
    • Chaddyb
    • Thread
    • autogenerate details seperate sheets sheet time
    • Replies: 11
    • Forum: Excel Questions
  3. S

    New Sheets for Each Investor

    Hi, My excel sheet "investor listing" has three columns. 1- Investor name 2- Check amount 3- Check date 4- Check #. I want to create a separate tab for each investor with a list of all there checks received to date. Then I want to email to each investor there own sheet. My worksheet has...
  4. BigMoe

    Compile values from columns on different sheets to column on summary sheet without duplicates.

    I have a workbook that tracks stock transactions. There are 53 sheets in the workbook labeled "1" through "53", each one being one week of transactions and each sheet is identical. I have one additional summary sheet that compiles the weekly data into yearly stats. I would like to take the...
    • BigMoe
    • Thread
    • columns compare no duplicates seperate sheets
    • Replies: 0
    • 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