D
DavidH56
Hi,
I would like help locating the Code listed in column B (example of
code.."BG47")from the olddata sheet, copy the date located in column F and
paste it into the currentdata sheet into column J where the same Code from
column B from olddata sheet is found in column B of the currentdata sheet
keeping the same date format. I'd then like to have a formula put into
column K2 to last row showinf the difference in days between column J and F.
Finally I'd like to bold rows on currentdata sheet that have column B data
ends with numbers 50 or 00 and sort ascending 1st by column E dates if it
exists and 2nd by column D which always exists.
Thanks so much in advance.
I would like help locating the Code listed in column B (example of
code.."BG47")from the olddata sheet, copy the date located in column F and
paste it into the currentdata sheet into column J where the same Code from
column B from olddata sheet is found in column B of the currentdata sheet
keeping the same date format. I'd then like to have a formula put into
column K2 to last row showinf the difference in days between column J and F.
Finally I'd like to bold rows on currentdata sheet that have column B data
ends with numbers 50 or 00 and sort ascending 1st by column E dates if it
exists and 2nd by column D which always exists.
Thanks so much in advance.