Please help create a macro

[sujith849]

Hello Sir(s),

Please help create a macro which copies data from pivoted table to other sheet

Raw data is provide and the macro need to summarise the raw data per vendor and copy it to the next sheets

Please help immediately as i a beginner in excel macros and this is killing my time (5 hrs per day) for copy pasting .

Thanks for your help in advance

-Sujith

[TMS]

Not sure why you would want to use a macro to create and maintain potentially hundreds of worksheets for each of the vendors. You could just create one Pivot table and filter on one or more vendors.

If you wanted a macro, you could loop through the vendors and change the PT filter to select the vendors in turn.

Please see the attached updated sample workbook.

Regards, TMS

[sujith849]

Hi Trevor,

First of all, Thank you so much for your time to reply for my thread. The reason why i want a macro is that, i need to create separate journal lines for each vendor(Group wise) to upload on to the Accounting software that we use (Microsoft Dynamics NAV. For which i am using another macro which will in-turn convert the vendor wise data into separate journal lines.

EX:
Vendor xxx -1000
Stock Beverages -200
Stock kiosk - 500
Stock food -300

Hope you understand the concern

Thanks
Sujith

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[sujith849]

Any Chance Gys