Formula to copy data from one cell to another

Hi
I have a worksheet that adds up figures the total ends up in I6. At the end of every month I need the total in I6 to copy to a different cell E2, F2, etc (First month E1, Second Month F1, etc) . I have a formula:

Please Login or Register  to view this content.

=IF(e1<=TODAY(),$I$6,"")

Please Login or Register  to view this content.

The problem with the formula is that when I6 total changes after the end of the month cell E1 total changes I need it to only caculate the figure on that last day of the month and when my total changes in I6 after that date it not add anything more to the total in E1.

I also need the data in E1 to stay in the cell when the next months totals appear in F1.
I have attach a sample

Thanks Angela

Hi

Hi
Sorry I didn't explain myself very well the total in I6 keeps caculating thru out the year I want the total in that cell at the end of each month to copy to E1 at the end of that given month and then as the total in I6 changes the amount in E1 stays the same and at the end of the next month F1 is populated with the new running total.

The actual dates in my spread sheet in Colunm G isnt the info I am tring to gather I just want a snap shot of total of the whole sheet I6 on a given day.
Hope this makes sense

Angela

I only need a formula that takes what is in I6 on a given date and then copies that data to another cell at the end of each month. The dates in column g don't have anything to do with the information I am trying to collect I only need the figure of I6 at the end of a given month. As it is a rolling figure this formula is if I forget to check it at the end of the month it will be there when I check it at a later date.

Angela

Hi All, Please help me guys,

What i need to do is:

I've two sheets(1,2), in sheet1 have values from L11 to L86 and v11 to v86. In sheet2 i wants to max value of V column so i used max formula and i got max value in sheet2 C8, max value of V column change in every 3 secs so after every 3 secs c8 value also change. Suppose at present v11 value is 1000 and it is max value of column v, so acoording to max formula it comes automaticaly in sheet2 c8.. now what i need is: when ever v11 column's max value comes in c8, at the same time i want the value of L11 value in E8, after 3 secs when max value of v column is change and suppose this time max value is in v16 so it will come automatic in c8 because of max formula, so at the same time i want L16 value automaticaly in E8, now guys please suggest me what and how i can do this ? please explain in bit details as i'm novice in excel, i'm using excel 2007 by the way.

Thanks a ton in advance,
regards

Hi sktneer

Yes you are correct on all accounts. E1 F1 G1 will contain heading dates either Jan, Feb, Mar etc etc or 31/01/14, 28/02/14, 31/03/13 it doesn't matter as long as the data from column H:H or (I6)copies on the last day of the month to the correctly dated cell E2, F2 G2 and when we add more data to H:H after that date it doesn't add to the prevous months cell.

Yes E2,F2,G2 will have the latest values.

I hope you can help me with a formula now we have the tricky bit sorted.

Sorry its been such a long drawn out excise to explain my self

Angela

Either use a macro that copy paste value, or use circular reference.

In E2, use

=IF($C$1<E1,$I$6,E2)

and drag across.

So when the condition fails, the cell would just return itself.

Hi skneer

I have had a look and it looks like it is working I will copy your code into place and come back to you but so far it looks like it is going to work


Angela

Originally Posted by jd16

Hi All, Please help me guys,

What i need to do is:

I've two sheets(1,2), in sheet1 have values from L11 to L86 and v11 to v86. In sheet2 i wants to max value of V column so i used max formula and i got max value in sheet2 C8, max value of V column change in every 3 secs so after every 3 secs c8 value also change. Suppose at present v11 value is 1000 and it is max value of column v, so acoording to max formula it comes automaticaly in sheet2 c8.. now what i need is: when ever v11 column's max value comes in c8, at the same time i want the value of L11 value in E8, after 3 secs when max value of v column is change and suppose this time max value is in v16 so it will come automatic in c8 because of max formula, so at the same time i want L16 value automaticaly in E8, now guys please suggest me what and how i can do this ? please explain in bit details as i'm novice in excel, i'm using excel 2007 by the way.

Thanks a ton in advance,
regards

no one giving me reply here

Many thanks to you for lighting sktneet I will do the same for sure.