# Save Cell Value from Sheet1 to Sheet2 in its corresponding month

1. ## 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. ## Re: Save Cell Value from Sheet1 to Sheet2 in its corresponding month

Please provide sample file as per the yellow banner above.

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

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

4. ## 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. ## 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. ## Re: Save Cell Value from Sheet1 to Sheet2 in its corresponding month

You said that it worked!!!

7. Originally Posted by jolivanes
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

8. ## 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. ## Re: Save Cell Value from Sheet1 to Sheet2 in its corresponding month

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

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