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

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
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>