Copy onto new row into another workbook each time master workbook is updated

[Ali.B]

Hi All,

I have two workbooks one is the master document each time this is saved with new information, can i update the log workbook on a new row?? not sure if this is possible.

If you need to see what im using will you need a copy of both workbooks?

[jraj1106]

Hi
Upload both the files with explanation...

[Ali.B]

Fluffy Quotations password: pink3

I have attached copies of my workbooks.
I would like to be able to send certain cells from one to another when Fluffy quotations are saved under a new name the cells go to Quotation Log on the next row, so i would like :
Comp.Name - Fluffy Quotations- Customer Record - Cell B3 To goto Quotation Log Sheet 1 C3
Quote No. - Fluffy Quotations- Quotation Front- Cell I6 To goto Quotation Log Sheet 1 A6
Date: - Fluffy Quotations- Customer Record - Cell D3 To goto Quotation Log Sheet 1 B6
Site: - Fluffy Quotations- Customer Record- Cell B6 To goto Quotation Log Sheet 1 D6
Descrip - Fluffy Quotations- Quotation front- Cell E16 To goto Quotation Log Sheet 1 E6
Value: - Fluffy Quotations- Quotation Front- Cell I28 To goto Quotation Log Sheet 1 F6

These are in particular order, Sorry!!!

[Ali.B]

Sorry meant to add, i would like the quotation log to be updated with a new quotations raised on saving. Hope you can help!!