any help needed

[Excelhurtsmybrain]

Hi there ive almost finished making a bike hire system where i select a specific type of bike and the hire duration as well as entering the customers details in and veryfying them

on a seperate sheet i need basically a database of all the transactions throughout a certain period (not specific)

i would think i need a button to transfer the data across to the other sheet but thats hard enough with the addition of having to format the data in the new sheet aswell with headings: transaction number, hire charge, cycle type, hire duration, identity verified and then all the data below those headings

the tricky bit here is formatting the data to apear in an specific order in the new sheet

i think i have some sort of idea but im not used to using visual basic with excel just more by itself

any help would be appreciated just to get me started and in the right path to finishing this thank you

 

[jim may]

If you will post a small sample of your data set up (including all sheets) then I think you will get a response.