Auto Populating last 6 days data

Travisallen2007

New Member
Joined
Jan 21, 2018
Messages
30
Office Version
  1. 365
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.
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Travisallen2007

New Member
Joined
Jan 21, 2018
Messages
30
Office Version
  1. 365
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,130,303
Messages
5,641,425
Members
417,209
Latest member
Agbarker

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top