Sometimes not LastEntry

  • Thread starter Thread starter Gerry
  • Start date Start date
G

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
 
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
 
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
 
Back
Top