Linking to a pivot table from a formatted invoice
Hi people,
My original post had a lot of words in it, but it really boils down to a
question of how to populate a column with links in nonadjacent rows when the
source data are in adjacent rows.
We can model the same problem by imagining that we have a simple
spreadsheet, one with five values in column A, in rows 1 through 5, say for
instance, 10, 20, 30, 40 and 50.
Now imagine that we want the same exact numbers reported in column B of the
same worksheet, but we want them on lines 3, 6, 9, 12 and 15. How do we copy
the links, so as to avoid typing each one in?
Spiff
|