Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rbygo
  • Order by date
  1. rbygo

    Referencing worksheet tabs

    Thanks, GlennUK! For some reason, the formula was automatically converted to =INDIRECT(A1&":J4") (a colon instead of an exclamation point before the final cell reference). Changing the colon to an exclamation point did the trick.
  2. rbygo

    Referencing worksheet tabs

    Several months ago, DaleWatson123321 provided me with the solution @@(A1&":J4") to the following question which I posted in the Lotus Smartsuite forum. This formula works perfectly in Lotus. When I saved the file to Excel, all other formulas appeared to convert successfully, but...
  3. rbygo

    Referencing worksheet tabs

    Perfect! I spent hours trying to find a solution. I should have come here first. This is much more elegant than the klunky method I was afraid I would have to use. Thanks, Dale!
  4. rbygo

    Referencing worksheet tabs

    I have thirteen worksheet tabs in one file - one tab for each month, plus one worksheet tab that analyzes data from the current month. The worksheet tabs are lableld as follows: JAN FEB MAR ...(etc, through DEC) ANALYSIS ANALYSIS cell A1 contains the name of the current month (in the same...

Part and Inventory Search

Back
Top