+ Reply to Thread
Results 1 to 3 of 3

Can't autofill data in workbook from sheet to sheet

  1. #1
    Registered User
    Join Date
    09-20-2010
    Location
    dayton,oh
    MS-Off Ver
    Excel 2007
    Posts
    4

    Can't autofill data in workbook from sheet to sheet

    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.
    Attached Files Attached Files
    Last edited by sn.henderson; 10-18-2010 at 12:32 PM. Reason: bad title

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    re: Autofill data from other sheet

    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
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    09-20-2010
    Location
    dayton,oh
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Can't autofill data in workbook from sheet to sheet

    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?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1