Macro changes vlookup formula. (Should not do so)

[psjpsjpsjpsj]

Good day all!

I have this little problem with a macro I'm using.

In the workbook attached I made an example to make clear what is happening.

Some info:

The user only uses the sheet "Overview" and "Insert_macro".
The user copies a table from a different workbook to the green area in "Insert_macro" every Monday. After clicking the button the macro pastes the table to "Values".
"Calculation" surprisingly calculates the data from "Values" into the graphs which are directly linked to the ones in "Overview".
These are used for presentations etc.

Now, when I run the macro the lookup area in "Calculation", cells B2:D6, changes. However, the area should stay the same because we want to see the last 5 weeks.

Any Ideas how to fix this?

With kind regards,

Psj

[xlnitwit]

Hi,

When you insert new rows, the formulas will adjust to refer to the same actual cells as they were previously looking at and hence the formulas offset by 5 rows. You can fix that by copying the existing values down and then simply pasting the new data in.

Please Login or Register  to view this content.

[psjpsjpsjpsj]

Works great! Thank you