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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.