Hello,
I was really hoping someone would be able to help me with a macro for this. I've attempted to review solutions in other forums but my vba knowledge is pretty basic so I'm out of my depth here.
I have a spreadsheet where information is added to a worksheet called 'Data Entry', information is added in cells, C11:C13, C16:C19, C22:C26 and C29:C32 daily. There is a drop down at cell B9 which relates to the names of the different sheets. I was hoping to see if there was a way that when the drop-down option was selected that the data could be copied across with a button to the corresponding sheet?
Any advice would be greatly appreciated.
I was really hoping someone would be able to help me with a macro for this. I've attempted to review solutions in other forums but my vba knowledge is pretty basic so I'm out of my depth here.
I have a spreadsheet where information is added to a worksheet called 'Data Entry', information is added in cells, C11:C13, C16:C19, C22:C26 and C29:C32 daily. There is a drop down at cell B9 which relates to the names of the different sheets. I was hoping to see if there was a way that when the drop-down option was selected that the data could be copied across with a button to the corresponding sheet?
Any advice would be greatly appreciated.