Lively discussions on the graphic arts and publishing — in print or on the web

Go Back   Desktop Publishing Forum > General Discussions > Software

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 09-24-2009, 06:18 AM   #1
LoisWakeman's Avatar
Join Date: Jan 2005
Location: Uplyme, Devon, England
Posts: 1,402
Default Excel guru wanted

I am making a little Office app to manage the results of our village flower show. Doing the spreadsheet that works out entry numbers and points awarded was easy, but I hope to extend it by printing out entry cards for each entry - this would have the entrants name and class number etc printed on it.

The spreadsheet is like this (except I can't get this darned editor to preserve my tabs, so have attached a sample as a tab delimited text file):
# Entrant 1 2 3 4
Mrs S & Mr J Hallett y y
2 Mrs P Taylor
3 Mrs M Bohane y y
4 Mr D Edwards y

and I want to step through the rows and columns, finding each "y" (for entry made in this class), and using that cell as the base point, collect the entrants name, number, and class number from the same row and column. Once I have those values in an array, I can (I hope) insert them in my merge document.

My first question is, can this be done? I assume it must be possible, but my VBA is pretty basic (pardon the pun). The second is, can someone point me to a web page that describes the principle of stepping through cells in a given range and getting related cell values? Google was not my friend in this case.
Attached Files
File Type: txt test.txt (517 Bytes, 21 views)
LoisWakeman is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Vista SP1 testers wanted Kelvyn General Publishing Topics 1 01-24-2007 09:25 AM
Recruiting MS Office Guru/DTP TDP-DTP Business Matters 8 06-15-2006 03:22 AM
Postscript Printer Recommendation Wanted danakay Hardware & Gadgets 9 03-14-2006 12:37 PM
Unicode WIKI — help wanted ktinkel Fonts & Typography 6 09-01-2005 11:39 AM
Word vs Acrobat guru needed!! ktinkel Print Production & Automation 7 05-13-2005 08:51 AM

All times are GMT -8. The time now is 04:54 PM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Contents copyright 2004–2018 Desktop Publishing Forum and its members.