I am currently creating an excel based estimating software and have hit a brick wall.
Two-Fold Problem: My current database format utilizes drop down items under each estimate sub-item. First I want to be able to, once an item is selected, have another line automatically copy and paste the original drop down menu and the corresponding row information and self-insert in the next row with the same drop down list from the previous line. Secondly, as an item is selected I also want to have the selected item copied over to anoth existing worksheet. I am not sure if this needs to be a pivot table or what because there needs to be some logic to where it shows up on the second worksheet. Any and all help would be greatly appreciated. Or if this is just not possible then a slap on the hand for posting this may be needed. --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
