weWe have requirement to generate weekly and monthly trend charts in excelExcel based on a list from sharepointSharePoint. There is no option to capture date in this list.
We thought of copingcopying data from one list to another list on a weekly basis (and by adding new column to this list as a date of shipping). This would allow us to generate weekly/monthly trend charts.
Is there a way to copy/automate this data shipping from one list to other by end of week? any responses would be greatly appreciated.