IF Statement?

[csegal]

Hello,
Is it possible to have an IF statement in a particular cell in one excell workbook and if a statement in 1 cell states "DOCK TO STOCK" then the information for that entire line (row) would automatically be entered into another workbook.
Ie... We have 1 workbook entitled Receiving Log which contains several columns such as P/N, PO, QC, Date, Desc, Supplier, Comments, etc...
If the Comments cloumn states "DOCK TO STOCK", I would like for that line's info to be entered into another workbook entitled Dock to Stock.

[npamcpp]

No, that's not possible with an IF() statement. You will need VBA for that kind of functionality. An IF() statement can only change the value in the cell that it resides in.

[K m]

It is possible using a macro.

[csegal]

I would need help in writing a macro...

[K m]

To write a macro, sample data is needed. Can you upload a spreadsheet with sample data?

[csegal]

COLUMN HEADINGS
QC DATE PART NUMBER DESCRIPTION REV SUPPLIER SO/PO ACC. QTY: REJ. QTY: NCR# DefectCodes/Quantities Comments


DATA ENTRY
CS 1/3/2012 34614-00081 .06 INCHx .75 INCH x 50 ft. BLACK NEOPRENE SPONGE TAPE N/A LAMATEK 14922-11-1 0 50 2038 DC2 DOCK TO STOCK

[csegal]

Here is the upload...