EXCEL TO EXCEL AUTOMATION For Reports to reduce manual Effort

Help Studio
, , ,
1

Hello Dev’s

My requirement as i have an Excel Reports that is having a various tabs in it as Input and output. So using input tab i have to write the Result in Output Tab in same Excel.

Considering Salary (Input) tab i have to post the values in Teamwise Salary (Output) tab.

2

You can use Filter datatable for each Team
after filtering one by one you can write them in output tab/sheet

3

Tried but didn’t get can you please share .xaml file

Thanks and much appreciated

4

Is team size and no of teams are going to change or fixed?

5

Its going be changed in future maybe new member joined the team

6

Please check the below workflow hope it will help u and if required make changes
Reports.xaml (18.4 KB) Reports.xlsx (44.0 KB)

For testing in sheet Teamwise Salary (Output) remove all data from 3rd row

7

Thanks Appreciated

But one more thing as i need all data should be Post in Row 3 as format is given because there is formula’s associated with all columns and we only have to paste the data in it, if we remove all the Data from 3rd Row then formula’s are removed and our requirement is not working. Please suggest.

Thank you so much.

8

U can also pass formula using write cell

9

Tried But for me the write cells is based on the team size how can i manage that part.

10

Please share where u want that formula i will do it tomorrow

11

Thanks Attached the Report in Yellow Highlighted row there is formula i.e. in Employee name there addition of Records 2 record its show 2 then amount addition.Reports.xlsx (42.0 KB)

12

Hey @ImPratham45 if you get the chance to look into that ?

thanks

13

Sorry i am quite busy in my work will give u soon

14

You can use formulas using assign

15

I tried but didn’t get can you please share where i should assign so that i can get formula should works.Reports.xaml (18.4 KB) Reports.xlsx (44.0 KB) !
Name1+Name4=2 (=COUNTA(B4:B6))
38992+46011=85003 (=SUM(C4:C6))

16

Reports.xaml (26.5 KB) Reports.xlsx (44.3 KB)

1 Like
17

It works thanks @ImPratham45

18

Your welcome!!!

Hope its a good learning for you

Happy Automation !!!

1 Like
19

It is

Thank you so much

20

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.