I've been looking in various forums to help with this however there isn't anything exactly what I need.
I have a report that I need users to enter information into, cells b3:f3. once all the data is added I need them to click a button to add that information to a report that is contained on the dame sheet. The tricky part is I need the macro to copy b3:f3 and paste it into the next empty row, however it needs to be within a range depending on what "Typ" is entered. In the example book attached, if the type selected was "General" I want the data to be copied and pasted into the "General" or rows 8:17. If the type is Specialist then it needs to be copied to the Specialist section or rows 20:29.
I am trying to update a report that was created by someone else however they are no longer contactable and the book they created where this macro works is password protected so I cannot view their code to see how it was done.
Thanks for any help, and please contact me if you need more of a description of what I am trying to achieve.
Bookmarks