Populate Deposit Record from another worksheet

[HH]

I'm way over my head here!

I have about 50 worksheets. Part of every sheet is a simple payment record.
Every worksheet is the set up exactly alike. In all worksheets D6 = FName,
N6=LName, D5495=DatePaid,G54:G95=Tuition, J54:J95=Fee, K54:K95=Gift.
I would like to populate a deposit record on another worksheet
(DepositRecord) with the information above. Each payment would go on the
next empty row in the deposit record. On deposit day a total amount would be
calculated on the DepositRecord (this would be done manually). After the
deposit is made, new records would be added below for the next deposit day.

Hope this is clear enough to get me started

 

[NoodNutt]

G'day

Fisrtly, In NG Ettiquite, it's always nice to have someones name, so when
replying it personalises it. That said!

Take a look at this link, i'm fairly certain it will do what you need to
achieve.

http://www.rondebruin.nl/copy2.htm

This code will copy records from multiple sheets based on your criteria then
paste them to your designated target sheet.

Ron also has other example codes that may help you also.

HTH
Regards
Mark.

 

[HH]

Sorry NoodNutt, My name is HH - like it says in the "From" Column.

Thanks for the reply. Ron has good code on his summary sheet, but its not
exactly what I'm looking for. His summary runs and re-populates each time a
change is made.
I'll keep looking,
Thanks again
HH

 

[Ron de Bruin]

Maybe you are looking for this
http://www.rondebruin.nl/copy1.htm

 

[NoodNutt]

G'day HH

Please accept my apologies if I put you offside, wasn't meant as a negative,
just nice to have a first name in which to recognise.

Seems the more posts I look at recently, the less I see basic politeness
from people asking for assistance.

I sincerely hope Ron was able to help with your question.

Regards
Mark.