
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 21, 2024 04:58 PM
I would like to run Automation every week on Sunday, and the purpose is to have a running change for my Pivot Tables. I would like to take the "Items", "QTY" and "Last Date/Time Updated" from Table1, and copy/ paste that data into the Table2 which has the same column names. Is this possible and how is it done? I was poking around and wasn't able to figure it out.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 22, 2024 01:21 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 21, 2024 07:15 PM
Could you provide some screenshots of how the data looks in Table 1 and your expected output in Table 2?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 21, 2024 08:04 PM
Here is my Table1
And here Table2
I would create PivotTable based on Table2 to track my weekly/ monthly/ yearly data

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 21, 2024 08:29 PM
Let me correct one thing... There are going to be other columns in Table1, but I only need "Items", "QTY", "Last Date/Time Updated" and "Value" to be grabbed and moved over to Table2

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 22, 2024 01:21 PM
as able to solve my problem with the Java Script.
