View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.links
Spaceman Spiff
 
Posts: n/a
Default 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