worksheet help
 

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

worksheet help
 

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

worksheet help
 

You can consider adding as template in sheet 2 an individual log;
enter data in Master Quote Log;
macro to copy relevant data from Master Quote Log to sheet 2;
get new sheet name;
copy sheet 2 after last sheet;
name this sheet with the new sheet name.

This is exactly what you want

"musab" wrote in message
...
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