S
Schwimms
I have two spreadsheets both with check numbers, one of the spreadsheets has
outstanding checks and the other has checks that are clearing. I would like
to be able to do an import function where if the certain check number is on
the clearing list it deletes the one on the checks that are outstanding. Also
there are a bunch of checks not just one.
So I would like to do a function such as check 218, 219, 230, 235 is
clearing and they are also listed on the checks page those numbers would be
replaced by a 1. and if there is a check that is clearing but doesnt appear
to be on the checks page I would get an error.
If anyone has an idea how to do this and can help me, THANK YOU!
outstanding checks and the other has checks that are clearing. I would like
to be able to do an import function where if the certain check number is on
the clearing list it deletes the one on the checks that are outstanding. Also
there are a bunch of checks not just one.
So I would like to do a function such as check 218, 219, 230, 235 is
clearing and they are also listed on the checks page those numbers would be
replaced by a 1. and if there is a check that is clearing but doesnt appear
to be on the checks page I would get an error.
If anyone has an idea how to do this and can help me, THANK YOU!