View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Light Meter Reader Light Meter Reader is offline
external usenet poster
 
Posts: 1
Default scroll automatically as data is imported into a spreadsheet

Hi - is there a way to get Excel to scroll a speadsheet automatically as data
is being imported into it from an external source? I have a lightmeter that
takes readings and sends them to a spreadsheet through external sofware via
RS232. Readings are taken every 0.5 second and being entered into
consecutive cells on a spreadsheet - I want the spreadsheet to scroll
automatically as the data is being transferred. Can this be done? How? I am
using Excel 2003. thanks.