Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet - Quote log
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet - Quote log
Enter data in Master workbook;
trigger a macro: copy relevant data into formatted area of this worksheet; add a new worksheet; ask for worksheet name; copy the formatted area into this new worksheet; "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |