+ Reply to Thread
Results 1 to 4 of 4

Date Calculations and transfer of the VALUES between Sheets

  1. #1
    Forum Contributor sorensjp's Avatar
    Join Date
    12-23-2015
    Location
    Yokosuka, JP
    MS-Off Ver
    2007 and 2016
    Posts
    196

    Date Calculations and transfer of the VALUES between Sheets

    Hello All,

    I'm trying to transfer calculated data between sheets (WEAPS_QUALS) in cell L28 and (ACT_MBR) Sheet Column BS4:BS500.

    I want the data in the Calculated cell L28 or L30 to be transferred to the corresponding cell on the ACT_MBR Sheet. Shall cells L28 or L30 cell contain the formula or the formulas be on the data sheet (ACT_MBR)?

    The Attached file contains the formula for the respective row. The First Method: with row 28 reflects the calculation from the ACT_MBR cell with the formula. The Second Method: Row 30 holds the formula in Cell L30 which then transfers the VALUE to ACT_MBR Sheet. It seems as the on sheet formula does not update the ACT_MBR sheet when in make a cell change. Would this method best be solved by a MACRO to facilitate he change?

    Which method should be used/changed to best assure proper transfer of data. As I will be creating a filterable Report Sheet to include the Data and VALUES for all members.

    I hope my request is clear and Thank you for reading my request.

    V/r,
    Jim
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Date Calculations and transfer of the VALUES between Sheets

    If I understand what you are asking then it would seem better to keep the =IF(BN4="","",MIN(MAX(EDATE... formula in column BS of the ACT_MBR sheet and use the following in L28 on the WEAPS_QUALS sheet:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    The formula for L30 could be: =INDEX(ACT_MBR!BY$4:BY$500,MATCH(K$3,ACT_MBR!A$4:A$500,0))
    Let us know if you have any questions, or if I have misunderstood the question.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Contributor sorensjp's Avatar
    Join Date
    12-23-2015
    Location
    Yokosuka, JP
    MS-Off Ver
    2007 and 2016
    Posts
    196

    Re: Date Calculations and transfer of the VALUES between Sheets

    JeteMc,

    Thank you for you inputs on this project. I think your method does what I need in this part of the project. My next step in this process is migrating that data to another sheet for a full filterable report (using advanced filters of course).
    As I move forward I will open another thread to when I get to that part.

    Again Thank you for your taking a look and helping. Being in the US Navy here in Japan doesn't afford a me lot of time. I've already asked about how to best structure this project here: https://www.excelforum.com/excel-gen...iple-tabs.html

    V/r,
    Jim
    Last edited by AliGW; 04-19-2019 at 05:15 AM.

  4. #4
    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
    79,343

    Re: Date Calculations and transfer of the VALUES between Sheets

    Please mark this thread as solved to avoid duplication of input. Thanks.

    The whole discussion is best continued here: https://www.excelforum.com/excel-gen...iple-tabs.html

    Please stick to that thread from now on.
    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 to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Transfer all values in next sheets and sort
    By angelosison00 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-22-2018, 05:12 AM
  2. [SOLVED] Match Criteria on Two Sheets and Transfer Values
    By trevor2524 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2014, 08:15 AM
  3. [SOLVED] Need Help..Match A Cell Values and Transfer to Different Sheets
    By trevor2524 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2014, 03:20 PM
  4. Change some values & transfer the data to other sheets
    By RobinPrice in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-10-2014, 07:50 AM
  5. [SOLVED] Transfer Values to Other Sheets
    By basketball2524 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-20-2013, 01:16 PM
  6. Divide Single Row Date Values In Two Rows & Transfer Values
    By kopapa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2013, 03:38 PM
  7. Transfer data between sheets and by date
    By timmy1254 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-11-2011, 06:48 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1