Automation

[Closed]
Report
Posts
1
Registration date
Tuesday November 20, 2012
Status
Member
Last seen
November 20, 2012
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
hello ,

i used to make a report on excel which exceed more than two hours every day i will mention the report in breif

i have a big report which is a fixed report that didnot change and i have files with row data which i took the values from those files and update this values in the big report , this values are numbers only and if any record appears for the first time in the files i took it and add it to the big one since this record is not included in it also their is graphs

please tell me if their is any option to automate this report by any way

1 reply

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
Hi Optimistic,

A bit more detail is required.

How are your files named (the master[destination] file and source files)?

In what range are the values you would like to carry over?
Is that range the same for all files?

Best regards,
Trowa