OilEconomist
Active Member
- Joined
- Dec 26, 2016
- Messages
- 426
- Office Version
- 2019
- Platform
- Windows
Thanks in advance as feedback will be provided.
I have an excel workbook provided by a third party vendor to fit with their accounting software. Why can't I copy data within one sheet of the workbook to the main sheet within the same workbook?
Workbook A is the third party vendor provided Workbook
Sheet A is the only sheet originally in Workbook A
Sheet B is an additional sheet I insert into Workbook A
Workbook A has several complex Macros
I can copy and paste values into Sheet A if the data comes from a sheet outside of Workbook A, but when I insert an additional sheet, Sheet B, into Workbook A and try to copy data from it Sheet B to Sheet A, it won't let me. I've unprotected both sheets - Sheet A and Sheet B, but no luck.
I have an excel workbook provided by a third party vendor to fit with their accounting software. Why can't I copy data within one sheet of the workbook to the main sheet within the same workbook?
Workbook A is the third party vendor provided Workbook
Sheet A is the only sheet originally in Workbook A
Sheet B is an additional sheet I insert into Workbook A
Workbook A has several complex Macros
I can copy and paste values into Sheet A if the data comes from a sheet outside of Workbook A, but when I insert an additional sheet, Sheet B, into Workbook A and try to copy data from it Sheet B to Sheet A, it won't let me. I've unprotected both sheets - Sheet A and Sheet B, but no luck.