populate cells with text from another page

[Mark24931816]

Good morning, I will try and explain what I am trying to do and am grateful for any help offered

I have two sheets on the same spreadsheet, the first (Front page) a clean sheet showing training compliance percentage that draws from information in rows and columns on the second sheet that is basically a data dump.

What I am trying to achieve is that if any cell in column "Q" is empty, it then copies the text from cells "C" "D" & "K" on that row and transfer it to cells on the first page:

So if a date is missing from column "Q" (Blank) then the first and last name of the staff member from cells "C" & "D" with the name of the training module from cell "K" are copied to the front page to make a list of missing training.

I hope this makes sense to someone

thanks in advance

M

 

[gallen]

Hello,

A little more information is needed.

What you ask is relatively simple via VBA but what would trigger this? A button to generate the "report" on to the front page?

Where on the front page would this information go? What row would it start on? When it is generated does it overwrite the previous details or add them to the end?

 

[tyija1995]

Hey,

You want something like:

=IF(Sheet2!Q1<>"","",Sheet2!C1&" "&Sheet2!D1&" "&Sheet2!K1)

Placed in say, A1 of the front page sheet. Assuming Sheet2 is the data dump sheet - change name accordingly

 

[Mark24931816]

Thank you very much i will have a fiddle with that formula and see how i get on, appreciate your time and input

many thanks

M