I have 17 worksheets in one workbook. In the worksheets I have records
they are not sorted except by date. There is an additional field in
each record, a p for paid or o for owe. I need to see if I can make a
list of all the o's and p's in the workbook on a single worksheet
based on the other pages.
Thanks in advance.

Josh

There are several ways to do this. Can you please give more details? More
details will yield more responses.


Regards,
Ryan--

--
RyGuy


"JMac" wrote:

I have 17 worksheets in one workbook. In the worksheets I have records
they are not sorted except by date. There is an additional field in
each record, a p for paid or o for owe. I need to see if I can make a
list of all the o's and p's in the workbook on a single worksheet
based on the other pages.
Thanks in advance.

Josh

On Jun 4, 8:22*am, ryguy7272
wrote:
There are several ways to do this. *Can you please give more details? *More
details will yield more responses.

Regards,
Ryan--

--
RyGuy



"JMac" wrote:
I have 17 worksheets in one workbook. In the worksheets I have records
they are not sorted except by date. There is an additional field in
each record, a p for paid or o for owe. I need to see if I can make a
list of all the o's and p's in the workbook on a single worksheet
based on the other pages.
Thanks in advance.

Josh- Hide quoted text -

- Show quoted text -

I'm finding that I cannot use a Vlookup on a 3d reference, which was
my first thought.

Each worksheet has records of transactions separated by location. Each
transactions has an option to be either paid or outstanding, (O or P)
I would like to compile a list on one worksheet that has all the O's
for every location, and then on another worksheet for the P's for
every location. For reporting purposes the records are placed on
different worksheets, or else I would make one large list.

Thanks,
J