Quote:
Originally Posted by charlesdh
Hi,
No need to be sorry. I'm getting closer to what you want.
You want the info in the data worksheet to populate sheet 1 of the Form sheet and Sheet2.
|
Yes, exactly.
Quote:
Originally Posted by charlesdh
Now the new question is for example you have a vendor named "A&B Construction".
It is listed several times. I can see that you will populate the form for the first record.
Now you want to enter the next record for the same customer. How do you want to enter the second record? If you enter the next record it will over write the data in sheet1! Sheet2 would have no problems. It will go to the next row.
|
I want the Vendor Name to populate cell D8 of Sheet1 on the Form and Vendor Number to populate cell D12 of Sheet1 on the Form. Then it would populate the Vendor Item, Description and Comments into Sheet2 of the Form in columns B, C and D. Example A&B Construction should have 8 rows on Sheet2.
Quote:
Originally Posted by charlesdh
Now you want to enter the next record for the same customer. How do you want to enter the second record? If you enter the next record it will over write the data in sheet1! Sheet2 would have no problems. It will go to the next row.
|
The next Vendor, should be C&D Plumbling will have their own workbook with Sheet1 and Sheet2 filled out on the Form and then Sunny Pipeline will have their own workbook. So at the end of this exercise, Ill have six workbook files.
04-01-2015, 06:28 AM
Similar Threads
Creating a table that automatically updates based on entries of a heading in the document
Windows 7 64bit 
Office 2010 64bit
Threaded Mode