I have a project consisting of a "job sheet" and a "work details" sheet for
each day (jobsheet - Monday, Work Details - Monday etc). I am trying to take
all information from the jobsheet with job code "EOD" in "N6" and put all the
information on the work detail sheet with the job code being in "G14". I
also then need to get the Reg No from "F6" and other work carried out from
the same row, and put this on the work details sheet too with Reg No going in
"E14". It is so long since I have done anything like this, and I have
forgottoen so much. Is this better with formulas in each cell on the Work
Details sheet, or using a Macro? Can anyone please help?