My existing file has a macro that puts all the necessary numbers and data into a table. To easier create a chart that is linked to these data, I split the existing table into different tables. Every week, I have to make an update with new data. Thus, each line from the existing line has to be split into one of my new tables. How would the macro look like? Additionaly, the macro should cancel the oldest data from my tables, as I do not want the chart to show more than ten weeks. My chart is linked to the fields C4:H10. Thus the macro should for example delete field C4:H4 and then move the lines up that the new data would be set into C10:H10.