In article <
d9677142-257b-403e...@googlegroups.com>,
darr...@gmail.com says...
Referencing a value in another tab is easy enough. To see the syntax, start a
formula (by typing '=') on one tab, then use the mouse to navigate to a cell in
another tab. Hit Enter, and examine the formula. Simples.
So doing this manually isn't hard at all. For any level of automation (like
traversing through the collection of tabs in your worksheet) you need macros
(VB).
Sometimes, when the difficulty/complexity of manipulating your data gets a bit
excessive, it's time to consider how you structure your data. Do those tabs
have to be tabs? Or could [tabname] simply be an additional column in one big
"table"?
And sometimes, you're swimming against the current by sticking with Excel,
instead of learning the wonderful capabilities of Access.
--
Phil, London