F
Falah
How do you build a macro that will modify your data range to pick up most
current week data? I have over 50 graphs that are all set up to be updated
each week. The data range that it’s referencing is already populated as it’s
linked to another workbook. Below is what the data range looks like. As the
week passes the #DIV/0! gets updated to a number.
WEEK Data Data 2
P5W3 740 794
P5W4 765 794
P6W1 828 848
P6W2 #DIV/0! 848
P6W3 #DIV/0! 848
P6W4 #DIV/0! 848
current week data? I have over 50 graphs that are all set up to be updated
each week. The data range that it’s referencing is already populated as it’s
linked to another workbook. Below is what the data range looks like. As the
week passes the #DIV/0! gets updated to a number.
WEEK Data Data 2
P5W3 740 794
P5W4 765 794
P6W1 828 848
P6W2 #DIV/0! 848
P6W3 #DIV/0! 848
P6W4 #DIV/0! 848