Results 1 to 3 of 3

Table autofilling

Threaded View

  1. #1
    Registered User
    Join Date
    11-14-2022
    Location
    Los Angeles, CA
    MS-Off Ver
    365
    Posts
    2

    Table autofilling

    I have a table created with values corresponding to a specific number. In my table, hours and dollar amounts in separate columns are totaled for each work department in descending rows. The specific number refers to the job task where the hours and dollar amounts differ depending on which task is selected. For instance hours/amounts for job task 1 is different than hours/amounts for job task 2.

    I would like to enter the job task number in a single cell and have its corresponding values for hours/dollar amounts autofill into my table. Would anyone have any suggestions? Thank you.
    Last edited by hzlee; 11-14-2022 at 05:48 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Autofilling cells from normative data table based on age and ***
    By blizzardw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2019, 09:14 PM
  2. [SOLVED] Autofilling data from a table??
    By Nickpop in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-20-2019, 11:49 AM
  3. [SOLVED] Issue with my table not autofilling
    By MikeSta4ord in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-20-2015, 07:02 PM
  4. [SOLVED] One formula in a table is not autofilling when inserting a row
    By chrisb84 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-15-2013, 05:14 AM
  5. How to keep formatted table column reference static when autofilling
    By chrisjames25 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-14-2012, 10:23 AM
  6. Formulas not autofilling in 2010 Table
    By Melvinrobb in forum Excel General
    Replies: 5
    Last Post: 07-30-2012, 02:28 PM
  7. Excel 2007 : turn off autofilling of column in 2007 table/list?
    By The Headacher in forum Excel General
    Replies: 2
    Last Post: 01-21-2010, 03:33 AM

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