Macros in Excel

Microsoft Office excel 2003
September 28, 2010 at 07:11:18
Specs: Windows Vista
I want a macro code for this :

My data starts from 8th row In my C column I have some values(AB,JK,LI,HJ,YJ,GY.......) .Corresponding to this in my D column I have some values(eg.A,B,C,D,E,F,.......) Then from my G column onwards I have all the values from D columns like A1(G Column),A2(H Column),A3(I Coulmn)then B1(J Column),B2(K Column)..C1(L Column)C2(M Column)...............

I want an output in anoth workbook of the same sheet like:

A column should contain the heading of C column(of raw data provided above) and lists each of value starting fron AB,JK,LI,HJ,YJ,GY.......Now for AB value (If the value in D column(of Raw Data) is A then it goes to A1 if finds a value in A1 and A2 then sums me the count of 2 and gives me output in B column(Macro data)

See More: Macros in Excel

Report •

September 28, 2010 at 12:21:42
Why are we getting so many posts in this forum where posters just spew out what they want or need and never actually ask for help?

It's seems that it's happening more and more lately.

Would you walk into a co-worker's office and just blurt out what you want or would you be a bit more polite and possibly toss in a "Please" and "Thank you" along the way?

Why do some people lose all of their social skills when posting on the internet?

Report •

September 28, 2010 at 21:43:43
Yes I think I should have been more polite.I admit.Sorry for that .....

Report •

Related Solutions

Ask Question