Ditutup

VBA Script: Count Columns and create new row

Hi,

I have a file with 200 rows.

I need a script which does the following:

- Go through each row

- Delete all empty columns of a row

- Count all content of a row and if there are more than 30 columns then

- create a new row with the rest of the columns (if again above 30 columns then create a new row again)

Kemahiran: Excel, Excel VBA, Visual Basic

Lihat lagi: excel vba count rows with specific data, range row count vba, excel vba count rows with data in column, vba count columns, excel vba count rows in range with data, vba rows.count end xlup, excel vba insert row below, excel vba count rows in sheet, google apps script create new spreadsheet, outlook vba script create meeting, vba script create xml file, create image thumbnails vba script, website script count files folders, access vba query count script, create user name password microsoft access vba script

Tentang Majikan:
( 39 ulasan ) Halstenbek, Germany

ID Projek: #15269617

112 pekerja bebas membida secara purata €79 untuk pekerjaan ini

jaylancer43

Hello Sir, Thank you for this opportunity. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Lagi

€150 EUR dalam 2 hari
(573 Ulasan)
8.2
Webxpert4u

Hello, I can create a Python script/Macro which will delete all empty rows in excel and will count the all cells of a rows if there are more than 30 cells.. Highly experienced in Excel Programming, Excel automation Lagi

€200 EUR dalam 3 hari
(153 Ulasan)
7.3
schoudhary1553

Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done Lagi

€180 EUR dalam 3 hari
(237 Ulasan)
7.4
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

€50 EUR dalam sehari
(191 Ulasan)
6.8
aarifakhtar

Hi: I can create a macro (VBA) script which would go through the rows and create more rows in case there are more than 30 columns. I am Excel expert. Please review my profile (https://www.freelancer.com/u/aarifakhtar) Lagi

€50 EUR dalam 2 hari
(157 Ulasan)
6.9
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with this script. Please check my profile and contact me to discuss.

€50 EUR dalam sehari
(258 Ulasan)
7.0
ksriniravi

Greetings! Thanks for being very clear about your requirement - requirement is straightforward and easy to implement. I can write a macro that meets your requirement. I have 18 years experience in using Excel as Lagi

€30 EUR dalam sehari
(148 Ulasan)
6.6
€120 EUR dalam 3 hari
(126 Ulasan)
6.7
katilinas

Hello. I can provide a VBA script which will count columns and create new row. I have 5 years experience in Excel VBA.

€93 EUR dalam 2 hari
(113 Ulasan)
6.4
sisicirnes

Hello! My name is Irnes and I'm a data entry/web search specialist from Bosnia and Herzegovina. I'm here to prove my skills and quality of the work. The Freelancer website gave me a preferred status. More than 95% Lagi

€50 EUR dalam sehari
(33 Ulasan)
6.3
pishty

Hi, I am interested in your project. Please provide the file you need the script created for. Thanks, Peter

€155 EUR dalam 3 hari
(51 Ulasan)
6.0
vano101

Hello. I have enough experience with Excel and VBA in order to complete this task in short time. Meantime I have few questions: 1) Should it shift data left when removing particular empty cell in middle of the row? Lagi

€30 EUR dalam sehari
(319 Ulasan)
6.3
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience and can do it with the required quali Lagi

€50 EUR dalam sehari
(157 Ulasan)
6.4
aanvikm

Hello Sir, I am a VBA expert and I can help you with this project. Please open chat to discuss more about this project and my approach. Also can you please share which excel version are you using? Thanks Aanvi Lagi

€222 EUR dalam 3 hari
(40 Ulasan)
6.3
MohsanEijaz

I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfe Lagi

€61 EUR dalam 3 hari
(69 Ulasan)
6.0
srikartiram

Hello, i'm an experienced VBA developer and full time freelancer. I can handle this project. I will be able to get this tool done to you in a few hours once the project is accepted. Awaiting for your most precious Lagi

€50 EUR dalam 5 hari
(106 Ulasan)
5.8
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible t Lagi

€39 EUR dalam sehari
(48 Ulasan)
5.5
mail2vimalarora

Hi, I have gone through your project details and can help out in getting vba script done as per your need which will function as per given instructions. I have worked on several vba/macro projects on excel and can han Lagi

€50 EUR dalam 0 hari
(69 Ulasan)
5.6
MoohHHooM

Hi, i can help you with this project, please let me know more about it :) .

€30 EUR dalam sehari
(31 Ulasan)
5.4
gatsu58

Hello, I am ready to start the work anytime. Price for the project is €30, fast delivery, complete in 2 days. Regards, Santos

€30 EUR dalam 2 hari
(120 Ulasan)
5.5