+ Reply to Thread
Results 1 to 7 of 7

Auto fill up of cells in Excel Workbook 2 with reference from Workbook 1

  1. 10-19-2021, 08:17 PM #1
    UNNI_UNNI
    UNNI_UNNI is offline
    Registered User
    Join Date
    10-04-2020
    Location
    UAE
    MS-Off Ver
    Microsoft: Subscription Product Microsoft 365 Apps for enterprise
    Posts
    25

    Auto fill up of cells in Excel Workbook 2 with reference from Workbook 1

    Excel WB1.PNG
    In this work book 1 , a person MIKE is present in JAN and FEB months as represented by numeric 1 against the respective dates.
    There are alphabets like V,VT and VL represent varied positions of MIKE on different dates.
    My query: Whenever I make entry of alphabets like V,VT and VL in this work book 1, I want it to be automatically reflected with same format colour and wording into Work book 2, in column B and D against the respective dates.

    Excel WB2.PNG
    Work book 2 is attached for the similar reference which I am looking for.

    Can any one help me please? Thank You
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-20-2021, 02:55 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,826

    Re: Auto fill up of cells in Excel Workbook 2 with reference from Workbook 1

    Administrative Note

    Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. Windows 7 is an OS, not your Office version. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 10-22-2021, 05:19 AM #3
    UNNI_UNNI
    UNNI_UNNI is offline
    Registered User
    Join Date
    10-04-2020
    Location
    UAE
    MS-Off Ver
    Microsoft: Subscription Product Microsoft 365 Apps for enterprise
    Posts
    25
    Yes I do.
    But I afraid of is there any confusion with my query as it seems unfortunately no one give any hints here.
    Last edited by AliGW; 10-22-2021 at 05:40 AM. Reason: PLEASE don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  4. 10-22-2021, 05:40 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,826

    Re: Auto fill up of cells in Excel Workbook 2 with reference from Workbook 1

    You haven't, though.

    Windows 7 is an operating system, NOT your version of Office.

    In Excel go to File | Account and report what it says below the MS logo at the top of that page. Thanks.
    Reply With QuoteRegister To Reply
  5. 10-22-2021, 03:49 PM #5
    UNNI_UNNI
    UNNI_UNNI is offline
    Registered User
    Join Date
    10-04-2020
    Location
    UAE
    MS-Off Ver
    Microsoft: Subscription Product Microsoft 365 Apps for enterprise
    Posts
    25
    Quote Originally Posted by AliGW View Post
    You haven't, though.

    Windows 7 is an operating system, NOT your version of Office.

    In Excel go to File | Account and report what it says below the MS logo at the top of that page. Thanks.
    Just below Microsoft Logo:
    Subscription Product
    Microsoft 365 Apps for enterprise

    All updates are managed by system administration for info.
    Is it what you asked me for?
    Thanks
    Thanks.
    Reply With QuoteRegister To Reply
  6. 10-22-2021, 04:29 PM #6
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,826

    Re: Auto fill up of cells in Excel Workbook 2 with reference from Workbook 1

    Put that into your forum profile, please, to replace Windows 7.
    Reply With QuoteRegister To Reply
  7. 10-22-2021, 10:20 PM #7
    UNNI_UNNI
    UNNI_UNNI is offline
    Registered User
    Join Date
    10-04-2020
    Location
    UAE
    MS-Off Ver
    Microsoft: Subscription Product Microsoft 365 Apps for enterprise
    Posts
    25
    Quote Originally Posted by AliGW View Post
    Put that into your forum profile, please, to replace Windows 7.
    Can you please guide me how it can be done?

    Yes I did it now

    Additional Info: The Workbook 1 is on shared Drive. I wish those letters V,VL and VT to be pasted into Workbook 2 cells against respective dates, when ever it added to Workbook 1 cells.

    Thanks
    Last edited by UNNI_UNNI; 10-22-2021 at 11:49 PM. Reason: Additional info
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto-fill from a workbook to another
    By lovell_82 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-07-2017, 04:56 AM
  2. macro to bring up stored workbook, auto save to a new folder, then auto fill
    By Rick23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2014, 06:58 PM
  3. Reference cell Date and populate cells on one workbook from another workbook
    By dgfl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-01-2013, 05:04 AM
  4. [SOLVED] Need excel to auto populate specified cells into another workbook
    By esdynamite in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-24-2013, 11:06 AM
  5. [SOLVED] VBA to copy row in a workbook and auto fill in Master workbook.
    By adriel19pr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-29-2012, 03:51 PM
  6. Auto fill from another workbook
    By rajesh00k in forum Excel General
    Replies: 5
    Last Post: 12-18-2010, 08:41 AM
  7. Excel requires workbook to be open to reference cells?
    By pradhan in forum Excel General
    Replies: 0
    Last Post: 06-05-2010, 11:54 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1