I have a invoice sheet , from the invoice sheet i have to create project wise sheet from the base template and fill the hours (transpose) for each resource.
I was able to create project wise sheet (with right file name as expected), see the below screenshot.
But i am not able to achieve as expected below:
I don’t have to fill Total hours column , because template already has the formula added to it.
I am attaching my Invoice sheet and xaml files here.
Could you please advise and provide an idea on this?Timsheet_Consolidation.xaml (25.9 KB)
TIME_DETAIL_INVOICE.xlsx (14.4 KB)