There are times when you may want to work with CaseWare trial balance data in Excel. To do so is actually quite simple.
- Open the Working Trial Balance in CaseWare
- Open Excel to a blank worksheet
- Using the mouse, click and drag to select the data you want to copy. You can also hit CTRL + A to select everything.
- Goto: Edit -> Copy OR hit CTRL + C to copy the data
- In Excel, hit CTRL + V to paste the data
BONUS: Use the VLOOKUP function in Excel to incorporate the data into an analysis without using CaseWare Connector.