Excel - Store Management - Help Required - Please...

[Prasag2007]

Guyz...

I am new to this forum,

i want a programming in excel, i am attaching a file of excel, i have seven items in my mini store, monthly i will receive stock, i want to enter all stock in excel, i have prepared a table, i am attaching that file, i want auto balances when i sort the item wise list, and i want auto totals in page ending and space for signature, please help in this regard,

i will be very thankful to you in this regard.

thankx in advance...

[protonLeah]

This is a pretty big request in one chunk. I'm sure you'll get better response if you break down your question into several parts, so that they can be tackled one after the other.

Also, we're happy to help you with your effort, but nobody here will be keen on developing a solution from scratch. This forum is about helping people learn how to use Excel, not a free development service.

Have you started any work on this project yet?
How far did you get?
Where are you stuck?

We can help you develop your own code, but if you want someone to code this for you all the way, you should try and find a commercial developer.
-------------------------
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[Prasadg2007]

Actually, i am new to excel programming, i have tried in routine way, i have created the table, sorted the table, when i am sorting i am able to view sub totals but not column to column balences in each item, suggest me how can and where can from i should start...

thankx...

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.


Your title is unsatisfactory.

Your workbook is empty save the header row! You should have (must) post a workbook with the sample data that shows that you tried the SUBTOTAL function. No one wants to guess at what kind of data you are working with and build the sample data for you. Then you can ask for specific help with SUBTOTALs.

[Prasadg2007]

Sir,

I am attaching file with sample data....

thankx...

[royUK]

Why would you want to use VBA for this. Use inbuilt Excel features - probably a PivotTable

[Prasadg2007]

Sir,

I am not getting column to column balences when i sort item wise and date wise list in pivot table...

kindly know how to do with pivot table...

thankx in advance...

[jeffreybrown]

Hi Prasadg2007,

Not sure why you keep ignoring the fact you were asked to change your thread title, but from here on out before we can continue to help, please see the forum rules about proper thread titles and adjust accordingly...

If you need some more guidance check out posts # 2 and 4