Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have an excel files with several worksheets.
For each excel file, I was able to extract information I needed in the different worksheet and I coul make some operations .
In each excel file, there is a worksheet called "recap" which needs to be populated based on the information I extracted.
I'd like to populate this worksheet but the format is a bit tricky because I have 3 different sections
see screenshot below
Is it possible to populate such a worksheet with a tmap for example?
If not, how I can I create a worksheet called "recap" with the informations required?
The information I extracted are stored in temporarty excel files which can be used to populalte my excel file.
thank you.
Hi,
You can do this, but its quite fiddly. Use the tFileOutputExcel and enable "is Absolute Y pos", which allows you select the first column and row to populate.
So, in your example you'd need to do it in 3 sets of output for the total, year and quarter.
Thanks
David