Forum Discussion

danszczepanski's avatar
danszczepanski
New Contributor III
1 month ago
Solved

Loading a Journal Excel Template into Multiple Periods

Hi, is there syntax similar to forms to load journals into multiple wf periods? My WF is 1 period, 12 months: I tried using similar syntax to form loads: Template set up as monthly: A...
Excel Add In
Reports
  • MarcusH's avatar
    MarcusH
    1 month ago

    I don't think it's possible. The Journal Header specifies the Workflow Time which will apply to all the Detail rows in that named range. You can have more than one named range though either on the same worksheet or multiple worksheets. So you could have a sheet for 2026M1 and another for 2026M2 etc

MarcusH's avatar
MarcusH
Valued Contributor
1 month ago

I don't think it's possible. The Journal Header specifies the Workflow Time which will apply to all the Detail rows in that named range. You can have more than one named range though either on the same worksheet or multiple worksheets. So you could have a sheet for 2026M1 and another for 2026M2 etc