Hi...
i made a invoice sheet for generating bills but i want to save each record that fills up in these sheet to be saved on other sheet as a database ...
i don't know how to do this...
can any one help me for these...?
plz refer my attached invoice workbook...
thanx in advance
So if i understand you clearly, you want each record of "each" invoice to be stored right?
Do you have a format in mind in which you would like to store this data?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
yes .. you got me right ...
but i don't have any idea right now...
one more thing..
but each invoice may have more than one product..
and i want to store each product for same customer....
Would your invoices be stored as separate sheets in the same file or separate files with one sheet each?
It wu'd be stored in one sheet ..
having one cusomer name/id, date generated and all items descriptions....
then next customer and so on......
So you mean that each invoice would be stored in a separate xlsx file with only sheet containing the invoice?
no...no
all data would be only on a single sheet.... for all customers...
so that its easier to search every time with ctrl+f key...
i want to create a backup of how many invoice are created.... on a SINGLE SHEETS
Ok, so there are multiple invoices on 1 sheet. Are there multiple files like these stored in a folder?
thank for your response.....
but i think the backup should looks something like the file i attached...
Yes, to be able to work out the macro for you, you will need to answer the question given in post 8.
yes...
there is multiple invoice record on one sheet ..
but i don't understand why you asked for multiple files stored on folder or not..?
in my invoice workbook there will be on more sheet named backup which contains backup for all invoices created..
Ok. So you just want to make a backup of invoices in that particular file? Not all the invoices you have?
invoices are created at run time and at same time that entry would be ....
....stored on a backup sheets and invoice get blanked for next entry..
and after each entry records are stored in back file...
that's all i wanna do with help of VBA...
if you can help me i'll be very thank-full to you....
Sure. Do you want the invoice backup to be part of the invoices file or a separate file?
I think it must be on same file but if you think its not a right approach then plz tell me....
i put it in separate file...
It depends on what you need the backup for.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks