| |
You are here: Experts > Computing/Technology > Microsoft Software > Excel > Automatically entering data in Excel
Excel - Automatically entering data in Excel
Expert: Richard Roberts - 10/29/2009
Question
I am trying to create one excel workbook that can have data entered on two different sheets and end as a single spreadsheet.
Sheet 1 has the trouble information (date, location, actual problem, etc). This information will be entered by an individual based on inputs from the field.
Sheet 2 is for the completed action to be entered by the repairman.
I would like to have specific trouble information automatically entered on sheet 2 from the data entered on sheet 1, so the repairman will have the trouble information and be able to enter the corrective actions, parts, etc.
There will be some information on trouble sheet 1 that will not be needed by the repairman and will not be needed on sheet 2
The workbook will be hosted on a server and the data will be entered by the individuals on different computers.
Answer
John
I believe your situation can be handled by links between sheets.
Sheet2 can have a link to sheet1 that will transfer the data from sheet1 that you want to transfer. A linking formula looks like this
=Sheet1!A1
This formula will transfer the data from sheet1 cell A1 to the cell and sheet that the formula is in. The formula can be copied and it will change accordingly with the relative referencing.
If you create these types of formulas in sheet2, as you put data into the referenced cells in sheet1 it will be transfered to sheet2.
Hope this helps
Richard
Florida
USA
Ask a Question
|
|
