The post cited here is close to what I need for my project but I have not been able to work it out myself: http://="http://www.excelforum.com/e...-project.html". Instead of putting the information to new sheets I would like the macro to copy to one sheet instead. However, I also need it to be done three times; each range in the Database sheet would copy to a range on the Coverage sheet. (I have put the code from this reference in module 12.)
Attached is a mocked file exact to what I am trying to do including the existing macros and formulas running. I have labeled everything and these are some parameters that may help:
1) This is my exact layout and macros
2) The Database sheet must pull information from the Forms List sheet. There are hidden rows providing Indirect data validation dropdowns so the Forms List sheet itself cannot be the database.
3) The Coverage tab currently has the C column merged to H. If this is problematic it does not need to stay that way.
4) The Database, Forms List and DropDown Menus sheets all need to be hidden.
5) On the Coverage sheet I have labeled my choice A, B, and C for preferences on where to run the macro from. Obviously it cannot be from the Database sheet like the example because it needs to be hidden.
6) The Type pull down menu matches the columns on the Database. When a choice is made there are three corresponding columns - one for each range I am trying to copy.
Thanks so much for the help in advance! Again and Again!
Bookmarks