populate cells with text from another page
Results 1 to 4 of 4

Thread: populate cells with text from another page
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2017
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default populate cells with text from another page

    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

  2. #2
    Board Regular gallen's Avatar
    Join Date
    Jun 2011
    Location
    Manchester UK
    Posts
    1,880
    Post Thanks / Like
    Mentioned
    21 Post(s)
    Tagged
    1 Thread(s)

    Default Re: populate cells with text from another page

    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?

    - forum use guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


  3. #3
    Board Regular tyija1995's Avatar
    Join Date
    Feb 2019
    Posts
    648
    Post Thanks / Like
    Mentioned
    14 Post(s)
    Tagged
    4 Thread(s)

    Default Re: populate cells with text from another page

    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
    √-1 2³ ∑ π
    …And it was delicious!

  4. #4
    New Member
    Join Date
    Jan 2017
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: populate cells with text from another page

    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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •