Log data in a shared workbook

  • Thread starter Thread starter Joey
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mixed Data in column 5
How to reference a worksheet name 6
Shared workbook loses data 6
Share Workbook/Protect Sheet Question 2
Losing data on a shared workbook 3
Ghost Data/Large Operation 1
Summarise data from several worksheets in a workbook 2
Saving through a network affecting ability to update automatically 1

Back
Top