I hope this isn't on the forum already but here goes.
I have created a calender. For each day I have 5 available cells. Also part of the workbook is a form that I will input jobs that are bidding and the date that they are bidding.
What I need to do is check the column with the date that the job is bidding with the date on the calender and if it is a match put the name of the job bidding into the cell. Then skip down one cell and do the same, going up to 5 cells worth of information.
Is there a way to do this?
Thanks you for any and all help in advance!!!! and I hope I explained what I'm trying to do well enough to work something out.
I have created a calender. For each day I have 5 available cells. Also part of the workbook is a form that I will input jobs that are bidding and the date that they are bidding.
What I need to do is check the column with the date that the job is bidding with the date on the calender and if it is a match put the name of the job bidding into the cell. Then skip down one cell and do the same, going up to 5 cells worth of information.
Is there a way to do this?
Thanks you for any and all help in advance!!!! and I hope I explained what I'm trying to do well enough to work something out.
