W
Wendy
Hi
I have a list of data Account No, payment date, arrears on sheet 1.
I have been asked to provide the data in date ranges dependant on age of
debt:
I've created a new sheet and put in today () in cell a3
and added 30 days, 60days, and 90days in B3, C3 and D3, but I can't think of
how to move the data over to a new sheet just for accounts upto 30days old,
with the other ranges going on to other sheets.
My idea was to use some type of move command based on if (sheet1.paydate)
Can anyone help please?
Thanks
Wendy
I have a list of data Account No, payment date, arrears on sheet 1.
I have been asked to provide the data in date ranges dependant on age of
debt:
I've created a new sheet and put in today () in cell a3
and added 30 days, 60days, and 90days in B3, C3 and D3, but I can't think of
how to move the data over to a new sheet just for accounts upto 30days old,
with the other ranges going on to other sheets.
My idea was to use some type of move command based on if (sheet1.paydate)
contents of sheet1 to 30daysheetA3 and <B3 then move (this is where I get really stuck) the matching
Can anyone help please?
Thanks
Wendy