Auto Populating last 6 days data

[Travisallen2007]

Hello, wanted to see if I could get some help with setting something up.

I am needing to track $s used from cell J50 and track that for the last 6 days. I want it to move automatically into a chart starting at A28:F28. This form is cleared and refreshed every day by using a Clear all macro and can move the number in the macro BUT i don't know how to get it to move to the next box every day instead of writing over it and then go back to the start at the end. Any help would be awesome! Thanks Might have to do an if that auto populates it saying go in A28 if data there move down the list until reaching F28 and if full overwrite data and go back through?

This is going to be in Excel 2003 ultimately.

 

[Travisallen2007]

Hello, wanted to see if I could get some help with setting something up.

I am needing to track $s used from cell J50 and track that for the last 6 days. I want it to move automatically into a chart starting at A28:F28. This form is cleared and refreshed every day by using a Clear all macro and can move the number in the macro BUT i don't know how to get it to move to the next box every day instead of writing over it and then go back to the start at the end. Any help would be awesome! Thanks Might have to do an if that auto populates it saying go in A28 if data there move down the list until reaching F28 and if full overwrite data and go back through?

This is going to be in Excel 2003 ultimately.

Ok, I decided to go in another direction and not sure how to edit the post.

So I Decided to do a DATA tab that is sorted by date. The dates on the "Tab 1" sheet automatically updated. I would like to have the data automatically move from cell j37 to the correct date as defined in J3 on "Tab 1" in the "Data" Sheet by date (Date is in A column, Amount would be in b Column)