Copy values within date range and to replace old values

[M_M_Mischa]

Hello,

I am looking to create a macro that will copy data within tab 'GraphCalc' from column A to C (Except the first two rows).
This data has to be copied to column J to L (again, except the first two rows).
It needs to copy the cells when they are within the range of F3 and F4 (within tab 'GraphCalc').
I know how to copy data within a certain range when it is hardcoded in the macro but not how to set this dynamically.

Before it copies it has to remove all information in column J to L (again, except the first two rows).
As the range noted in cell F3 and F4 comes from the graph tab, I'll put the trigger there (as the GraphCalc sheet will be hidden to the user).

I will initially use this to create multiple dynamic graphs.
After the data is copied, the graph needs to show only the range that is available there.
My idea is to do this via the offset function.

I hope this is clear and that someone can help me.
I am quite stuck on this.

Thank you!

[jindon]

Try

Please Login or Register  to view this content.

[M_M_Mischa]

Hi,

Thank you. That worked like a charm!

Question though, I configured the destination as a table. I know that using that way can be used for creating dynamic graphs. The only thing I see happening is that it also uses the date column as a line.
So it sees it as values, although I've configured it as date. Thereby it is placing (random) values (1, 2, 3,.....) on the x axis - this is where the date should be.
I get a better result by using the offset function and the name manager. Only then it seems that it uses random dates, not the ones I created. The amount of point is correct though. With the side note that when data is removed it stops working correctly.

The only way I found that it picks up the date is if only the cells of value are selected. Therefore I am wonderering how to add to the macro that it selects all available values and creates the graph (and when running again that it removes the graph in question. Assuming there are also other graphs).
Ofcourse I am open for better ways to create a dynamic graph considering the data shown in the first post.