Pulling information from three sheets into a fourth automatically?

[rition]

I don't know if this can be done but I enter details of payments made
on three sheetst.

Sheets called 3A 3B and 3C the information on each sheet is different
but the payments received are the same so I enter the date and amount
under separate columns for cheques and cash

The columns I have on these three sheets are:

surname first name date cheque cash

and I need to details of the names and banking on sheet four on a
daily basis.


So if I am enter four entries onto sheet 3A with todays date I would
like them to appear on sheet four automatically for banking but only
if the entry in column b is new (i.e. today's date)

Can I do this?

Thank you

Wendy

 

[Dave Peterson]

Anything is possible, but not always easy (or bullet proof). This is one of
those kinds of things that can go bad pretty quickly.

I would do my best to keep all the data in one worksheet. Add an extra column
that can be used for some type of indicator.

Then you can apply data|filter|autofilter to see just the stuff you want to see.

 

[Bernie Deitrick]

Wendy,

Do yourself a favor, and start with a better design. Forget using four sheets - use just one sheet.
But add a fourth column to your database, which would contain a data item that would identify which
of the three previously used categories the item falls under. Then use filters or pivot tables to
manipulate your data to show it as you did previously. You'll be much better off.

HTH,
Bernie
MS Excel MVP

 

[rition]

Thank you both I will continue doing it as I am.