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
Bookmarks