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.
We have developed several such utilities in Excel.
28 freelancers are bidding on average $46 for this job
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
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 Fazla
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 Fazla
I can do this project. Can automate this task neat and clean.
Hi, I fully understand your requirements and I can do your project to satisfaction.
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 Fazla
Hello; I've a code ready to crack for your project. Regards. [url removed, login to view]
I can do the job, I have experience en VBA programming.
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 Fazla
We will be glad to prepare the work for you. Regards. Carlos Blasco
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 Fazla
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 Fazla
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 Fazla
I have processed similar projects before. And I'm good at office macros' programming. Thank you!
I will be able to design, develop & deliver the project in a day. I have already done a few VBA Macro projects.
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 Fazla