Good morning
Not to sure what you would call what I want done. I have been on Google for awhile, but no luck in finding what I want. Well, I did find you guys.
Your help would be appreciated.
RAW_DATA - WHAT I READ FROM
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
RAW_DATA DISPLAY
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
I have daily data (RAW_DATA - WHAT I READ FROM). When I show my information(RAW_DATA DISPLAY)I only want to show the last day plus 5 days past.
So it shows 2015/05/10 to 2015/05/05
Tomorrow a new day will be added to my raw_data, so now I want to show 2015/05/11 to 2015/05/06
So 2015/05/05 will change to 2015/05/06 and the last date will be 2015/05/11. Each date will move one up.
Formula in 2015/05/05 = Sheet1!A6, so now it must change to =Sheet1!A7
Thanx you
Mirelle
Not to sure what you would call what I want done. I have been on Google for awhile, but no luck in finding what I want. Well, I did find you guys.
Your help would be appreciated.
RAW_DATA - WHAT I READ FROM
Date | Amount | Total |
2015/05/01 | 123 | 1 |
2015/05/02 | 124 | 2 |
2015/05/03 | 125 | 3 |
2015/05/04 | 126 | 4 |
2015/05/05 | 127 | 5 |
2015/05/06 | 128 | 6 |
2015/05/07 | 129 | 7 |
2015/05/08 | 130 | 8 |
2015/05/09 | 131 | 9 |
2015/05/10 | 132 | 10 |
2015/05/11 | 133 | 11 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
RAW_DATA DISPLAY
Date | Faults | No |
2015/05/05 | 127 | 5 |
2015/05/06 | 128 | 6 |
2015/05/07 | 129 | 7 |
2015/05/08 | 130 | 8 |
2015/05/09 | 131 | 9 |
2015/05/10 | 132 | 10 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
I have daily data (RAW_DATA - WHAT I READ FROM). When I show my information(RAW_DATA DISPLAY)I only want to show the last day plus 5 days past.
So it shows 2015/05/10 to 2015/05/05
Tomorrow a new day will be added to my raw_data, so now I want to show 2015/05/11 to 2015/05/06
So 2015/05/05 will change to 2015/05/06 and the last date will be 2015/05/11. Each date will move one up.
Formula in 2015/05/05 = Sheet1!A6, so now it must change to =Sheet1!A7
Thanx you
Mirelle