Maybe...
Debra Dalgleish has some code that will use one worksheet as a database and
another worksheet as a form that can be printed.
If you want to review that:
http://contextures.com/xlForm03.html
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Travis wrote:
With the exception of macros, I'm very proficient with Excel. All I really
know how to do with macros is record them and play them back. Unfortunately,
I need to do something a little more complicated. I have a table of variables
that feed into a series of lookups and data tables. I need a macro to go
through the table in serial fashion, copying a value from the first line of
the table into a designated cell, then printing a range, then going to the
second line in the table, copying that value into the same cell, printing the
same range, etc. I need it to go through all the variables in that column of
the table until it reaches the bottom. I picked up a couple of VBA Excel
books but haven't seen anything on point.
I'm looking either for a really on-point code example to follow, or failing
that, general recommendations. If the code isn't available, is there a
recommended online resource, training dvd, etc?
--
Dave Peterson