• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy real time data to another sheet in background

C

coolkiran

Member
Hello

I have data in Excel, which will update data in Sheet1 every 3 seconds. [Data is coming from software].

I need to copy the entire sheet to another sheet, because i wanted to do some calculation. This process has to run from background means i don't want to disturb the sheet1. Important thing is Sheet 1 name is unknown, it will change every day. Sheet 2 will not change, so we can say sheet2 name is fixed.

Is that possible?

Cheers
Kiran
 
Hi, coolkiran!

At a first glance it seems that you'll need a bit of hardware to accomplish that, but despite of it I have these doubts:
a) You say you have a workbook with 2 worksheets, one with a name know and another with an unknown name: wrong, once you open a workbook you then know all the worksheet names, and if you add a new worksheet too... so you always know its name.
b) What, where and how, is the data updated? What, the amount of data; where, in which range; how, method used.
c) If copying the entire worksheet (that which got the updated data) to a new worksheet, then you have 3 worksheets, or the destination worksheet is that which you called with a fixed name?
d) What are the calculations performed on this worksheet?

Consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you. Thank you. Give a look at the red sticky posts at this forums main page for uploading guidelines.

Regards!
 
You must log in or register to reply here.
Back
Top