Hi
My first post here. I have a workbook (WORKBOOK 1), which has numerous userforms that will put information in various worksheets in that workbook. However, key information, such as "Client Name", "Client Address" etc. needs to be exported to a master workbook (MASTER) when the WORKBOOK 1 is saved and closed. Furthermore, when this client's details are exported to the MASTER, the MASTER gives it a unique ID number, say 1102. When this process is done for another workbook (WORKBOOK 2), the unique ID number for this is the next sequential number, so it will have ID 1103 and so on.
Is the code to do this very difficult? I am newish to vba.
Many thanks in anticipation.
My first post here. I have a workbook (WORKBOOK 1), which has numerous userforms that will put information in various worksheets in that workbook. However, key information, such as "Client Name", "Client Address" etc. needs to be exported to a master workbook (MASTER) when the WORKBOOK 1 is saved and closed. Furthermore, when this client's details are exported to the MASTER, the MASTER gives it a unique ID number, say 1102. When this process is done for another workbook (WORKBOOK 2), the unique ID number for this is the next sequential number, so it will have ID 1103 and so on.
Is the code to do this very difficult? I am newish to vba.
Many thanks in anticipation.