Results 1 to 5 of 5

When a cell in a selected row is not blank, copy to next blank row an another worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    12-03-2018
    Location
    London, England
    MS-Off Ver
    365
    Posts
    4

    When a cell in a selected row is not blank, copy to next blank row an another worksheet

    OK, where to start, so all this is in one workbook, this workbook has 9 worksheets. I am trying to find a way so that when a range of cells on one worksheet are not blank, ie they contain text, I want to be able to copy that text and a corresponding reference number in a different column, but the same row, over to another work sheet, but it must copy these two datasets to the next blank cells on this workbook.

    So Workbook is called Risks and on worksheet 2 ID of Risk, we are using Col A as the ID Number, Col B is the question and Col F is the one I want to be copying (Well defined), however Col F already has text cells already populated (Where not well defined, what needs to happen?), so I need to ignore these. So lets say Row 10, 12, 14 and 20 are the ones that have text in that I want to copy, as these are the responses, however Row 16 and 18 are left blank as these questions were not answered. I want to copy over the rows with data in Col F, but also the corresponding ID Number in Col A. Will also need to do the same for the new worksheet 3 Newssheet.

    Now paste these details into one of the other worksheets called Risks, the ID Number will go into Col B as the control and the text will go into col C, however it will need to find the next blank cells to populate these two data sets into as a number of risks may already be in there.

    Hope that makes sense

    Thanks for you time

    Andy
    Attached Files Attached Files
    Last edited by Andy6240; 07-26-2019 at 09:33 AM. Reason: Inclusion of workbook

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. If a cell is not blank, copy the row to another worksheet
    By msemotorsports in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-19-2017, 02:03 PM
  2. Copy & Paste to worksheet if cell is not blank - loop
    By taxchick1969 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-17-2017, 12:24 PM
  3. Copy and paste from one worksheet to the first blank cell in another worksheet
    By Andrewstupendo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2016, 03:25 PM
  4. copy output of cell with formula to another worksheet without blank
    By fnbissontbl in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-11-2015, 11:14 AM
  5. Copy valule from one column and then paste only blank cell to other worksheet
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2013, 12:42 PM
  6. [SOLVED] If statement that copies text from a separate worksheet, or if blank, leaves cell blank.
    By barleycorn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2012, 12:30 PM
  7. If cell is not blank, copy row to worksheet.
    By echo313 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2011, 05:51 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1