Forum Discussion
Need Help with Excel Formula and functions
I am unable to find how to get information pasted in cells after 5 minutes from Another worksheet.
I have a data sheet which updates information every 5 minutes and i have another worksheet that calculates the data. Now i want the data refreshed every 5 minutes in Worksheet1 to be pasted in WorkSheet 2 in a cell that i choose and after 5 minutes again copies the data from WorkSheet 1 to paste in worksheet 2 a cell below. However, i am unable to find a way to do this. Please help. Thanks
1 Reply
Anil,
The best technique is to copy the cells of these data as links to worksheet2 so that they change by changing the original data.
Copy the data, select the location you want to paste in, and then press Ctrl+Alt+V to open the paste special dialog box, after that, hit the Paste link button as the below screenshot:
