Færdiggjort

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.

Evner: Excel, Databehandling, Excel Macros

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Hayes, United Kingdom

Projekt ID: #27326026

Tildelt til:

swarnali2017

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 Flere

£20 GBP på 1 dag
(12 bedømmelser)
3.7

13 freelancers are bidding on average £72 for this job

(244 bedømmelser)
8.0
(433 bedømmelser)
7.2
(119 bedømmelser)
6.5
rahul62544

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 Flere

£29 GBP på 1 dag
(86 bedømmelser)
5.6
ravinderkumar248

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 Flere

£20 GBP på 1 dag
(49 bedømmelser)
5.1
maguirrer

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

£27 GBP in 2 dage
(34 bedømmelser)
4.2
haleem0786

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

£100 GBP på 1 dag
(28 bedømmelser)
4.2
Mohilm007

--------------------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 Flere

£90 GBP på 1 dag
(3 bedømmelser)
3.2
ShivaniGoyalsai

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 Flere

£50 GBP på 1 dag
(2 bedømmelser)
2.2
expertswriting45

• 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.

£135 GBP in 7 dage
(0 bedømmelser)
0.0
patrickmwangi206

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 Flere

£135 GBP in 7 dage
(0 bedømmelser)
0.0
wakasarif

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 Flere

£30 GBP på 1 dag
(0 bedømmelser)
0.0