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
Automation question - Running change
Best answer by Yerko_Begic
as able to solve my problem with the Java Script.
+31Could you provide some screenshots of how the data looks in Table 1 and your expected output in Table 2?
Could you provide some screenshots of how the data looks in Table 1 and your expected output in Table 2?
Here is my Table1
And here Table2
I would create PivotTable based on Table2 to track my weekly/ monthly/ yearly data
Here is my Table1
And here Table2
I would create PivotTable based on Table2 to track my weekly/ monthly/ yearly data
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.