Terminé

Need a small easy macro on Excel to fill column

Hi,

It is a very super simple macro (button) I need.

I have an Excel file with let's say 60 columns.

Column 20 to 39 are regularly updated through an EXCEL add-on.

Let's say day 1 I have 60 columns and 500 lines.

After update, column 1 to 19 and 40 to 60 are STILL 500 lines but column 20 to 39 is now 750 lines.

So I manually select columns 1 to 19 and then 40 to 60 and I pull them down so that the formulas inside columns 1 to 19 and 40 to 60 can reach line 750.

I need a macro to do that automatically.

It is not that difficult I know.

Compétences : Saisie de Données, Traitement de Données, Excel, Visual Basic, Visual Basic pour les apps

en voir plus : vba excel column label, excel macro cells column name, excel macro export column text file, excel 2016 macro tutorial, how to create a macro in excel 2010, macros in excel for beginners, excel macros tutorial, excel macros for dummies, what is the use of macros in excel with examples, excel macro tutorial pdf, excel macro tutorial for beginners, excel column entry proper function vba macro samples, export excel column text macro, excel macro copy column, macro excel column line, excel macro sum column sheet, excel macro format column, excel macro increment column counter, excel macro loop column, excel macro group column

Concernant l'employeur :
( 20 commentaires ) Salmiya, France

Nº du projet : #18808997

Décerné à:

MimiFL

Hello, i believe i can code this for you in matter of minutes. If you are interested in working with me, please message me and i will try to help immediately. That being said, i've done this many times before, without Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% AUD en 0 jours
(460 Commentaires)
6.9

11 freelance font une offre moyenne de $22 pour ce travail

rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(81 Commentaires)
5.9
Walshie1987

Hi, Nice and easy one, I can do this for you ASAP :) I'm Chris from Sheffield in the UK and have over 10 years experience doing things like this. If you want to discuss further let me know Cheers Chris

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(9 Commentaires)
4.7
assignmentstore

Hello, I will help you out in this project. Being the most experienced freelancer on this platform I ensure you the exceptional quality work within the least possible time. Please drop me a message and we can sta Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(3 Commentaires)
3.5
KozlouAlex

Hello. Below are two my recently completted Excel VBA projects. All are with positive feedback. Excel VBA smart document update - https://www.freelancer.com/projects/data-entry/vba-excel-compare-count-sort/?w=f E Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(10 Commentaires)
3.6
Freelncer01

Hello! My name is Florian, and after seeing your listing I feel like we could collaborate well with each other on this project. I’m a Controller based in Berlin, Germany. My specialties are MS Excel and Data Managem Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(2 Commentaires)
2.7
maryumakhter5

I have worked on Web Data Mining- Web Harvesting- Email address and contact detail extraction from web- Web data collection- Plain data entry- JPG/PDF to DOC file- Entry in Excel/ACT- Link Exchange on the web. Data Tra Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
adnanbasheer4

Dear Hiring Manager, Hope you are fine and happy with your life. Before I start my letter I want to thank you for posting the job. In your job posting you are looking for a Data entry expert who knows every basic o Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
improgrammer009

Hello, I will help you out in this project. Being the most experienced freelancer on this platform I ensure you the exceptional quality work within the least possible time. Please drop me a message and we can sta Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
manishmariner103

i am a fresher. i will work for 4-5 hrs a day and will complete the given job on time. i will provide cheap and best work.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
Sipiya1

I am good in Excel

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0