If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
Hope you could help, I would like to create a spreadsheet that when a selected number of cells are set to "yes" then a lookup to a small table should then copy 3 columns of text at the side of that table, if the criteria is met with a "1".
If either f2, f3 or F4 = "Yes" then look up A9:c16 and if there is a "1" in respective column then copy all text to the right in columns D, E & F to "result" work sheet.
I am trying to create auto copy of selected data without the use of a filter, by pressing a cell / button
Try this one. I've put a button on cell E6 that will run a macro. Note that the macro writes the results to Results2 rather than result so as not to blow away your example.Task Picker 1.0.xls
__________________
Bob
Tip my scale if my answer helped you.
Hi this is great, and works fine, really appreciate your help.
However could I ask one more favour, as I am trying to adapt your very good code into a more specific document that has many more columns.
I am no expert with VBA, but I did try to edit this so that I could add say 2 more methods i.e Method D & E, but when I added 2 extra columns ater C:C I got lost in the code.
You were using the wrong range for Methods (it is column I not F. Also, you need to watch the row and column indeces in the loops. There offsets were wrong.
Form picker and copy text to another sheet
Linear Mode
