vba to create pivot from 2rawdata to 2different sheet

[johnmacpro]

Dear expert

I have two raw-data from TexMarket and FoxMarket from which create two pivot in one sheet and another two pivot in another sheet.

main requirement is once first pivot1 table done i want create another pivot after 10 rows down in both sheet

find the attachment

[johnmacpro]

Any experts help on this

[johnmacpro]

any experts Need your preference on my thread!!

[Kaper]

Hi johnmacpro,

It has come to our attention you have violated Rule 4 of our Forum RULES. Don't Private Message, Visitor message or email Excel questions to moderators or other members. (Or Access, Word, etc.)
All questions and answers will benefit other posters like yourself when discussed in public threads. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.
Breaking this rule is considered harassment by most of our contributors and thus cannot be tolerated. Repeat offense could lead to permanent ban, so do take this caution to heart.
Post your question in a public thread and our many contributors will come to you to assist, especially if the title is accurate (see Rule #1) and you include a sample desensitized workbook that makes it easy for others to try and help.


In my personal opinion private messages that you started a thread on the forum also compromises rule 4.

If you want to focus attention on your thread post it in http://www.excelforum.com/commercial-services/

[johnmacpro]

sorry sir forgive my ignorance please can u help my thread!!

[johnmacpro]

Any experts would solve?