Sometimes not LastEntry

[Gerry]

Hi,
I would like to know if a row could be singled out as a
choice specified to affect a report.

Eg. I have Sheet1 as data entry over several columns. I
call for the data from Sheet1 to create a report (Sheet2)
using last entry logic. Can I somehow specify a previous
row to affect the report sheet?
(at present I copy the file and eliminate all rows except
for what I want, then print)

TIA
Gerry

 

[Jason Morin]

What you could do is apply an Autofilter to Sheet1, filter
for the row you specify, then print.

1. Add a column to Sheet1 called "Row".
2. In row 2 of that column, put:
=IF(ROW()=$G$1,"",1)
and copy all the way down.
3. Specify the row you want in G1.
4. Click back on a cell in your data and go to Data >
Filter > AutoFilter.
5. Select (Blanks) in column "Row" in the drop-down list.

HTH
Jason
Atlanta, GA

 

[Gerry]

Thank you, that helps on the data sheet but my sheet with
the report still shows the last entry data. My logic is
this (eg. is for one item).
=OFFSET(Sheet1!D1,MAX(IF(Sheet1!D1:Sheet1!D1000<>"",ROW
(Sheet1!D1:Sheet1!D1000)))-1,)
and it works well if your last row's info is what you want
on the report sheet. Sometimes I would like to 'trick' the
report sheet to think another row is last.

TIA