JBeaucaire
Forum Guru

Hi Guru, Can you plese help me with this post "Thread: Need to show summary result for each country seperatly in one sheet", I have been trying to get help and having hard time with it.. it would be really great if u could have a look at it

how to split the data with multiple sheet to multiple workbook based on coloum




if sheet 1 has many data and also given the name chetan raj amit
and sheet 2 has given in pivot table who is linked in sheet1
and sheet 3 has given in chart who is linked in sheet1

then what should i do in this case
simple save as and delete the data

i need 3 workbook
1 chetan workbook with 3 sheets( 1 data, 2 pivot table, 3 chart)
2 raj workbook with 3 sheets ( 1 data, 2 pivot table, 3 chart)
3 amit workbook 3 sheets ( 1 data, 2 pivot table, 3 chart)


so can u help me
of this matter
any vb code

I have a quick question about your copy data into a template macro. It only works to put one row of data into x number of templates created based on the number of rows in a database. Is there a way to make it work for several rows with a particular set of criteria?

I need to copy data from a database into a template i have on a "template" tab, while creating the multiple sheets based off of unique Column A entries in the database. With that said, if several rows have the same column A entry, i need those rows to populate into the templates created by the macro.

I've seen your work and it really is amazing! I really appreciate your help if you have a moment.

Hi JBeaucaire

Thank you ever so much for the help you gave me yesterday here:

http://www.excelforum.com/excel-prog...ror-found.html

I have a problem using it with the proper workbook would you be able to take a look and see whats wrong with it if I send a link to the workbook here. Its too big to post as an attachment.

Thank You

Ortz

Hi JBeaucaire ,

Based on your reputation, I was hoping you could help resolve a fairly prolonged issue. I have attached the link below. I know that we are not too far from the solution, but still can't seem to get there.
Your help would very much be appreciated.

http://www.excelforum.com/excel-prog...ly-data-2.html

Thanks,

A X L

JBeaucaire, is there no other way to make your code work here?

Thanks for the reputation. Appreciate it.

Hi,

You were a great help previously and was hoping you would be able to nail this problem I have on the head. I did give it a go myself, from details you had previously helped me with, but my lack of knowledge of what you did regarding a 'dynamic named range' has stumped me!

I have put my query up on the forum here:
http://www.excelforum.com/excel-gene...65#post2700665

Any help would be very much appreciated.
Cheers
Glenn

Thank you for the rep!

Hi JB,

Could you please see if you could assist me:

http://www.excelforum.com/excel-gene...ste-macro.html

Thank you