Claim template

M

Mandy

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
 
P

Pranav Vaidya

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?
 
M

Mandy

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
 
Top