multiple tabs

  1. kyaba

    VLookups across tabs in the same worksheet

    Hi I am a newbie to Mr.Excel and have a question about VLookups across tabs in the same worksheet. I am trying to do the following: • Look up values in a data dump and pull values by unique identifier to populate cells in another tab. • There can be multiple values for the same unique...
  2. D

    Creating multiple hyperlinks at once

    I have a spreadsheet where each tab is a department and on each sheet, there is a list of employees and their salary histories. On the first tab, I need a list of every employees name. When you click on a particular name, it goes to that employees name on the appropriate tab. I know that I...
  3. Talon52

    Comparison Problem with Averages

    I am trying to come up with a spreadsheet that has 1 page of sales from 6/18/07-8/16/07 (43 days), with 3 rows beneath each column: Row 45=Total (=Sum(b2:b44)), Row 46=Average (=Average(b2:b44)), and Row 47=Average + 10% (=Sum(b46+(b46*.1))). The next page has a daily input from 6/16/08-8/15/08...

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