dissonance
New Member
- Joined
- Aug 2, 2018
- Messages
- 3
I have a workbook which contains worksheets that are sent out to employees for input.
Each worksheet has an area of selected cells (B3:B5) which reference the name, department, and cost centre from a summary page.
In previous versions of Excel, I could group all of the employee worksheets, copy the cells and then use paste-special-values to hardcode over the same cells (before splitting the worksheets out using VBA).
For some unknown reason, in Excel 2016, the paste function for grouped worksheets is not working - the option to paste does not appear or is greyed out.
I'm now looking for a VBA script that will, for a selection of sheets, copy cells B3:B6 and paste-special-values into the same cells.
I need a selection of sheets only because there are multiple other sheets in the workbook that contain pivot tables in B3:B5.
Thanks in advance!
Each worksheet has an area of selected cells (B3:B5) which reference the name, department, and cost centre from a summary page.
In previous versions of Excel, I could group all of the employee worksheets, copy the cells and then use paste-special-values to hardcode over the same cells (before splitting the worksheets out using VBA).
For some unknown reason, in Excel 2016, the paste function for grouped worksheets is not working - the option to paste does not appear or is greyed out.
I'm now looking for a VBA script that will, for a selection of sheets, copy cells B3:B6 and paste-special-values into the same cells.
I need a selection of sheets only because there are multiple other sheets in the workbook that contain pivot tables in B3:B5.
Thanks in advance!