GL journal entry template – additional rows
tracy jo dance asked 6 years ago
The GL journal entry template only contains 10 rows and accountants rarely have journal entries that are limited to 10 debits and credits.� What is the easiest way to expand this template to accommodate a JE for 800 to 1000 rows of data?
Answers
Patrick Roth Staff answered 6 years ago
Tracy,
Well, you don’t have to pre-expand the lines, you can just enter them one by one and the VBA code will auto-expand the number of rows for you.
However if you need to see 1000 rows of data before you enter them there is a Number of Rows on the SmartConnect tab – just set that to what you want it to be and it’ll set it for you.
Well, you don’t have to pre-expand the lines, you can just enter them one by one and the VBA code will auto-expand the number of rows for you.
However if you need to see 1000 rows of data before you enter them there is a Number of Rows on the SmartConnect tab – just set that to what you want it to be and it’ll set it for you.