Counting of one time use items and spells for DnD 3.5e

Hi there. Is there any way to automatically count one time use items and spells for DnD3.5 character sheet? I mean, is there any command to be added to a spell macro that will change the prepared/memorized amount for that particular spell? E.g., a wizard has prepared 3 magic missiles. Is there a way to automatically reduce the prepared amount of magic missile spells when the macro is used? Is also such a way to keep track the one use items, e.g. potions or wands?

Macros cannot set values on the character token or character sheet without using the API. Whether you can use an API script to set a value in a repeating field, I am not certain as I have not played with the API much. My group normally keeps track of single use items in the 'Single Use Items' section of equipment. ie.: Staff of Cure Moderate Wounds (50 charges) 17 charges used But sometimes they'll take one of the spell sections (say section 10 or which ever) and re-lable it (just click on the name of the section and you can change it) and keep the charged and daily use items there (and then use the prep column for total charges and the used for used charges).