I am working on worksheet that will show service dates on customer sheet. I want to pull dates from input sheet and place only dates that belong on ea customer.
The following allows me to get the right date to the correct customer.
Sheet1(input sheet) Is set up:
B=Date C=Cust. name
B=2/5/02 C=Avant
Sheet2 cell==if(sheet1!c2="Avant",sheet1!b2,"")
This does get the date over, however it is 2 weeks between some service dates so there is a large gap in sheet 2 colume, can anyone help??
Thanks Dennis
The following allows me to get the right date to the correct customer.
Sheet1(input sheet) Is set up:
B=Date C=Cust. name
B=2/5/02 C=Avant
Sheet2 cell==if(sheet1!c2="Avant",sheet1!b2,"")
This does get the date over, however it is 2 weeks between some service dates so there is a large gap in sheet 2 colume, can anyone help??
Thanks Dennis