D
discman
hi i am trying to build a program for basic accounting based on an ol
dos program which i used to own 12 years ago!
i cant find it anymore so im trying to build this program in excel an
i have most of the work done but i need help sorting the basic data
all the framework is there for inputing the data around a cashboo
principle using item codes as keys for manipulating the data later on
trouble is i dont know how to do the manipulating to get the seperat
data out and sorted
email me at [email protected] and ill give you details if you
interested in helping me out
thanks heres a picture of the table page that i need to extract dat
from to another page
http://www.beaskitchen.co.uk/images/table.gif
the two columns (cat 1 and cat 2) store the codes that the user ha
initially entered into the setup screen, and they are repeated at th
top of the register page as a reminder to the user.
what i need is to make the list auto sort itself by date and if
needed to say extract the takings data to another worksheet i would us
the code TC (takings cash) to sort the data, similarly
to sort the data for andys cooked meats (ACM) i would use the code t
first check that it is a cash expenditure EC (expense cash) and the
search by supplier (ACM) for andys cooked meats or vice versa o
another supplier. i know its really complicated this but i woul
appreciate some help with this.
as my accounts are due shortly LOL
discma
Attachment filename: table.gif
Download attachment: http://www.excelforum.com/attachment.php?postid=51594
dos program which i used to own 12 years ago!
i cant find it anymore so im trying to build this program in excel an
i have most of the work done but i need help sorting the basic data
all the framework is there for inputing the data around a cashboo
principle using item codes as keys for manipulating the data later on
trouble is i dont know how to do the manipulating to get the seperat
data out and sorted
email me at [email protected] and ill give you details if you
interested in helping me out
thanks heres a picture of the table page that i need to extract dat
from to another page
http://www.beaskitchen.co.uk/images/table.gif
the two columns (cat 1 and cat 2) store the codes that the user ha
initially entered into the setup screen, and they are repeated at th
top of the register page as a reminder to the user.
what i need is to make the list auto sort itself by date and if
needed to say extract the takings data to another worksheet i would us
the code TC (takings cash) to sort the data, similarly
to sort the data for andys cooked meats (ACM) i would use the code t
first check that it is a cash expenditure EC (expense cash) and the
search by supplier (ACM) for andys cooked meats or vice versa o
another supplier. i know its really complicated this but i woul
appreciate some help with this.
as my accounts are due shortly LOL
discma
Attachment filename: table.gif
Download attachment: http://www.excelforum.com/attachment.php?postid=51594