Claim template

[Guest]

Hi there,

hope u can help -

i have a claim template, each time a claim is rasied it is printed and sent
for payment. This template is updated for each claim made - therefore no
record of it is kept on excel. What i want to do is when a claim is raised
and confirmed ok i want the cell details eg name, amt, etc copied to a
summary sheet - a type of database of all calims made - is this possible?

many thx

mandy

 

[Guest]

thx 4 reply - but how do i do this - not a wiz kid at excel!

 

[Guest]

I need more details on your claim worksheet.
What all you want to transfer to the summary worksheet and what is the
location of these fields? For example if you wish to transfer Claim amount,
date and Raised by then in which cells these 3 fields are?

 

[Guest]

hiya - those cells in particular are in L43, K14 & J5 - however i have
other data i want to tranfer, they are all in different cells - do i just
repeat the formula for these cells (J6,J7,J9,J11,J12, & K17)?

THX