Excel budget statistics sheet
Budget: $30 – $250 NZD
I need an xls sheet that will capture a clients budget requirements for the year and send a non-personlized copy of the data to me via e-mial, to upload to a data base, later on.
The existing sheet I have needs to be updated with the fowling requirements :
1 Auto load Tcode, with each unique transaction code sent to the transaction tab. The users will Code all uncoded transactions and have the new codes update to Tcodes tab on the fly.
2 Makings the tCode olny read the first 11 digits only.
3 A resets to Zero clean sheet button. On main sheet
4 Email for Statisaics reaserch button, On Main sheet. This should Email me a data file .csv that can be loaded as database or excell. Containing a Tcode coulm, Transaction amount coulm and a Date coulum.
5 the old chart graph needs to be fixed so all Tcobdes can be selected and graphed.
I need this Finnished before end of November.
The existing sheet I have needs to be updated with the fowling requirements :
1 Auto load Tcode, with each unique transaction code sent to the transaction tab. The users will Code all uncoded transactions and have the new codes update to Tcodes tab on the fly.
2 Makings the tCode olny read the first 11 digits only.
3 A resets to Zero clean sheet button. On main sheet
4 Email for Statisaics reaserch button, On Main sheet. This should Email me a data file .csv that can be loaded as database or excell. Containing a Tcode coulm, Transaction amount coulm and a Date coulum.
5 the old chart graph needs to be fixed so all Tcobdes can be selected and graphed.
I need this Finnished before end of November.