Need Smooth VBA Code for the Output i want.

[sanmaya]

Hi All,

i need a VBA code for the output i need.

Please find the attached sample data file for your reference. this data file have two tabs, input and output.
input tab contains the data and output tab have the output for the input data.

Thanks .

 

[Smallman]

Sanmaya

Your two tabs;

• Output Data
• Output

are confusing in relation to your question. If I were to guess I would say Output Data is the tab that is meant to be the Input tab. If this is the case then a pivot table and not VBA is the way to go IMO.

Attached is a pivot table example.

Take care

Smallman

 

[sanmaya]

Smallman, Thanks for your Idea,

But if you carefully see the Output data, i need the 12 months number as header, and that cant not be possible with pivot.

the code should just put the products qty in respective months.

 

[Smallman]

Hi Sanmaya

That is easily avoided if you think about setting your input data up intelligently. Example attached showing how a pivot table can show all dates.

Or alternatively you could just use formula also in the example. I don't think VBA is the way to go for relatively routine Excel problems.

Take care

Smallman