Excel 2007 : Automatic update of Cell values from one excel workbook to another

Hi All,

This is regarding "Automatic update of Cell values from one excel workbook to another workbook".

Our company is producing a product. After Inspection staff will key in the type of defect in one cell and Batch no. (in numerial 5 digits) on another cell below it. So each cell value have different values. The defect type ("Text" type) varies and the batch no. too.

If the part have no defect, they will leave the cell empty.



Say they are keying in the defect and batch no into Book 1. I need those keyed in values in "Book 1" should be copied in to "Book 2" under two column "A" (for defect) and "B" (for Batch No).



Whenever they click the cell and if the cell have any "Text" values they need to be copied to the "Book 2" in column "A" and "numerial value (for batch no)" to be copied in Column "B".



As you guys are expert in this technology, Pl. advise.



Thanks.

M Muthu.

If the 2 computers are on the same network(LAN), then there is a better way to do this.

On a LAN, use a SHARED workbook. Assign worksheets as needed to different people(departments).

So what was Book 2 on computer 2, is now sheet 2 on a SHARED book on the LAN.

Then if you need to copy data from one sheet to another, I would use macros.

Originally Posted by Dennis7849

If the 2 computers are on the same network(LAN), then there is a better way to do this.

On a LAN, use a SHARED workbook. Assign worksheets as needed to different people(departments).

So what was Book 2 on computer 2, is now sheet 2 on a SHARED book on the LAN.

Then if you need to copy data from one sheet to another, I would use macros.

Hi Dennis,

My file book 1 and book 2 are in same computer. I need to copy only cell values. (ommitting the cells with no values on book 1.)

Cheers

sample.jpg

Hi Roy



Pl. have a look in to the image. It will show the date, Product, time of inspection. Green indicated there is no defect. For eg. NC mentioned is a kind of defect and my staff record the batch no of the defect.



For every day we key in below data.







I need the following to be copied in to another sheet



1. Date

2. Product 1

3. DEfect type

4. Batch no

in below format.



Date Product Defect Batch No.



If there is no defect on that product still I need the date on "Date" and "Product" columns. "Defect" and "Batch No" can be empty.



Wish you all the best.



Thanks.

NM

Hi roy,

Attachment file is "Sample.jpg" on top of previous reply.

sample.jpg

Pl. veiw the image above.

Hi Roy,

Any help from your side to answer my question.