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

[Andy6240]

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

[AliGW]

Will you please attach a small sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

[PaulM100]

Welcome to the forum. Upload a sample: Go Advanced - Manage Attachments - Upload file

[Andy6240]

uploaded and thank you

[JeteMc]

Please include some sample data on the "2 ID of Risks" sheet and manually show how you would like formulas to place that data on the "5 Risks" sheet and "3 Newsheet".
Let us know if you have any questions.