Hi,
I'm hoping some of you excel experts can help me with something I'm trying to do. I have one master sheet that contains several named ranges of information (I don't have to use a name), and I need sheet two to paste different ranges depending on what option the user chooses on the sheet two. For example, if the user uses a command like Ctrl Shift A, range 1 will paste, if Ctrl Shift B, range 2 will paste, etc. Then I need each control to delete anything under the range it posts until it hits the next row that contains certain test (Title Two for example). There will be several Title rows that have different range options under it.
Title Row 1
options for ranges 1-3
Title Row 2
options for ranges 4-6
Title Row 3
options for ranges 7-10
I greatly appreciate any suggestions or help you can offer.
Thanks!
I'm hoping some of you excel experts can help me with something I'm trying to do. I have one master sheet that contains several named ranges of information (I don't have to use a name), and I need sheet two to paste different ranges depending on what option the user chooses on the sheet two. For example, if the user uses a command like Ctrl Shift A, range 1 will paste, if Ctrl Shift B, range 2 will paste, etc. Then I need each control to delete anything under the range it posts until it hits the next row that contains certain test (Title Two for example). There will be several Title rows that have different range options under it.
Title Row 1
options for ranges 1-3
Title Row 2
options for ranges 4-6
Title Row 3
options for ranges 7-10
I greatly appreciate any suggestions or help you can offer.
Thanks!