Linking Data Between Sheets

**Miki Lu** · 05-25-2013, 10:24 AM

Hello,

I'm just getting to know Excel. I am trying to create a document that for a school that will allow the director to track potential students. He wants a spread sheet that will allow him to do the following 2 things.

1. On the main spreadsheet if you have a list of every potential student with a a call back date, name, maybe phone or email…when getting close to the follow-up date it turns from yellow to red when due moves to the top of the spreadsheet.

2. When they click on the person’s name on the main spreadsheet have it open a sub spreadsheet with details about the person.

Is it possible to do the second? Would this require a relational database?

**MarvinP** · 05-25-2013, 10:38 AM

Hi Miki,

I think all your requirements are possible using Excel. You will need to learn some VBA and event Macro programming. I didn't say easy but, yes, possible.

**Miki Lu** · 05-25-2013, 11:29 AM

Thanks, that is a helpful starting point. Could you recommend any videos I could watch to learn more about this? I did a search for "VBA videos" and there is no shortage of video help. I'm just not sure what I'm looking for exactly.

**MarvinP** · 05-25-2013, 11:36 AM

Hi,

It seems to me you'd need some Conditional Formatting of the worksheet based on a date field. Then you'd need to sort the sort the worksheet based on due date. Then you'd need some Event VBA Macro to resort the data. There are multiple topics in this problem. I'd suggest you just start using Excel and direct your search to this problem. You can also attach a sample of what you have now and let us see if we can help.

**Miki Lu** · 05-25-2013, 07:12 PM

Thanks! I found a video that helped me out. I couldn't have done it without your response to my questions, it was helpful getting some of the correct Excel vocabulary (i.e. Conditional Formatting)so I could do a more effective search.