Sedang Disiapkan

Excel Data filling macro

An excel macro is needed to run an automated task. A spreadsheet has data in it that is formatted like that show in the attached example file. Along each row there are Data cells, each of which is needed to fill out a separate row that is otherwise a clone of the initial row.

Example, a row that contains the following where each comma denotes a column (the relevant data is in capitals):

Fluffy bunny, pet collars, PINK, DIAMOND, CHROME, $12.96.

The macro should generate the following based on that

Fluffy bunny, pet collars, PINK, DIAMOND, CHROME, $12.96, PINK

Fluffy bunny, pet collars, PINK, DIAMOND, CHROME, $12.96, DIAMOND

Fluffy bunny, pet collars, PINK, DIAMOND, CHROME, $12.96, CHROME

The macro should be able to have its input & output cells defined. It should be able to deal with blank cells, where a blank cell does NOT generate a new row. The input data maybe 2 cells long or 200. Only the data used for the input should change when a row is generated, all the other information must be copied into the new rows.

There may be anything from 1,000 to 20,000 initial rows with unique input data. Please note that the initial row must NOT be left in place unchanged, it must be written to with the first Data or deleted so that with 3 initial Data entries there are 3 rows at the end, not 4 (the initial row & 3 newly generated) or it should be deleted when the macro finishes with that row & moves onto the next.

There is an example sheet attached to show you what it should look like. If you have any questions please ask & I will try to clarify any areas not understood.

Kemahiran: Visual Basic, Destop Windows

Lihat lebih lanjut: excel macro example filling cells, marco excel input data, excel fill macro, macro fill data, excel data input macro, input data macro, excel macro fill web form, excel data entry macro, macro filling data, excel macro fill empty cells, what is data input, that pet place, excel &, data 0, ask excel, data filling macro, excel macro filling, sample excel macro code filling excel sheets, excel filling blank cells using perl, making excel web form filling macro, macro input variables excel, excel data macro, excel macro input valuable, excel macro view row data form, excel data row macro

Tentang Majikan:
( 4 ulasan ) Brier, United States

ID Projek: #65196

Dianugerahkan kepada:

SachinBhatt

We have developed several such utilities in Excel.

$50 USD dalam 4 hari
(24 Ulasan)
4.5

28 pekerja bebas membida secara purata $46 untuk pekerjaan ini

NashTrump

Hi there, this is a very easy job and can do it very quickly. I am specialised in Excel, VBA, PHP, Perl, CGI, Mysql. Kind regards, Nash

$40 USD dalam 0 hari
(13 Ulasan)
4.4
CarlR

Not sure, but it sounds like you can use a macro (I've already created) that will fill empty cells (of a selected area of the spreadsheet), with the most recent (non-empty value) from above. Covering whatever columns a Lagi

$30 USD dalam 0 hari
(35 Ulasan)
4.2
ajay192

Hi, I propose a macro that open on a form where you specify the text, whether it is Input/Data and Do you want to add more. If you desire to add more, a new row will open up. If you decide to ‘Run Macro’, it will Lagi

$60 USD dalam 3 hari
(3 Ulasan)
3.6
Indunil

Hi Sir, I did it. Pls go to PMB to get it.

$55 USD dalam 0 hari
(1 Ulasan)
3.2
amanullahs

I can do this project. Can automate this task neat and clean.

$65 USD dalam 2 hari
(2 Ulasan)
3.1
Progmatics

VBA for MSExcel is my expertise.

$50 USD dalam 3 hari
(2 Ulasan)
2.8
kumartech

Hi, I fully understand your requirements and I can do your project to satisfaction.

$40 USD dalam 2 hari
(1 Ulasan)
1.8
malhanrakesh

i will make an exe for you. This will a gui application that will deal with any of open excel file and insert the content at desired position Just pm for more details or any questions you maynhave satisfaction Lagi

$40 USD dalam 2 hari
(1 Ulasan)
1.6
kmohan1962

Hello; I've a code ready to crack for your project. Regards. [url removed, login to view]

$30 USD dalam 0 hari
(2 Ulasan)
0.7
evrenera

i made it for you. little changes gratis.

$30 USD dalam 0 hari
(0 Ulasan)
0.0
jamisla

I can do the job, I have experience en VBA programming.

$40 USD dalam 2 hari
(0 Ulasan)
0.0
GDL2PRO

Hi I'm an experience coder but new to getafreelancer. I'm more interested now in earning a good review than a big amount of money. I can return your excel macro very fast and I would be online if you need any additi Lagi

$30 USD dalam 0 hari
(0 Ulasan)
1.0
carlos58ar

We will be glad to prepare the work for you. Regards. Carlos Blasco

$50 USD dalam 2 hari
(0 Ulasan)
0.0
martinetinc

Dear Business Manager, Our warm greetings to you. I am Syed Abdul Azeem COO of Martinet Technologies, a non-voice BPO provider based in Hyderabad, India, offering wide range of services in Data Processing and Dat Lagi

$99 USD dalam 22 hari
(0 Ulasan)
0.0
trinitysoftwares

Hi, I propose a macro that open on a form where you specify the text, whether it is Input/Data and Do you want to add more. If you desire to add more, a new row will open up. If you decide to ‘Run Macro’, it will a Lagi

$50 USD dalam 4 hari
(0 Ulasan)
0.0
meha

Dear Sir, We have already developed this Macro and is ready to be delivered, moment you want. We are a set of seasoned programmers with immense experience from the corporate world and specifically in areas like Lagi

$30 USD dalam 0 hari
(0 Ulasan)
1.6
vladislon

I have processed similar projects before. And I'm good at office macros' programming. Thank you!

$30 USD dalam 3 hari
(0 Ulasan)
0.0
neon

let us start rightaway. we can help you easily.

$60 USD dalam 2 hari
(0 Ulasan)
0.0
senthil79

I will be able to design, develop & deliver the project in a day. I have already done a few VBA Macro projects.

$30 USD dalam sehari
(0 Ulasan)
0.0
software2003

Dear Sir I am very interested regarding your project. I have a 7-year experience in IT field. I am from India, the number one country in the software field. My typing speed is 80wpm If you accept my bid Lagi

$40 USD dalam 10 hari
(0 Ulasan)
0.0