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: script count number jobs, free vba script macro, sql script count record sequence row, 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, software testing, sql, excel, visual basic, microsoft, microsoft office, microsoft access, visual basic for apps, debugging

Tentang Majikan:
( 39 ulasan ) Halstenbek, Germany

ID Projek: #15269617

109 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
(618 Ulasan)
8.3
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
(180 Ulasan)
7.5
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
(272 Ulasan)
7.5
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
(276 Ulasan)
7.2
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
(207 Ulasan)
6.8
€120 EUR dalam 3 hari
(133 Ulasan)
6.7
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
(162 Ulasan)
6.7
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
(159 Ulasan)
6.9
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
(170 Ulasan)
6.5
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
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
(120 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
(37 Ulasan)
6.4
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
(325 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
(72 Ulasan)
6.0
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
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
zu02

Hi I hope all's well with you. I see you're looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. Would you like to have it via Ms Access Lagi

€83 EUR dalam 2 hari
(32 Ulasan)
5.8
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
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
(80 Ulasan)
5.7
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
(54 Ulasan)
5.7