Hi all, I have a worksheet that contains a column of 8 dropdown lists (combo- boxes) from a range in a different sheet. I have the (numerical) results of each selection set up to display in a hidden column. In another cell, I used the COUNTIF function to count the results of all selections >0 (0=no selection).
What I need to do is, based on that count, use a command button to activate another sheet in the same workbook, select a range of cells, then copy + paste into yet another sheet. Basically: if Cell C39=4, then Activate Sheet3 Select range A1:M7 Copy range Activate Sheet2 Paste range into Sheet2, starting at cell A7. --OR-- if Cell C39=5, then Activate Sheet3 Select range A9:N15 Copy range Activate Sheet2 Paste range into Sheet2, starting at cell A7. etc, etc, when C39 = 6, 7, or 8 I know it's all pretty much there, but I don't know the VB language. I would really appreciate some help! Thank you in advance! April PS, does anyone know how to lock the contents of an entire sheet once that command button has been pressed? thanks! --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
