do i need an if statment or a lookup or other

[raymandust]

Hi this is my first excel post so I’ll try hard to explain what it I’
after

I have 4 sheets that are updated every day with data; I would like t
create a summary once a week of specific data to let me know wha
going.

Example in column f7 if there ia letter and there a 7 possible for a t
j then take tha letter and any data across from it and display on
different page in a summary.

I’m working with sort codes and names and projects numbers across th
screen, with a calendar with up to 7 letter representing an actio
(late, finished, early, bad sample ”L”, “E”,”,,”F”) so if on Dec th
09/12 I update and there is an “F “ in cell d7 then take this and al
data relating to this across the screen i.e. the scientist who did th
testing, the sort code how many samples and so on but only if there i
a value “A” in the target cell if there is nothing then don’t update,
this up date would speed thing up for me a lot so any suggestion o
pointer in excel would be great


I’ve tried if statements but you can on use 7 in a row and I need mor
than that o what else can I us