Continuos importing without lossing previous data.

[hitman007]

i want to import data from sheet2 a1 from sheet1 a1 continously. now problem is when iam importing i shouldnt loose my previous data.

eg: at time 11 when i import data to sheet2 a1 from sheet1 a1 with value 9 .

and at time 12 when i import data to sheet2 a1 from sheet1 a1 with value 10 .

value 10 will be over wrting value 9 . here i shouldnt loose value 9 . i want values comming afterwards should come to next row. can anyone please guide me in this process.

thanks

[newdude]

I am a newbie at this but, if you are going to import to a1 every time it will write over current data in a1. I would suggest a macro where you would go to a1 on sheet 2 and then go {end}{down}{down} Paste. or whatever command you use to put the data on sheet 2. Don't really know if this is what you are looking for or not.