exceldumbass
New Member
- Joined
- Jun 13, 2018
- Messages
- 3
Hoping someone can help...
I have a workbook with individual sheets named January, February, March etc through to December. I have another tab named 'Hive DR'.
In the monthly tabs (January, February etc) I would like to copy Row 15, 26, 36, 40 and 41 from Column D through to AH and paste this data in the 'Hive DR' sheet into Row 10, 11, 12, 13 and 14 from starting in column C through to AG however I would like this based on a Drop Down box which I have created in B7 with each month on the Drop Down list.
For example if B7 shows 'January', Get rows 15, 26, 36, 40 and 41 from Columns D to AH on the 'January' sheet and copy to 'Hive DR' into Rows 10, 11, 12, 13 and 14 from column C to AG.
I hope someone can help with some form of code/formula I can use for this.
My Excel knowledge is not great so any help is really appreciated!
Thanks
I have a workbook with individual sheets named January, February, March etc through to December. I have another tab named 'Hive DR'.
In the monthly tabs (January, February etc) I would like to copy Row 15, 26, 36, 40 and 41 from Column D through to AH and paste this data in the 'Hive DR' sheet into Row 10, 11, 12, 13 and 14 from starting in column C through to AG however I would like this based on a Drop Down box which I have created in B7 with each month on the Drop Down list.
For example if B7 shows 'January', Get rows 15, 26, 36, 40 and 41 from Columns D to AH on the 'January' sheet and copy to 'Hive DR' into Rows 10, 11, 12, 13 and 14 from column C to AG.
I hope someone can help with some form of code/formula I can use for this.
My Excel knowledge is not great so any help is really appreciated!
Thanks