🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac
Article #45771

Excel question

#45771
From: Gordon E. Banks
Date: Wed, 07 Feb 1990 15:24
10 lines
987 bytes
I have a question on Excel.  Is there a handy way of converting a
number (entered in data) into a reference?  Like a function,
say fun(20) which would return A20.  I can see perhaps how to
use a macro with the macro function offset to do it, but there
must be some easier way than that.  The application asks for a line number to 
be entered
from another worksheet and then I want to copy data from
that line.  There is no clean way to search the other worksheet
for the proper data without having a human look at it.
Technical Details
Message-ID: <1990Feb7.152454.22161@cadre.dsl.pitt.edu>
Path: arc1-ca.pugleaf.net!utzoo!attcan!uunet!clyde.concordia.ca!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!pt.cs.cmu.edu!dsl.pitt.edu!dsl.pitt.edu!geb

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!attcan!uunet!clyde.concordia.ca!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!pt.cs.cmu.edu!dsl.pitt.edu!dsl.pitt.edu!geb
From: geb@dsl.pitt.edu (Gordon E. Banks)
Newsgroups: comp.sys.mac
Subject: Excel question
Message-ID: <1990Feb7.152454.22161@cadre.dsl.pitt.edu>
Date: 7 Feb 90 15:24:54 GMT
Sender: news@cadre.dsl.pitt.edu (Usenet News System)
Organization: Decision Systems Laboratory, Univ. of Pittsburgh, PA.
Lines: 10