Creates renewal list based on values.

[G920]

Hi,

I have been racking my brain to figure a way to do this - and any advice would be greatly appreciated.

Basically I have a spreadsheet of client accounts - The accounts have various lengths: 1 year, 2 year & 3 year. Currently I am working on 2018 accounts, and I would like to copy data from '2018 Spreadsheet' to '2019 Spreadsheet' based on the expiry date as follows:

IF (END DATE = 2019, COPY COLUMN B : COLUMN C) & COPY END DATE + 1 (To create the new 2019 start date)

I have tried to use VLOOKUP however when the expiry date is not 2019, the rows remains blank.

Kind regards
Greg