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