Joey of LA
New Member
- Joined
- Nov 8, 2005
- Messages
- 1
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!
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!