My source data (webi report with live office) is giving me a extra row every month
So for example
Sales revenue for Company ABC:
201401 - $2000
201402 - $2050
201403 - $2075
201404 - $2100
…
I’m picking up this data in a other excel tab with a “If-then-else”
So:
=IF (A1=“Company ABC”; B3; IF(A1=“Company XYZ”; AB3;0))
But when a row is added in the source data something funny happens
The new row is added at the bottom of this range, but the former last row (now the previous last row) is skipped.
so my excel tab looks like this now:
201401 - $2000
201402 - $2050
201403 - $2075
201405 - $2225
(201404 is missing when 201405 is added in my source)
How to prevent this?
Tiny 
(BOB member since 2004-11-10)