Ok I have a bit of an issue (most likely in my brain) that I can't work out what I should be looking up.
I have an Excel Form that needs populating (mail merge style) via a Seperate worksheet containing the data. I have varius name spaces specified that replicates Winword's mail merge etc... but my issue is this:
Once column of data contains a list of software to be installed per machine (multiple text lines per row IE:
A1 (Name: RequestedSW) would contain:
(line1)Office 2003Pro
(line2)AutoCAD2011
(line3)Adobe reader
(line4)AdobeFlash
A2 (Name: RequestedSW)
(line1)AdobeFlash
(line2)AdobeReader
(line3)winZip
On the Form I need these linked to the following structure:
A1 - Text line 1 B1 - Check Box
A2 - Text line 2 B2 - Check Box
A3 - Text line 3 B3 - Check Box
A4 - Text line 4 B4 - Check Box
A5 - Text line 5 B5 - Check Box
A6 - Text line 6 B6 - Check Box
I hope I've been clear in what I mean. I'm not sure what to look for to resolve this issue. (I could merge the cells on the form but this messes up the check box links
At the moment I've got a merged cell that only has the following in it = RequestedSw which as I say displays the text but not in line with the check boxes. Is there a way to do a ForEvery TXTLINE in RequestedSW ..... type thing ?
I have an Excel Form that needs populating (mail merge style) via a Seperate worksheet containing the data. I have varius name spaces specified that replicates Winword's mail merge etc... but my issue is this:
Once column of data contains a list of software to be installed per machine (multiple text lines per row IE:
A1 (Name: RequestedSW) would contain:
(line1)Office 2003Pro
(line2)AutoCAD2011
(line3)Adobe reader
(line4)AdobeFlash
A2 (Name: RequestedSW)
(line1)AdobeFlash
(line2)AdobeReader
(line3)winZip
On the Form I need these linked to the following structure:
A1 - Text line 1 B1 - Check Box
A2 - Text line 2 B2 - Check Box
A3 - Text line 3 B3 - Check Box
A4 - Text line 4 B4 - Check Box
A5 - Text line 5 B5 - Check Box
A6 - Text line 6 B6 - Check Box
I hope I've been clear in what I mean. I'm not sure what to look for to resolve this issue. (I could merge the cells on the form but this messes up the check box links
At the moment I've got a merged cell that only has the following in it = RequestedSw which as I say displays the text but not in line with the check boxes. Is there a way to do a ForEvery TXTLINE in RequestedSW ..... type thing ?
