Userform for medical store or super market

hay,
i am tray to create user form for make bill format for super market example if enter in text box the item name etc. then add data in to excel sheet with excel formulas and if customer buy more then one item when enter another item name in to text box it's need to go with same bill number and when search with bill number it's need show all carrying with that bill number and we can print bill fromat paper, please some one help me, if give me another example to make bill of bunch items

thank you,

Hi blk and welcome to the forum.

Micorosoft has example Invoice Templates on their website. Find some examples at:
http://office.microsoft.com/en-us/te...010117274.aspx

I believe you are looking for a full application using Excel. Perhaps some of our members will be willing to spend much more time than simply helping you with a simple formula or two.

Hi blk,

I'm so sorry, but you didn't understand my answer. Without an example from you or a lot more information and exactly what you are starting with and what you want to arrive at, I can't help you. I suggest you find someone who can contract time to build what you are wanting.

Hi blk,

I added some sales to your table and 2 more salespeople. I created a list of products you sell and put the price to the right so it would be easier to fill in the individual sales. Study Sheet 1 for formulas that do this. You will also need to find Data Validation.

Then I created a few Pivot Tables for you, as you are going want to know how much each invoice was and how much you made at the end of a month or week. I also did a sample pivot to show this by salesperson.

On sheet 2 there is an Advanced Filter. You will put the customer/invoice number in cell A2 and press enter. All the correct transactions from sheet 1 will then appear on sheet 2. This is the one I expect you will want to pretty up and make an invoice from.

There is a lot here to study and learn, but this is the direction I would be going if I had a small market and was selling stuff. I'm old and no longer can work so I do this for fun instead.

I hope this helps you get started in your business.

blk
why have you attached habeeb workbook?

Hi blk,

I'm so sorry, I created and thought I attached a workbook. Here it is again.

I think you are using two IDs, your IP addresses are almost identical.

hello, MarvinP

thank you for assistance, that was very help for me, i created one sheet i attached that file please check that out, when i run advfilter it's showing error massage like " run-time error '1004': and method 'range' of ' object '-Global' failed and then if i click debug it's highleting the bellow code. please can you explaine about this VBA code of that file you were sent me.

Range("SalesStuff").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:= _
        Range("A1:G2"), CopyToRange:=Range("A6"), Unique:=False

thank you for helpling.

Hi blk,

It looks like you are getting close to doing this without our help.

The reason for the error is that I wrote the AdvFilter subroutine to work on the workbook I attached. It had a sheet named "SalesStuff". You don't have a sheet named this on your example so the code is lost. If you want to use my code you need to understand it enough to modify it to work with your sheet names. I gave it to you as an example of what you might do. It was never intended to work on any workbook, only one with the correct sheet name and criteria range. You will need to do a few Advanced Filters by had to understand the code I wrote also.

hope this helps.

thank you very much, it's working now

thank you.........

Hi blk,
The problem is that the names of the columns must be spelled EXACTLY the same in the
Data and Criteria Ranges.
On sheet1 you have:

Bill no Item code per pic Qty Total excutive Date & Time

and on Sheet 2 you have:

bill no. item code per pic qty total excutive date and time

Make the cells A1 to G1 on Sheet2 the EXACT same as Sheet1 and it should work fine.
Better yet, copy cells A1:G1 from sheet1 and Paste them to A1 on sheet2.

It just likes someone tried to make the Sheet1 row 1 better looking. When they did this it no longer matched the row 1 on sheet 2.

hi blk,
see if it helps!

hello, Mr.MarvinP

can we do like hide Entire row until it's value 0 or empty row,
thank you for your assistance.