+ Reply to Thread
Results 1 to 9 of 9

Save Cell Value from Sheet1 to Sheet2 in its corresponding month

  1. #1
    Registered User
    Join Date
    05-21-2014
    Location
    Saudi Arabia
    MS-Off Ver
    2021
    Posts
    38

    Save Cell Value from Sheet1 to Sheet2 in its corresponding month

    Hi,

    I need to save a Value in AG19 of Sheet1 to Sheet 2 in its related month i.e. B3 February month in this example, either by button click or on cell value changes of AG12 of Sheet1. If Cell Value of AG 12 Changes to March then AG19 Value Should Save in cell B4 ofSheet2.

    Please see the below images for further understanding.

    Thanks!

    Sheet1
    Sheet1.png

    Sheet2
    Sheet2.png

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Save Cell Value from Sheet1 to Sheet2 in its corresponding month

    Please provide sample file as per the yellow banner above.

  3. #3
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Save Cell Value from Sheet1 to Sheet2 in its corresponding month

    try...
    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,566

    Re: Save Cell Value from Sheet1 to Sheet2 in its corresponding month

    Same idea, slightly shorter:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    05-21-2014
    Location
    Saudi Arabia
    MS-Off Ver
    2021
    Posts
    38

    Re: Save Cell Value from Sheet1 to Sheet2 in its corresponding month

    Thank you Croweater and jolivanes, both the solutions works.

    but, I forget to mention that Sheet2 Column A are actually dates like 01-Jan-2020, formatted as "mmm".
    and AG12 formula based and is stored as Date(Year,Month,Day)

    so need a little help again how can this code be tweaked to compare the months???

    Thanks again!

  6. #6
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,566

    Re: Save Cell Value from Sheet1 to Sheet2 in its corresponding month

    You said that it worked!!!

  7. #7
    Registered User
    Join Date
    05-21-2014
    Location
    Saudi Arabia
    MS-Off Ver
    2021
    Posts
    38
    Quote Originally Posted by jolivanes View Post
    You said that it worked!!!
    Yes, but I have to enter values in cells as the dates in both sheet1 cell and sheet2 column A

    In my original workbook, column A has dates and in Sheet1 the cell value is calculated by using formula =date(year, month, day) format.

    So the value you formatted in code as "mmm" is returning nothing...

    Hope I have clearly explained
    Last edited by qadeerahmed; 10-29-2020 at 10:46 AM.

  8. #8
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,566

    Re: Save Cell Value from Sheet1 to Sheet2 in its corresponding month

    Attach your workbook so we don't have to try and recreate one.
    Make sure all personal data is changed to fictional data.
    And don't use the "Reply With Quote" button. Most of us are not demented that far yet that we don't know what we suggested.
    Make a note of the Post # if you really think we need to be reminded which Post you're referring to, or even the name of the poster and post number.

  9. #9
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,566

    Re: Save Cell Value from Sheet1 to Sheet2 in its corresponding month

    Please Login or Register  to view this content.

+ 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] VBA search for 2 cells from Sheet1 on Sheet2 & return another cell from same row to Sheet1
    By Gordon85 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-30-2020, 04:01 PM
  2. Replies: 3
    Last Post: 09-24-2015, 08:20 AM
  3. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  4. [SOLVED] If cell value on Sheet1 not found on Sheet2 copy row to Sheet2
    By Yxx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2013, 04:15 AM
  5. Macro to copy range of cell from sheet1 to sheet2 based on a cell value in sheet2
    By drgwhizz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-25-2012, 10:39 AM
  6. IF Sheet1 Cell A2 = value, THEN copy Sheet1 Row 2 to Sheet2 Row 2....?
    By dan1980 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2009, 10:28 PM
  7. Excel template on sheet1 save to sheet2
    By tsbone in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2007, 08:42 AM

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