Hi,
I have an index which contains data such as ID number, last survey, next survey due, days left till next survey.
I want a separate monthly report tab to auto populate the ID numbers based on how long is left till the expiry date.
The monthly report tab is already set up to pull specific data from the index based on the IDs, I just need a way for the correct ID number to automatically populate the right column.
Thanks
I have an index which contains data such as ID number, last survey, next survey due, days left till next survey.
I want a separate monthly report tab to auto populate the ID numbers based on how long is left till the expiry date.
The monthly report tab is already set up to pull specific data from the index based on the IDs, I just need a way for the correct ID number to automatically populate the right column.
Thanks