+ Reply to Thread
Results 1 to 3 of 3

Populating additional sheets with data from sheet 1 depending on info in cell

  1. #1
    Registered User
    Join Date
    11-30-2012
    Location
    Gillette, Wyoming
    MS-Off Ver
    Excel 2003
    Posts
    1

    Populating additional sheets with data from sheet 1 depending on info in cell

    Hello,
    I am very new at this and would appreciate any help or tips given. I have a workbook with 8 sheets, the first being "Schedule"
    Based on the info input into a particular cell on this sheet, I want to paste that info into the appropriate sheet, ie: if the columns are, date, name, address,
    job, description, ...... and the sheets are : schedule, monthly totals, insulation, siding, garage doors, gutter, windows, countertops. when info is entered in the jobs column on "schedule"
    (insulation, siding, garage doors, etc) I want the whole row to populate the appropriate cells on the appropriate sheet, I have enclosed a copy of the workbook
    Thanks for any help
    kd1950
    Attached Files Attached Files
    Last edited by kd1950; 12-01-2012 at 05:40 PM. Reason: add sample

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,551

    Re: Populating additional sheets with data from sheet 1 depending on info in cell

    I would suggest using an Access database for this if you have Access.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Populating additional sheets with data from sheet 1 depending on info in cell

    It might help to better illustrate what you want is you had more data added, and a few (manual?) examples of what you're expected outcome is, as well as how you arrived at them?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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