View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MOLLY66 MOLLY66 is offline
external usenet poster
 
Posts: 9
Default Changing linked worksheet and range of cells

Hello

I have a spreadsheet (master spreadsheet) which counts the number of times
individual countries appear in one column on a linked spreadsheet. The
linked spreadsheet and range of cells always changes. How can I update my
master spreadsheet to count the number of times a country appears in the new
range of cells in the new linked spreadsheet? I figured out how to update
the link to a new spreadsheet but not how to change the range of cells.
--
Thanks in advance