1 Attachment(s)
Transferring selected cells to a new sheet
Hi,
I have attached a Excel workbook and I need help!
in first tab 'Primary Data' last column is 'Vulnerabilities Found' where some of the rows show 'Yes'. What I need is to move corresponding values from 'Test Area' and 'CO Number' to move to the next sheet which is 'Vulnerabilities', not the whole row but just these two fields. Rest of the fields will be filled out manually based on a different report.
Similarly, from Vulnerabilities Column O is 'Status' which displays 'In remediation' and 'Exception requested'. From this columns 'Exception requested' goes to sheet 'Exception' and 'In remediation' goes to sheet 'Remidiation'. Again just the two fields 'Test Area' and 'CO Number'. Rest of the fields are filled manually.
I tried using formulas but it is copying over a whole lot than what is needed, can VBA do this?
How do I do that? I appreciate any help!
Thank you.