excel help needed

hafizghafoor72

New Member
Joined
May 23, 2015
Messages
2
Dear Community,


I just want to know that how can i do this in excel sheets.


" working with some chemicals bills which have 2% sales,17% sales tax,some 16% ...
By adding in a list of all entries which almost more than 200 in every months..I want to automate my some work.I also need these bill in a diffirent sheets by categories like 2% all bills in diffirent sheet and 17% in diffirent sheet and so on..


example....


I enter my first bill of May 2015 2% with 1000 quantity in master file.
second bill 2% with 500 quantity,
third bill is 17% with 15 quantity,"




what to do? If i want to categories automatically in diffirent sheets.




I hope you understand.


any help appreciated.
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,195,682
Messages
6,011,132
Members
441,586
Latest member
rodsin76

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top