Hi, I have this question..
I have 5 line with same part no ( different country)
so I apply subtotal to sum up the part no.
After running the function.. it left only 4 country..
Example:-
Part NO: Country QTY
ADS1234 US 10
ADS1234 ANZ 10
ADS1234 ASIA 10
ADS1234 INDIA 10
ADS1234 CHINA 10
TOTAL : 50.
after running the subtotal
Part NO: Country QTY
ADS1234 US 10
ADS1234 ANZ 10
ADS1234 ASIA 10
ADS1234 CHINA 10
SUbtotal : 40
how to fix this.. i have alot to do if i need to check 1 by 1
Please help
Do you mean, you run macro?
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks