In sheet day1,
copy all except row1 (label) of each subsequent sheets (day2...day31) and
paste to bottom of sheet day1,
(in fact we consider a sheet for each day is unnecessary, but that is
your design)
sort ascending by balance,
delete all rows with 0 balance,
sort again by name/date

Help yourself with macro recorder please.

Regards

"Feast" wrote in message
...
Yes....... PY and Associates. Now how would I go about doing this?
--
Thanks in advance for the help.


"PY & Associates" wrote:

We guess you have 12 workbooks, one for each month.
Each workbook has 32 sheets, one for each calendar day and one summary
sheet.

We would imagine to combine all 31 sheets of each workbook in a new
sheet,
sort by name/date,
filter out or delete rows with 0 balance

If necessary, we would loop in all 12 workbooks

Doing this once a month is not difficult but of course, can be
automated.

Regards

"Feast" wrote in message
...
Hi everyone,

I am building a spreadsheet for a friend that will contain date of
sale,
First name, Last name, address, original $ amount, % of that $ amount,
How
many days financed, and balance due. This spreadsheet consist of 31
sheets
representing each day of the month and a final sheet that takes the
total
from the previous 31 sheets. I need to create a sheet that will take
each
individual name with a balance from the previous 31 sheets and pull
all
the
information from that row on the specific sheet on a Balance owed
sheet. I
have to do this for every month in the year. I have tried v lookup but
that
defeats the purpose of going thru each individual item seeing if there
is
a
balance. I need something that will look it up and pull all the
information
from the line item. I need this to look through 12 different
workbooks.
Some
Please HELP!!!!
--
Thanks in advance for the help.