cross-referencing

  1. W

    Cross-referencing to populate cells

    I have a spreadsheet with 4 tabs (1 for each three month period). Column A is a list of employees which populates the drop box in the userform. Across row 5 is a list of the dates for each day of the three month quarter. When someone clicks on the submit button in the userform, I need it to...
  2. L

    Linking Excel Workbooks, #REF problem

    So I've linked two separate workbooks, let's call them each work book: WB-A and WB-B and they are each contained within one folder. "WB-A" feeds "WB-B" which does a calculation based on the inputs in "WB-A". Then "WB-B" outputs it's calculations back into "WB-A". I've simply linked the cells...
  3. D

    Cross referencing data- HELP!

    I'm conducting a report, where I have a list of registered students (over 10,000) with their student numbers and date of births. I have been given another list (of 6,000 students who all hold a certain type of card). I need to check that out of the 6000 students, that they are still registered...
  4. C

    Building large cross-referenced lists in Excel: Pivot Table, or simpler solution?

    Hi All, I'm back in an office job after a couple year's absence and am pretty new to the advanced features of MS Excel. I'm using Excel 2010 and want to do the following: Build a contact list of construction companies and all the projects they are working on; then, Be able to take that data...
  5. C

    Budget/Financial Workbook

    I have very limitted use of Excel, but need to create a workbook that tracks $ due to our company based on visits completed. For example, pt # 1 comes in for Visit 1 ($2300.00), Visit 2 ($1600.00), and Visit 3 ($1000.00). On Sheet 1 I want to track the Visits by placing an X in the box meaning...

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