Data Entry in the same file by 2 computers

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Dear all,

I have an .xls file which requires manual input from 2 computers
simultaneously, one for Sheet 1 while another for Sheet 2. May I know how it
can be done provided that they are in the same LAN? I don't want to copy a
spreadsheet from one file to another manually after the input of data.

Chris
 
If you share the file, (Tools>Share Workbook, check the box for 'Allow
changes by more than one user at the same time'), both users will be
able to enter data.
 
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

Copy Data from One sheet to Different Sheets 1
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7
Filename Problem In a Macro 4
Sort cells and "Place in this document"-hyperlinks 1
rows to columns conversion (or 90 degrees data turn) 8
Extracting data from Multiple columns to a Single row 1
Lookups - how to obtain data from a master spreadsheet into another 5
Copy Columns based on Header name 1

Back
Top