Excel Magic Trick 571: VLOOKUP To Create Form from Access Linked Data Import

[dominorox121]

Um do you think you could help me with this project?

USE EXCEL TO CREATE A PHONE TRACKING SYSTEM LIKE THE FBI. yoU TYPE IN A PHONE NUMBER OR NAME AND THE EXCEL SHEET COMES UP WITH THE STATE, CITY, AND ADDRESS.

your help would be much appreciated

[thekojzareks]

Once you create the form, is there a way to print off an individual form for each unique Record? For instance, say you want to print out individual reports for each Student ID, but don't want to go through the monotonous task of changing each one and printing them individually.

[ExcelIsFun]

I do not know. Try THE best Excel question site:

mrexcel[dot]com/forum

If you ask a clear question, you will get an answer.

[krn14242]

rtviews, Check out Windows Live. You can create documents online and everyone can share and make updates.

[rtviews]

Thanks for the tutorial. 2 questions. Do you have tutorials in statistical analysis and do you know whether it's possible to create an online database (with thousands of rows and columns, using access or excel) that allows multiple users to modify data. Google has something like that but it's quite limited. Access seems robust enough but not sure whether that's possible. Sorry if these are beyond the scope of your tutorials.

[ExcelIsFun]

I have 150 stats videos. Search for 'excelisfun', then go to the excelisfun channel, then watch the video that automatically plays. In that video it shows how to find Playlists. The 5th playlist has all the stats videos. As for your Access question, I do not know how to do that.

[Prashant123channel]

first