The first part of the procedure works fine.
I enter a date in D2 (invoiced from)
I enter a date in D3 (invoiced to) <- at this point it does the update.
the data starts in A7 to T7
I don't need all the data for the report I create so I have a seconf Tab labelled Cleaned.
This basically is = Data!A7 Copied left and right missing out the coloumns I don't want.
All works nice until I change the dates in D2 & D3
If my data was 17 rows long originally and expands to 30 rows the first 16 rows are fine then the forumla in row 17 becomes =Data!#REF!
a similar problem happens when the data gets smaller.
this si currently fixed by copying and repasting the forumals on the cleaned page - But there must be a better way of doing it.
Any help appreciated.
I enter a date in D2 (invoiced from)
I enter a date in D3 (invoiced to) <- at this point it does the update.
the data starts in A7 to T7
I don't need all the data for the report I create so I have a seconf Tab labelled Cleaned.
This basically is = Data!A7 Copied left and right missing out the coloumns I don't want.
All works nice until I change the dates in D2 & D3
If my data was 17 rows long originally and expands to 30 rows the first 16 rows are fine then the forumla in row 17 becomes =Data!#REF!
a similar problem happens when the data gets smaller.
this si currently fixed by copying and repasting the forumals on the cleaned page - But there must be a better way of doing it.
Any help appreciated.