We have requirement to generate weekly and monthly trend charts in Excel based on a list from SharePoint. There is no option to capture date in this list.

We thought of copying 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?

1 Answer 1


You can create timer job , which will run weekly or monthly as per your requirement. You can find multiple sites describing how to create timer jobs like Link1 Link2

You can write your business logic for Copying list item to another list in Execute method. This link will help with the business logic

Hope this will solve your problem.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.