Hi scott

See
http://www.rondebruin.nl/copy1.htm

See the last example on the page

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"scott" wrote in message ...
Hello,

how do I setup an excel file that each time when I enter data in one
spreadsheet it will export to another excel file in the same column of
subsequent rows?

Example: if each time data enter in one spreadsheet column A of row 1 it
will export this data to another spreadsheet column B of row 1,2,3... and so
on.

Thanks. Scott