Skip to main content

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.

Could 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

 

as able to solve my problem with the Java Script.

Reply


Terms & Conditions