Frank,

Thanks for your help, but I'm sorry I might have been vague with m
question.
1) I collect data everyday.

The data is not the same, which means I'll probably have to put in
different workbook, not add on to the current work book

The number of rows or columns.

2) The data that I collect I have to make a Line Graph

The is created the same way, but with different data set.

Thanks for the links though, I've tried it and it didn't work. An
other suggestions for this type of automation

--
Message posted from http://www.ExcelForum.com