Dear Sirs,
We have shoe factory daily basis we are cutting leather and taking monthly date wise cutting report/input/output/despatch pairs/balance to despatch report in one excel file.
How to use macro to run report. Pls see attached file.
Pls advice.
Regards,
SUN
You need a macro to create the pivot for you? Is that the report you are talking about?
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 sir but i need date wise monthly report in one sheet
It will be good if you provide a sample output file to show us what you are looking for.
yes see attached file
yes i have attached sample report for your ref.
arul sir are u thereeeeeeeeeee
What about data in col S to AB of your 2nd attachment? How should i populate it?
i do not know how to explain but i hope u got it
DR.SUN, please be patient. I will review it.
yes same as like cutting but i forget to insert pages for date if date 1st march in one row report should populate cutting/cut bal/input/input bal/output/output bal/despatch/despatch bal one by one for 2nd march 3rd march
can anyone help in this regard
dear friends can anyone help meeeeeeeeeeeeee
I am not able to understand. From where does the data come for columns S to AB? Also, how should i get the data for the daily production report? Based on what data?
You need to explain what steps you do manually which need automation. Only then, we will be able to help you better.
Last edited by arlu1201; 03-23-2012 at 05:26 AM.
yes columns s to ab only
Please explain properly Dr.SUN. You need to explain in detail regarding what report you require. Its not clear even with your expected output file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Dr.SUN 
Register To Reply
Bookmarks