View Single Post
 
Old 11-08-2007, 10:34 PM
BOBN BOBN is offline
Novice
 
Join Date: Nov 2007
Posts: 1
BOBN
Default TRANSFER DATA TO NEW WORKSHEET

I presently have a DDE connection that imports 15 colums of data approximately every two minutes. I need to be able to look at the data in one cell, then move all the 15 columns of data to the worksheet with that number. This is being used so that when a date (1 -31) is set in one cell, it will move all the data to the worksheet with that number. There are 31 worksheets in the workbook. Presently I am using Excel 2003.
Reply With Quote