worksheet help

[Guest]

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

 

[Guest]

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)

 

[PY & Associates]

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