+ Reply to Thread
Results 1 to 4 of 4

Autofill, But From a Different Sheet

  1. #1
    Registered User
    Join Date
    09-04-2020
    Location
    United States
    MS-Off Ver
    Office 365 2020
    Posts
    9

    Autofill, But From a Different Sheet

    Hello guys, how's it going?

    I have attached a very simple worksheet that describes what I am trying to do (in reality my worksheet is slightly more advanced).

    Anyway, I have a table for which values are entered from different sheets (basically each sheet is a month from which I enter data into the table).
    The thing is that I can only enter the data manually, and it takes a lot of time.

    *Note, in this attached file, I can simply use auto-fill across rows since all values are located in the same spot - without any interference. In reality (I cannot attach that worksheet), some values are located differently across the various sheets, because each month is slightly different.

    The bottom line, I would like Excel to recognize the 'Names' (Josh, David, Sarah, Judy) so that it can automatically refer to each name and its corresponding value in each sheet - when I use auto-fill. Does it make sense?

    Thank you!!
    Attached Files Attached Files

  2. #2
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: Autofill, But From a Different Sheet

    worksheet name : sheet1
    Cell C3 formula , Drag down and across

    HTML Code: 

  3. #3
    Registered User
    Join Date
    09-04-2020
    Location
    United States
    MS-Off Ver
    Office 365 2020
    Posts
    9

    Re: Autofill, But From a Different Sheet

    Quote Originally Posted by wk9128 View Post
    worksheet name : sheet1
    Cell C3 formula , Drag down and across

    HTML Code: 
    Wow, thank you! Could you elaborate on this formula? How does it work?

  4. #4
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: Autofill, But From a Different Sheet

    @Danielllmzmz You're Welcome. Glad to help . Thank You for the feedback

    USE THE MOUSE Left-click to select a partial area of the formula and press F9 on the keyboard to observe the LOGIC result
    Last edited by wk9128; 09-16-2021 at 10:21 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Autofill next blank row on 2nd sheet based on data in the 1st sheet
    By RIZVI in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-07-2020, 05:17 AM
  2. Replies: 2
    Last Post: 02-17-2017, 07:46 PM
  3. Replies: 11
    Last Post: 06-03-2016, 03:16 PM
  4. Autofill base on Active Cell and Autofill by row count of another sheet
    By enyak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2014, 10:06 PM
  5. Replies: 0
    Last Post: 07-18-2012, 05:22 PM
  6. Can't autofill data in workbook from sheet to sheet
    By sn.henderson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-18-2010, 01:01 PM
  7. Replies: 0
    Last Post: 03-02-2005, 12:06 PM

Tags for this Thread

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