I would do it the other way around. Enter the info in the individual quote
log, click a command button, and let a macro transfer the info to the next
line on the Master quote log. Easiest would be to go through the motions
while recording a macro. Once done, edit the macro to go to the next open
line in the master log, and to paste offset from the first entry(A). Iow Col
B will be Offset(0, 1)

"musab" wrote:

I need help please. THis is my problem:

I have different quote logs in different workbooks. They all have the same
format. My problem is that I have a Master Quote Log and when I have to
enter the information in the Master Log and then in the individual log. What
I want to do is to put all the workbook into one and have different sheets.
So that when I type in the Mast quote log the info. automatically goes into
the individual log. Please advise on how to do this.

Thanks