Hi,
a friend of mine uses Excel for his invoices he writes as home care nurse.
Im a sheet he has a table containing Codes , descriptions and price of the care activity. With a Vlookup formula he combines the prices with the patients. But annualy when he get new prices, old the old entrie are updated to with the new prices.
This is a major problem when he has to complete his taxe form.
Is there any solution to prevent Excel from updating old records when data in refering table changes, or is there a better formula to achieve this problem? If this needs VBA programming is there anyone who could do this for us.
Thanks for your help
Dwinti
a friend of mine uses Excel for his invoices he writes as home care nurse.
Im a sheet he has a table containing Codes , descriptions and price of the care activity. With a Vlookup formula he combines the prices with the patients. But annualy when he get new prices, old the old entrie are updated to with the new prices.
This is a major problem when he has to complete his taxe form.
Is there any solution to prevent Excel from updating old records when data in refering table changes, or is there a better formula to achieve this problem? If this needs VBA programming is there anyone who could do this for us.
Thanks for your help
Dwinti