HELP€¦Would welcome help from experience formula users. Im attempting to
raise a list of orders required, dependent on data from primary worksheet.
Info follows:
(BOOK 1) Row 1 is headers - Col A: Site Ref, Col B: Site Id, Col C:
Project, Col D: Date, then a list of 50 client names, currently comprised of
3 merged cells each. That's because each Client has 3 columns of info, (eg
EFG, HIJ, etc). The client name in Row 1 is located in the centre cell of
each merged range (eg F1).
What I'd like to do is find all instances of the letter A in row 2 (there
could be between 1 and 7 instances) and return the name of the client into
columns D2:J2 in a separate sheet called Projects in a workbook called PO
Summary. Each result will go into the next consecutive column, that is, the
next available in the range D2:J2 which doesnt already have a client name in
it.
Ive copied the data A1:D99 from the primary worksheet into the Projects
worksheet, so if the above is achievable, Ill run the formulas down the page
and this will give me a list of client orders required for each project.