i want vba code for below concept any one hlp me

April 16, 2016 at 03:46:45
Specs: Windows 7
Year WEEK BUYER BUYER NAME City HQ1 HQ1 APPLE FROOTI MONGO BANANA
2015 Week-01 113 1 Arantangi TRICHY Tiruchirappalli 5 0 0 0
2015 Week-01 130 2 Kodaikanal TRICHY Tiruchirappalli 0 30 0 0
2015 Week-01 161 3 Nagapattinam TRICHY Tiruchirappalli 0 0 0 0
ASP Week-01 113 1 Arantangi TRICHY Tiruchirappalli 5 0 0 0
ASP Week-02 130 2 Kodaikanal TRICHY Tiruchirappalli 0 30 0 0
ASP Week-01 161 3 Nagapattinam TRICHY Tiruchirappalli 0 0 0 0
2016 Week-02 324 4 Tiruppuvanam MADURAI Madurai 4 2 0 5
2016 Week-01 352 5 Tenkasi MADURAI Madurai 3 10 20 5
2016 Week-01 401 6 Kamudi MADURAI Madurai 7 4 0 0


this is my data i want

criteria
Year 2015
WEEK Week-01
BUYER 113
BUYER NAME 1
City Arantangi
HQ1 TRICHY

output :

APPLE FROOTI MONGO BANANA
10 0 0 0
0 0 0 0
0 30 0 0
0 30 0 0

am writing vba code showing some error any one help

message edited by gurusivakumaran


See More: i want vba code for below concept any one hlp me

Report •

#1
April 16, 2016 at 03:48:26
i want summary only

am using sumifs(choose(match())), in excel but i want to VBA for this concept

anyone help me


Report •

#2
April 16, 2016 at 11:44:41
Please click on the link at the bottom of this post and read the instructions on how to post data in this forum. Then please edit your post or repost your data so that the columns line up and it is easier for us to read. In addition, please include Row numbers and Column letters so we know what range your data is in. Thanks!

Now, as for your requirements, I have a couple of questions:

First, I don't see how the "Criteria" list will give you the output you posted. For example, the only way I get Apples = 10 is to ignore some of the criteria, such as Year 2015.

If I include Year = 2015, I will only get Apples = 5 for BUYER = 113. I would need to include the ASP criteria in order to get 10, but you don't list that in your Criteria.

How are we supposed to know what Criteria to use and what to ignore?

Second, you said: "am writing vba code showing some error any one help "

Would it possible to post that code? Maybe you are close to having what you want and just need to have the error fixed. There's no sense in us starting from scratch if you already have code that just needs a little tweaking.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
April 17, 2016 at 07:45:55
Year WEEK BUYER BUYER NAME City HQ1 HQ1 APPLE FROOTI MONGO BANANA
2015 Week-01 113 1 Arantangi TRICHY Tiruchirappalli 5 0 0 0
2015 Week-01 113 1 Arantangi TRICHY Tiruchirappalli 0 30 0 0
2015 Week-01 161 3 Nagapattinam TRICHY Tiruchirappalli 0 0 0 0
ASP Week-01 113 1 Arantangi TRICHY Tiruchirappalli 5 0 0 0
ASP Week-02 130 2 Kodaikanal TRICHY Tiruchirappalli 0 30 0 0
ASP Week-01 161 3 Nagapattinam TRICHY Tiruchirappalli 0 0 0 0
2016 Week-02 324 4 Tiruppuvanam MADURAI Madurai 4 2 0 5
2016 Week-01 352 5 Tenkasi MADURAI Madurai 3 10 20 5
2016 Week-01 401 6 Kamudi MADURAI Madurai 7 4 0 0


this is data ok !!!!! don't confused


i want summary for

YEAR WEEK APPLE FROOTI MONGO BANANA
2015 Week-01 5 30 0 0


Report •

Related Solutions

#4
April 17, 2016 at 07:47:12
i want sum the value

Report •

#5
April 17, 2016 at 10:07:21
We still don't know what your data looks like,
did you read the HOW-TO that DerbyDad suggested?
It shows you how to use the < PRE > tags to align your data so we can copy
it into our own spreadsheet.
That way we are both working with the same data.

When I copy/paste you data into a spread sheet I get this:

      A     B       C     D      E            F             G        H    I      J     K     L
 1) Year  WEEK    BUYER BUYER NAME          City           HQ1      HQ1 APPLE FROOTI MONGO BANANA
 2) 2015  Week-01  113    1   Arantangi     TRICHY  Tiruchirappalli  5    0     0      0     
 3) 2015  Week-01  113    1   Arantangi     TRICHY  Tiruchirappalli  0    30    0      0     
 4) 2015  Week-01  161    3   Nagapattinam  TRICHY  Tiruchirappalli  0    0     0      0     
 5) ASP   Week-01  113    1   Arantangi     TRICHY  Tiruchirappalli  5    0     0      0     
 6) ASP   Week-02  130    2   Kodaikanal    TRICHY  Tiruchirappalli  0    30    0      0     
 7) ASP   Week-01  161    3   Nagapattinam  TRICHY  Tiruchirappalli  0    0     0      0     
 8) 2016  Week-02  324    4   Tiruppuvanam  MADURAI Madurai          4    2     0      5     
 9) 2016  Week-01  352    5   Tenkasi       MADURAI Madurai          3    10    20     5     
10) 2016  Week-01  401    6   Kamudi        MADURAI Madurai          7    4     0      0     

Please take a few minutes to read the HOW-TO and post your
data in a form we can use.

MIKE

http://www.skeptic.com/


Report •

#6
April 17, 2016 at 22:57:34
i have two sheets in my workbook

1st sheet summary sheet .
2nd sheet is data sheet

example :
A B C D E F G H I J
Year WEEK BUYER NAME City HQ1 APPLE FROOTI MONGO BANANA
2015 Week-01 1 Arantangi TRICHY Tiruchirappalli 5 0 0 0
2015 Week-01 2 Arantangi TRICHY Tiruchirappalli 0 10 0 10
2015 Week-01 1 Arantangi TRICHY Tiruchirappalli 0 5 5 5
2015 Week-02 1 Arantangi TRICHY Tiruchirappalli 0 0 0 0
2015 Week-02 1 Arantangi TRICHY Tiruchirappalli 1 2 3 4
2015 Week-02 1 Arantangi TRICHY Tiruchirappalli 5 6 7 8
ASP Week-01 1 Arantangi TRICHY Tiruchirappalli 10 5 5 0
ASP Week-01 2 Arantangi TRICHY Tiruchirappalli 5 7 9 11
ASP Week-01 1 Arantangi TRICHY Tiruchirappalli 20 30 4 0
ASP Week-02 1 Arantangi TRICHY Tiruchirappalli 5 4 3 2
ASP Week-02 1 Arantangi TRICHY Tiruchirappalli 1 2 3 4
ASP Week-02 1 Arantangi TRICHY Tiruchirappalli 11 55 66 44
2016 Week-01 1 Arantangi TRICHY Tiruchirappalli 5 5 5 5
2016 Week-01 2 Arantangi TRICHY Tiruchirappalli 0 10 0 10
2016 Week-01 1 Arantangi TRICHY Tiruchirappalli 0 5 5 5
2016 Week-02 2 Arantangi TRICHY Tiruchirappalli 0 0 0 0
2016 Week-02 1 Arantangi TRICHY Tiruchirappalli 1 2 3 4
2016 Week-02 1 Arantangi TRICHY Tiruchirappalli 5 6 7 8


now go to summary sheet :

already am created data validation for BUYER ,CITY,HQ1,NAME,

when i select the list automatically show below summary

Year Week APPLE FROOTI MONGO BANANA
2015 Week-01 5 15 5 15
ASP Week-01 35 42 18 11
2016 Week-01 5 20 10 20
2015 Week-02 6 8 10 12
ASP Week-02 17 61 72 50
2016 Week-02 6 8 10 12

please help me

could you please share your mail id

i ill send my working book

message edited by gurusivakumaran


Report •

#7
April 17, 2016 at 23:00:32
A B C D E F G H I J
Year WEEK BUYER NAME City HQ1 APPLE FROOTI MONGO BANANA
2015 Week-01 1 Arantangi TRICHY Tiruchirappalli 5 0 0 0
2015 Week-01 2 Arantangi TRICHY Tiruchirappalli 0 10 0 10
2015 Week-01 1 Arantangi TRICHY Tiruchirappalli 0 5 5 5
2015 Week-02 1 Arantangi TRICHY Tiruchirappalli 0 0 0 0
2015 Week-02 1 Arantangi TRICHY Tiruchirappalli 1 2 3 4
2015 Week-02 1 Arantangi TRICHY Tiruchirappalli 5 6 7 8
ASP Week-01 1 Arantangi TRICHY Tiruchirappalli 10 5 5 0
ASP Week-01 2 Arantangi TRICHY Tiruchirappalli 5 7 9 11
ASP Week-01 1 Arantangi TRICHY Tiruchirappalli 20 30 4 0
ASP Week-02 1 Arantangi TRICHY Tiruchirappalli 5 4 3 2
ASP Week-02 1 Arantangi TRICHY Tiruchirappalli 1 2 3 4
ASP Week-02 1 Arantangi TRICHY Tiruchirappalli 11 55 66 44
2016 Week-01 1 Arantangi TRICHY Tiruchirappalli 5 5 5 5
2016 Week-01 2 Arantangi TRICHY Tiruchirappalli 0 10 0 10
2016 Week-01 1 Arantangi TRICHY Tiruchirappalli 0 5 5 5
2016 Week-02 2 Arantangi TRICHY Tiruchirappalli 0 0 0 0
2016 Week-02 1 Arantangi TRICHY Tiruchirappalli 1 2 3 4
2016 Week-02 1 Arantangi TRICHY Tiruchirappalli 5 6 7 8




BUYER : ALL
City : ALL
HQ1 : ALL
NAME : ALL

Year Week APPLE FROOTI MONGO BANANA
2015 Week-01 5 15 5 15
ASP Week-01 35 42 18 11
2016 Week-01 5 20 10 20
2015 Week-02 6 8 10 12
ASP Week-02 17 61 72 50
2016 Week-02 6 8 10 12

message edited by gurusivakumaran


Report •

#8
April 18, 2016 at 04:04:19
Please upload your workbook to zippyshare.com and then post the link back here in the forum.

Make sure that there is no personal or confidential data in the workbook before uploading.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#9
April 18, 2016 at 05:58:35

Report •

#10
April 18, 2016 at 20:17:56
Please upload an Excel file, not a rar file. I do not want to download/buy a utility just to open your file, especially since I really don't know what you uploaded.

If you want our help, please make this as easy for us as possible.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#11
April 18, 2016 at 20:24:48
hi ,

please find the excel file

http://www111.zippyshare.com/v/lOo2...


Report •

#12
April 19, 2016 at 01:55:48
any update on this

Report •

#13
April 19, 2016 at 06:04:58
I will not be able to look at your file until this evening, EST.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#14
April 19, 2016 at 14:56:30
I have looked at your file but I have no idea what you are trying accomplish.

You will have to explain it in detail.

What do you want me, acting as the user, to do?
After the user does whatever it is that you want the user to do, what do you expect the result to be?

Step by step instructions, followed by the exact, expected results would be helpful.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question