Copy and Paste Help If Not Certain Text

**buddylee375** · 10-20-2009, 10:16 PM

Alright, ive been searching around for a while, but have very limited knowledge of vba and macros so ive come here for whatever help i can get.

On sheet1 have multiple groups of cells with drop down lists all with the default word "None" selected. After the user has gone through and changed some of these menus to other values in the lists, i am looking to copy the text only in the cells that have been changed to certain locations on sheet2. See attached spreadsheet for a better idea. If any additional info is needed, please let me know.

Any suggestions would be appreciated. Thanks.

**D_Rennie** · 10-21-2009, 02:06 AM

Hello,

Where exaclly would you want the cells copied to on sheet2.

there may also be a way of doing this with a formular, if so it would be faster and cleaner. Though i have yet to lean a lot of formulars so if its a formular that you want someone else may help on that.

cheers

**buddylee375** · 10-21-2009, 04:49 PM

I just want the first option that is not "None" to be copied to say cell B4 in Sheet2, then the next option that is not "None" copied to B5, etc...

Thanks

**D_Rennie** · 10-21-2009, 10:15 PM

Hello
Try

Please Login or Register  to view this content.

the only thing i noticed is that if you paste then into the 2nd sheet like this there is no way of telling if it came from option A or B.

Hope this helps

**buddylee375** · 10-21-2009, 11:09 PM

Works beautifully! I can tweak it as needed to get each option segregated if it comes to that.

Thank you for all the help.

**D_Rennie** · 10-22-2009, 12:20 AM

Glad i could help.
IF your are happy with it please.
Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.

Thankyou.