I'm a bit confused with what you mean.
If you'll send me the file I'll take a look at it.

Send to


"dave glynn" wrote in message
...
Hi Jim,

It works and gives me the same result as the macro but much more
effectively. However I am still stuck with the same row numbers. For
example
my first payee this week is in row 17; the next in row 43 and so on.
Ultimately I have to send a file to the bank where row 17 on the old sheet
is
on row 1 of a new sheet, 43 of the old on 2 of the new etc.. Thanks again

Dave

"Jim May" wrote:

In (new) A1 enter

better make that

In A2 enter



"Jim May" wrote in message
news:aa3Sd.52466$EG1.6656@lakeread04...
Insert a new Column A (give it the headername NewRow#
In (new) A1 enter =subtotal(3,$A$1:A1)
copy down from A2:A600

Engage the Auto-Filter on your table of data.

Now
Select from the appropriate FieldHeader dropdown the current weeks
checks
Only your Current weeks check should be visible.
Check out the content of Column A (now) !!
Does it Look like you want it to?
HTH



"Bernard Liengme" wrote in message
...
Rewrite the macro?
If you tell us the code someone may point the way.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dave glynn" wrote in message
...
i have 600 potential payees in an excel spreadsheet. Of these only
20%
receive payment in any one week. By using macros I can produce a
worksheet
showing all payees paid in any one week, hiding all others.
However
the
resulting spreadsheet still retains the original row numbers as
the
zero
value rows are only hidden. Is there any way that I can have the
spreadsheet
ignore the original row references so that the first payee is
shown in
row
1,
the seconf in row 2 etc?Thanks