• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Smooth VBA Code for the Output i want.

sanmaya

New Member
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 .
 

Attachments

  • Sample data file.xlsx
    15.4 KB · Views: 2
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
 

Attachments

  • Sample data file.xlsx
    18.1 KB · Views: 3
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.
 
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
 

Attachments

  • Sample data file (1).xlsx
    20.2 KB · Views: 3
Back
Top