# Update formula by month

#### Joey of LA

##### New Member
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!

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

#### babycody

##### Well-known Member
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.

Replies
0
Views
123
Replies
1
Views
211
Replies
11
Views
324
Replies
3
Views
209
Replies
2
Views
60

1,195,640
Messages
6,010,868
Members
441,571
Latest member
stolenweasel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back