|
Linking From Table to create form
Please guide me to get the following linking problem solved :
One table List containing fields in sheet#1.
Prepared another sheet #2 in a form pattern using say for Labelling purpose, which has 5 rows altogether, with borders. The corresponding fields are linked to the sheet#1
Now the question is, when i copy the 1st set of form (in sheet#2) which contains 5 lines to generate 100 sets, the forms/pattern/links all are obviously copied, but the links are taken obviouly incremental from sheet #1. As my sheet#2 has 5 lines, i need to get the data by skipping off those lines.
Currently i have to do manually, for that can anyone give me good a solution pls?
I afraid, if you think i have note explained my question clearly, pls see the attached sample sheet updating with a sample file... i have changed the font colour to Red, which i require your assistance pls.
thanks
|