I have created 10 worksheets in a Excel 2003 Workbook. The following is what I am trying to achieve and would like some advice or help on how to go about this if possible. I am an average user and do not know Visual Basic. Can anyone help me please.
Worksheets 1 to 10 are named as follows:
1. Name = CUSTOMER which is all the customer details
2. Name = MASTER which is a master list of products to be shipped overseas in Containers.
3. Name = CONTAINER 1 which will be a list of the products from the master list to go into Container 1.
4. Name = CONTAINER 2 which will be a list of the products from the master list to go into Container 2.
5. Name = CONTAINER 3 which will be a list of the products from the master list to go into Container 3.
6. Name = CONTAINER 4 which will be a list of the products from the master list to go into Container 4.
7. Name = PACKLIST 1 and will be the enclosed list of items in Container 1 with Customer Details
8. Name = PACKLIST 2 and will be the enclosed list of items in Container 1 with Customer Details
9. Name = PACKLIST 3 and will be the enclosed list of items in Container 1 with Customer Details
10. Name = PACKLIST 4 and will be the enclosed list of items in Container 1 with Customer Details
Note: The MASTER and CONTAINER worksheets all have the same Headings.
(a) In Column 1 of the MASTER and CONTAINER worksheets is a heading called Container No Allocated. Once the MASTER list has been completed, I allocate a CONTAINER NO. from 1 to 4 to each of the items in the Master List. The numbers will not necessarily be in Ascending Order (Maybe Filter this column to display the list of all products in Container 2????).
(b) I then want all the items in each Container to be listed in the corresponding worksheets CONTAINER 1,2,3,4.
(c) From each of the CONTAINER 1,2,3,4 worksheets, I then want to take two columns of data and put them into 2 columns in the PACKLIST 1,2,3,4 worksheets which is the Quantity and Description headings.
Note: The size of the columns in the PACKLIST worksheets are different to the column sizes in the CONTAINER worksheets.
Thanks Carol
Worksheets 1 to 10 are named as follows:
1. Name = CUSTOMER which is all the customer details
2. Name = MASTER which is a master list of products to be shipped overseas in Containers.
3. Name = CONTAINER 1 which will be a list of the products from the master list to go into Container 1.
4. Name = CONTAINER 2 which will be a list of the products from the master list to go into Container 2.
5. Name = CONTAINER 3 which will be a list of the products from the master list to go into Container 3.
6. Name = CONTAINER 4 which will be a list of the products from the master list to go into Container 4.
7. Name = PACKLIST 1 and will be the enclosed list of items in Container 1 with Customer Details
8. Name = PACKLIST 2 and will be the enclosed list of items in Container 1 with Customer Details
9. Name = PACKLIST 3 and will be the enclosed list of items in Container 1 with Customer Details
10. Name = PACKLIST 4 and will be the enclosed list of items in Container 1 with Customer Details
Note: The MASTER and CONTAINER worksheets all have the same Headings.
(a) In Column 1 of the MASTER and CONTAINER worksheets is a heading called Container No Allocated. Once the MASTER list has been completed, I allocate a CONTAINER NO. from 1 to 4 to each of the items in the Master List. The numbers will not necessarily be in Ascending Order (Maybe Filter this column to display the list of all products in Container 2????).
(b) I then want all the items in each Container to be listed in the corresponding worksheets CONTAINER 1,2,3,4.
(c) From each of the CONTAINER 1,2,3,4 worksheets, I then want to take two columns of data and put them into 2 columns in the PACKLIST 1,2,3,4 worksheets which is the Quantity and Description headings.
Note: The size of the columns in the PACKLIST worksheets are different to the column sizes in the CONTAINER worksheets.
Thanks Carol