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 ca...
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: