this may be far stretch but im wondering how(if) i could create a macro that will do the following,
check cell for contents > copy contents > move to separate sheet > search for condition one (relative to original cell's location) > search for condition two (relative to original cell's contents) > find where x/y intersect and paste.
This to my basic knowledge seems like the most direct way about it I figure i could use a long process of lookup and true/false, but with 645 cells to go through might take awhile to write/go through
Id like a macro that will search each cell in the range E29:S50 on worksheet "Input" and if a cell is occupied it copies that cell moves to worksheet "Dats" then looks down column E to find the corresponding name from "input" worksheet and paste. Looking at the workbook may help make this make sense.
Thanks in advance,