Log data in a shared workbook

J

Joey

Hi all

Is it possible to have a spreadsheet which logs data from anothe
without over writing each other's data, even though several colleague
are inputting and saving in this shared sheet at different times.

Eg.
Sheet 1 has various data

Sheet 2 - A1,2,3, etc = first save
Sheet 3 - B1,2,3, etc = second save
Etc.

...for the day


Cheers
Joe
 
D

Dick Kusleika

Joey

Would you consider writing to a CSV file? You could use VBA's text file
functions to write directly to the file, but the file would still open in
Excel. One advantage would be that the time that each user had the file
open would be very minimal. Post back if that sounds like a workable
solution and you need help with the VBA.
 
Top