Update formula by month

[Joey of LA]

Hello,

I am having difficulties trying to figure out how to solve this problem.

I have 2 worksheets, sheet 1, sheet 2.

In Sheet 1 I have information that gets updated on a monthly basis, so all info pertains to only a month at a time. On Sheet 2 I am currently updating certain cells manually from Sheet 1 to accumulate data from each month.

Is there a formula or function that would allow me to enter info into Sheet 1 and have it automatically update to Sheet 2, even if I update with new month info into Sheet 1? So, for example,

If Sheet 1 says:
Row ColumnA
1 October 2005
2 $10.00

And Sheet 2 says:
Row ColumnA Column B Column C
1 October 2005 November 2005 Dec 2005
2 $10.00 xx xx

When I get to November and enter info into Sheet 1, is there a formula that would leave my $10 for October in Sheet 2 but update the info I enter for November from Sheet 1 to Sheet 2?

So Sheet 1 to say:
Row ColumnA
1 November 2005
2 $20.00
And Sheet 2 to say:
Row ColumnA Column B Column C
1 October 2005 November 2005 Dec 2005
2 $10.00 $20.00 xx

I'm sorry if I'm not explaining this correctly. I hope you can help!

 

[babycody]

If you plan on using Sheet1 A1 and A2 everytime then no. However you could do this using VBA. You should change the topic name of this post to include VBA. There are some very talented coders on this forum. Getting the value from Sheet1 A2 and matching the month from A1 to a month on Sheet2 row1 then using offset to move down one row and paste value should be a cake walk for them. I know this isn't impossible, but I am a novice coder.