Macro needed for varying number of rows

There are 202 different Publishers (column AM) each with a varying number of rows.

Can you develop a macro that will take all the rows of each Publisher and save it as a separate Excel doc? So would end up with 202 different files.

I've attached an example of how it would look for "Aaron LeClair CC", ideally with the header rows and blue total row too but not essential.

I will need to be shown how to do this so I can do it myself on other documents.

Compétences : Excel, Traitement de Données, Excel Macros

en voir plus : macro needed, crystal report number rows, excel macro needed, excel macro count number of rows, excel vba create table from dynamic range, excel vba select range with variable number of rows, dynamic range vba, vba select range to end of data, excel vba select range with variable number of rows and columns, excel vba dynamic named range, excel vba dynamic range based on cell value, macro input data number already used excel, vba macro clean telephone number format, outlook macro vba phone number, excel macro print invoice number, outlook macro contact phone number, gridview aspnet number rows, joomla change number rows columns table, outlook 2003 macro move phone number, photoshop header example

Concernant l'employeur :
( 0 commentaires ) Hayes, United Kingdom

Nº du projet : #27326026

Décerné à:


Hi, I am Swarnali, available online more than 16 hours everyday. I have read your project details. You want to create 202 different file based on publisher name. I can create a macro that will create 202 excel file b Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% GBP en 1 jour
(12 Commentaires)

13 freelances font une offre moyenne de 72 £ pour ce travail

(244 Commentaires)
(433 Commentaires)
(119 Commentaires)

Hi tjnsd, Lets Get Started With This right Now……This is pretty straightforward task……and I can do this as u want it done…..i will develop a macro for u and will tell u how u can do this by ur own, kindly message me to Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(86 Commentaires)

Hi there, I can create macro for you that will take all the rows of each Publisher and save it as a separate Excel . I have 10+ years of experience in Excel VBA, creating complex automation tools, formulas, databases Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(49 Commentaires)

Hello, I can help you creating the macro to separate the file in different files, please send me a message and I can start working on it inmediately

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(34 Commentaires)

i can do This manually if you need .i have read your project detail and ready to work.i have relevant skills and experience for this project. Please review my profile and inbox me. Thanks Abdul Haleem

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(28 Commentaires)

--------------------I CAN START RIGHT AWAY 100% ACCURACY-------------------------------- Hello sir, I have read your project details . I can Automated Data Analysis via Excel spreadsheet by maintaining 100% accuracy Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(3 Commentaires)

Hi Sir/Madam, I am a Technical analyst who specializes in VBA automation and I have 10 years' experience in it. I have gone through the posted file and understood the requirement that you require a tool that helps yo Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(2 Commentaires)

• I am very good at Excel and building up formulas that automatically carry calculations. Let's discuss your requirements in more details. Send me a message and will be happy to help you out.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(0 Commentaires)

Am pure finance and accounting freelancer with professional accountancy qualification and on good understanding of Microsoft office. i have Certificate in computer applications with knowledge of Excel an word. i have a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(0 Commentaires)

Hello, Hope you are doing well. I was reading your problem statement and I would like to solve this problem by using macro (VBA). This macro will be totally dynamic and will automatically export data whenever you make Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(0 Commentaires)