Suoritettu

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.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Visual Basic, Visual Basic for Apps

Näytä lisää: 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

Tietoa työnantajasta:
( 20 arvostelua ) Salmiya, France

Projektin tunnus: #18808997

Myönnetty käyttäjälle:

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 Lisää

$15 AUD 0 päivässä
(460 Arvostelua)
6.9

11 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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.

$25 AUD 1 päivässä
(81 arvostelua)
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

$25 AUD 1 päivässä
(9 arvostelua)
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 Lisää

$25 AUD 1 päivässä
(3 arvostelua)
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 Lisää

$20 AUD 0 päivässä
(10 arvostelua)
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 Lisää

$15 AUD 2 päivässä
(2 arvostelua)
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 Lisää

$27 AUD 1 päivässä
(0 arvostelua)
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 Lisää

$15 AUD 1 päivässä
(0 arvostelua)
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 Lisää

$25 AUD 1 päivässä
(0 arvostelua)
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.

$25 AUD 1 päivässä
(0 arvostelua)
0.0
Sipiya1

I am good in Excel

$25 AUD 1 päivässä
(0 arvostelua)
0.0