Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Claim template
This is possible, all that yo need is a macro that will transfer required
data from you claim worksheet to Summary worksheet. This macro should be written under 'Workbook_BeforePrint' event. -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! "Mandy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically look in template folder when one opens a template | Excel Discussion (Misc queries) | |||
NCAA tournament brackets template from Template gallery. | Excel Worksheet Functions | |||
Mileage Claim Formula | New Users to Excel | |||
Where do I find a template for a high school template? | Excel Discussion (Misc queries) | |||
Excel template to load automatically as the default template? | Excel Discussion (Misc queries) |