Offset function
Try this...
Using Indirect
=INDIRECT("Sheet1!A1")
=INDIRECT("Sheet1!B1")
=INDIRECT("Sheet1!C1")
Using Offset
=OFFSET(Sheet1!A1,0,0)
=OFFSET(Sheet1!A1,0,1)
=OFFSET(Sheet1!A1,0,2)
If this post helps, Click Yes!
--------------------
(Ms-Exl-Learner)
--------------------
"Eva" wrote:
I have the data in sheet 1 as follows
col A - blank or "new"
col B - name
col c - number
I need to create in sheet2 report that takes only "new" data from column A
col B - name
col c - number
I thought about the offset function - any ideas?
--
Greatly appreciated
|