Can't autofill data in workbook from sheet to sheet

**sn.henderson** · 10-18-2010, 11:14 AM

All,
I tried to attach a copy of what I'm working with but since I'm at work( military base) I doubt it will let me so if you see a red x let me know and we will try something else. I'm working with excel 07 as well.

You may or may not be able to see but, I have a workbook with 3 sheets (sheet 1 is HCR database, sheet 2 is recalls and sheet 3 is appts). The first 5 colums on each sheet are the same, social, rank, name, unit, phone number, all info starts in cell 2 of each row.
I constantly add this info to these sheets as people come and go from the program. I would like to know how and if, when I make a new row to add another person on sheet one since it is the main database protion of the workbook, can it automatically create a row(s)and add the info into the other 2 worksheets. I have tried to create a row and use vlookup but that wasnt working and i still have to go to each sheet and add a row and type in the formula. I also tried an IF and a few other solutions that others had for their problems and just tried to taylor it to mine but with no luck.
Hopefully you can view what I sent attached but if not then I dont know how to attach it so that you guys can view it. I believe its our base firewall that might be preventing it from attaching.

**royUK** · 10-18-2010, 11:20 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

EDITED THIS TIME

**sn.henderson** · 10-18-2010, 01:01 PM

or could i do something like, when i go to the second sheet(recalls), create a row where i need it since the names are in alphabetical order, type in the SSN of the individual i just entered into the database on sheet 1 and have it auto populate the information associated with that SSN?