Copy journals from another workbook
If you would like to repeat a journal without typing out the codes and values individually you can copy and paste the journal into your journal worksheet.
- Ensure you have enough available rows in the new journal sheet to hold the journals you wish to paste.
- You can add rows by entering a value into a cell close to the bottom of the journal sheet and then deleting it.
- Copy the journal codes and values from the source workbook
- Click into the next available code cell in the new workbook (leaving at least one row between the last journal) and paste the values
- In the CCH Workpaper ribbon> Journals section - click the Refresh Codes button.
- This will re-enter the codes automatically and trigger the formula entry to display the Code descriptions.