Simple Copy and Update Cell Value Every Minute
To Whom It May Concern:
I have the following issue.
I have an Excel file with several sheets as tabs inside the file.
The first tab of the Excel file is connected to stream live data feed.
What I want is to take the values from a particular cell on that "live feed sheet" at 1-minute increments and populate these values one after another into cells in another tab of the same file.
The value are updated continuously during the day.
So, let's say the values in a live feed are located in A1 cell of Worksheet 1.
I want values from this cell in 1-min increments to populate into cells A1, A3, A5, A7, A9... etc on Worksheet 2 of the same excel file.
Also, in cells A4, A6, A8, A10, A12, etc... I need a formula where A4 = (A3-A1); A6 = (A5-A3); A8 = (A7-A5), and etc. Is it possible to create only one formula that calculates difference between preceding cell - (preceding cell - 2)?
Could you please recommend what to do? I'm not an Excel expert and not a macro person.
I have Microsoft Excel 2010, Student Edition.