Juliewinters
New Member
- Joined
- Feb 3, 2013
- Messages
- 2
Hi, I have an excel sheet which people use to list the samples requested for each potential client on each day, so this sheet will have multiple entries under the main column headings, product code, description, quantity, client and date. A simple columnar format.
I want to link this main summary sheet to a single A4 form in sheet 2, called a sample form which will be printed out for each unique client request.
I know how to link sheets using the paste special, but I want to find a way of automatically, when you open the excel document and you're adding a new request that the other sheet with the sample form will only pick up the items listed on the sample form with a unique date (i.e the day it is added) and client and just select the list of items entered on the day into the sample form, which would can be printed out for each client and submitted as a request to the office. Thanks
I want to link this main summary sheet to a single A4 form in sheet 2, called a sample form which will be printed out for each unique client request.
I know how to link sheets using the paste special, but I want to find a way of automatically, when you open the excel document and you're adding a new request that the other sheet with the sample form will only pick up the items listed on the sample form with a unique date (i.e the day it is added) and client and just select the list of items entered on the day into the sample form, which would can be printed out for each client and submitted as a request to the office. Thanks