I wish to count bus stop usage in London.
Sheet1 has about 1000 rows.
Each row has up to 2 hyperlinks elsewhere to information on the stops in
a particular direction. 1 link is valid where a particuar route is
circular and in one direction.
e.g. Route 4 has links with "4 Archway" and "4 Waterloo"
4 Archway consists of: Waterloo Station / Waterloo Road stop F;
Waterloo Bridge / South Bank stop P; Lancaster Place stop T; ...
Archway Station / Macdonald Road
4 Waterloo consists of: Archway Station / Junction Road stop U;
Whittington Hospital stop J; Dartmouth Park Hill stop HJ; ...
Waterloo Station / Waterloo Road
There are approximately 40k cells - COUNTA is my friend. ;)
My first cut used a one column sheet for each set of stops and amounted
to about 18Mb.
My second cut used a row for each set of stops in a Sheet2 and amounted
to about 13Mb.
Both cuts take an unreadonable time to open.
I could have links to 1000 files. This might be fast, but manipulating
a set of 1000 files seems absurd.
I was thinking of about 10 files of about 100 rows; how can I link to
anywhere other than A1 in another file?
I suppose I could have a folder containing a sheet1 file and a subfolder
containing 10 subfolders of 100 single column files.
I have yet to find a comparison between uses of the HYPERLINK function
and hyperlinks using the Insert Hyperlink dialog - accessed either by
Ctrl+k or Insert Hyperlink... in Excel 2003.
--
Walter Briscoe