Form picker and copy text to another sheet
Hi Guys,
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
I have added an example, hope this makes sense.
Many thanks as always.
Last edited by junada0; 02-08-2010 at 01:18 PM.
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. Mark the thread as [SOLVED] if it has been.
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.
Enclosed version 3.xls to see my errors..
Appreciate any help
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.
Task Picker 3.0.xls
Bob
Tip my scale if my answer helped you. Mark the thread as [SOLVED] if it has been.
Silly mistake on my part, many thanks for this, will mark as solved.
Cheers
Posting Permissions
Reply With Quote
Bookmarks