cross-referencing

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...

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...

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...

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...

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...