Excel Table Data Help

Collapse

Recommended Videos

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gerg1234
    BOOM!
    • Jul 2008
    • 2911

    #1

    Excel Table Data Help

    For those of you that are good with excel....
    My boss wants a "Master Log" of Change Orders.

    Spoiler


    So I want multiple logs that look exactly like this on the master sheet. What I'm looking to do is have the table change & automatically update when I change the Job #.

    Anybody know if this is possible?
    Chicago Bears
    Oregon State Beavers
    Portland Trail Blazers
    San Francisco Giants
    Chicago Blackhawks
    MLS: Portland Timbers
    EPL: Liverpool FC
  • p_rushing
    Hall Of Fame
    • Feb 2004
    • 14514

    #2
    You need to have all the data in another tab or connection to database with data. Then you can use a vlookup or similar function to find the row # (I would hide this field) and then put formulas in the rest of the fields to get the right column and row for the matching job

    Sent from my DROID4 using Tapatalk

    Comment

    Working...