Excel Macro Creation
Budget: £20 – £250 GBP
Excel macro needed to copy named ranges from 1 sheet and paste them into another sheet - will need a user selection interface so basic macro process would be as follows:
1. user runs macro by selecting Ctrl+Shft+I or similar
2. message box pops up asking user which named range they would like to insert (if this could be drop down selection it would be good)
3. macro then copies that named range and pastes it into the next available roww in the sheet where the user is working
Sample doc attached with main sheet and then sheet of named ranges (there would be 50+ named ranges to select from on the actual document and would want to be easily able to add them to the selection process)
1. user runs macro by selecting Ctrl+Shft+I or similar
2. message box pops up asking user which named range they would like to insert (if this could be drop down selection it would be good)
3. macro then copies that named range and pastes it into the next available roww in the sheet where the user is working
Sample doc attached with main sheet and then sheet of named ranges (there would be 50+ named ranges to select from on the actual document and would want to be easily able to add them to the selection process)