Devam Ediyor

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.

Beceriler: Visual Basic, Windows Masaüstü

Daha fazlasını görün: 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

İşveren Hakkında:
( 4 değerlendirme ) Brier, United States

Proje NO: #65196

Seçilen:

SachinBhatt

We have developed several such utilities in Excel.

4 gün içinde 50$ USD
(24 Değerlendirme)
4.5

28 freelancers are bidding on average $46 for this job

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

in 0 gün içinde40$ USD
(13 Değerlendirme)
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 Daha fazlası

in 0 gün içinde30$ USD
(35 Değerlendirme)
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 Daha fazlası

in 3 gün içinde60$ USD
(3 Değerlendirme)
3.6
Indunil

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

in 0 gün içinde55$ USD
(1 Değerlendirme)
3.2
amanullahs

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

in 2 gün içinde65$ USD
(2 Değerlendirme)
3.1
Progmatics

VBA for MSExcel is my expertise.

in 3 gün içinde50$ USD
(2 Değerlendirme)
2.8
kumartech

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

in 2 gün içinde40$ USD
(1 Değerlendirme)
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 Daha fazlası

in 2 gün içinde40$ USD
(1 Değerlendirme)
1.6
kmohan1962

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

in 0 gün içinde30$ USD
(2 Değerlendirme)
0.7
evrenera

i made it for you. little changes gratis.

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
jamisla

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

in 2 gün içinde40$ USD
(0 Değerlendirme)
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 Daha fazlası

in 0 gün içinde30$ USD
(0 Değerlendirme)
1.0
carlos58ar

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

in 2 gün içinde50$ USD
(0 Değerlendirme)
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 Daha fazlası

in 22 gün içinde99$ USD
(0 Değerlendirme)
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 Daha fazlası

in 4 gün içinde50$ USD
(0 Değerlendirme)
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 Daha fazlası

in 0 gün içinde30$ USD
(0 Değerlendirme)
1.6
vladislon

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

in 3 gün içinde30$ USD
(0 Değerlendirme)
0.0
neon

let us start rightaway. we can help you easily.

in 2 gün içinde60$ USD
(0 Değerlendirme)
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.

1 gün içinde 30$ USD
(0 Değerlendirme)
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 Daha fazlası

in 10 gün içinde40$ USD
(0 Değerlendirme)
0.0