Anupam wrote:
I am using excel to download my data in the columns. I can only use Excel
for my purpose bcos thats how the machine is configured. I record the data in
columns every minute so I can only record only data for 256 mins. Its a real
time data I can only control it by stopping and starting the test after every
4 hrs which is not feasible. Please advice me for the situation. Is there a
way by which excel can start recording the data in next sheet after it has
finished recording in one sheet?

Not without macros. Why not record downwards rather than rightwards? If
you record readings in cell B2, then B3, then B4, etc., you could
record 65535 readings in a single column. 65535 means a bit more than
45 1/2 days of readings could be stored in one column before having to
reset. Wouldn't that be sufficient?

If your machine is configured to record only going left to right, then
whether you want to accept it or not, you only have cells enough to
hold 4 1/4 hours worth of data. If you can't change how data is entered
(it'd have to be scripted in some way - do you have access to the
source code?), you have no alternative to stopping and restarting ever
4 1/4 hours. There's no way to have Excel automatically advance from
worksheet to worksheet.