En cours

Writting VBA code for Excel

Data comes in in a table with 55 colums x 50 rows.

I want to create a workbook with 2,750 worksheets (2,751 in total- 1 input sheet, 2,750 locations to copy to) . The VBA program that I am looking for will allow me to create a running list of values in "clolum b" of every one of the 2,750 worksheets. I want to be able to copy my input table (55 rows x 50 columns) into the input worksheet and then run a macro that will copy each value from the input table to the first blank cell in the individual growing lists. I will be able to save the workbook with a date as a name. When I open the workbook and copy in a new input sheet and run the macro again, each list in each of the worksheets will get one new row of data. The first time I run it, I will have one row of data in each sheet. the second time, 2 rows in each sheet ect such that if I get new data 4 times a year, in 20 years I will have 80 saved workbooks and the last one will have 80 rows of data in each worksheet.

Compétences : Visual Basic

Voir plus : excel vba copy cell, excel 2007 vba code, vba excel code optimization, excel vba cut cell, optimize code vba excel

Concernant l'employeur :
( 1 commentaire ) Shediac River, Canada

N° du projet : #14809801

Décerné à :

VladimirLilenko

I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality! Relevant Skills and Experience Excel, vba Proposed Milestones $750 CAD - Project complet Plus

750 $ CAD en 4 jours
(25 Commentaires)
4.6

54 freelance ont fait une offre moyenne de 865 $ pour ce travail

cgullapalli

Hi, I am good at Excel and vba. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra Relevant Skills and Experience Excel vba Proposed Plus

750 $ CAD en 1 jour
(219 Commentaires)
6.7
1000 $ CAD en 12 jours
(103 Commentaires)
6.3
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement. Relevant Skills and Experience I have the 5 years of e Plus

750 $ CAD en 10 jours
(78 Commentaires)
6.5
bouslimi1979

Hi, I can code the set of macros. But I need sample files + a short discussion. Also feel free if you want to speak French. Thanks Relevant Skills and Experience Excel/VBA coder Proposed Milestones $750 CAD - m

750 $ CAD en 10 jours
(50 Commentaires)
6.1
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 Plus

755 $ CAD en 2 jours
(53 Commentaires)
5.5
wsh2

Greetings Peter from Easton PA, USA.. {smile} Highly experienced (25+ years) MsEXCEL Business Information, Programming, and Database expert with Guru / Mentor level technical credentials at www.experts-exchange.com Plus

800 $ CAD en 20 jours
(25 Commentaires)
5.6
koolsidz

NOTE: This is a temporary bid. Please share exact details so that I can give you an exact bid Relevant Skills and Experience My Credentials: 20+ of VB Experience. http://www.siddharthrout.com/aboutme/ https: Plus

750 $ CAD en 5 jours
(63 Commentaires)
5.9
AwaisChaudhry

Hello there. I have seen your job posting. I will like to ask some questions. Please come over the chat so we can discuss things. Relevant Skills and Experience All the skills/experience will be discussed/revealed upo Plus

1250 $ CAD en 20 jours
(4 Commentaires)
5.7
sergpooh

Hi! I can make the best solution for you! Relevant Skills and Experience I have a great experience with Excel and VBA. Also I know how need work with big tables and with many sheets. Proposed Milestones $750 CAD - Wi Plus

750 $ CAD en 10 jours
(37 Commentaires)
5.2
MohsanEijaz

I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Relevant Skills and Experience EXCEL, VBA Proposed Milestones $750 CAD - d

750 $ CAD en 5 jours
(24 Commentaires)
5.0
seaanddream

Hi, my name is Sevinc. I read your "Writting VBA code for Excel" project descriptions carefully before bidding. I checked your requirements as well... I got what you need and ready to go ahead as soon as we can clari Plus

750 $ CAD en 5 jours
(11 Commentaires)
5.0
MoohHHooM

Hi, i can help in this project as i worked previously on similar project, you can check my reviews for that. https://www.freelancer.com/projects/User-Interface-IA/Program-Interface/ Relevant Skills and Experien Plus

750 $ CAD en 3 jours
(15 Commentaires)
4.9
zu02

Hi, very interesting to code ..I'll code that for sure Relevant Skills and Experience vba, sql, ado Proposed Milestones $1250 CAD - default

1250 $ CAD en 20 jours
(18 Commentaires)
5.2
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

750 $ CAD en 3 jours
(38 Commentaires)
5.2
TonmoyRoy111

A proposal has not yet been provided

770 $ CAD en 3 jours
(27 Commentaires)
4.2
NallakumarKC

Hi, I am Nallakumar. I have more than 10 years of experience in Excel Automation. Relevant Skills and Experience I can do this work for 400 CAD in 1 day. Proposed Milestones $750 CAD - Initial Milestone

750 $ CAD en 1 jour
(7 Commentaires)
4.4
nagybatonyi

In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Relevant Skills and Experience I have a university degree in econo Plus

750 $ CAD en 2 jours
(13 Commentaires)
4.0
solucionesnet

Hi, I can help you with your excel file to generate the worksheets. Habilidades y experiencia relevante I have a lot of experience working with vba code and excel addins. Htos propuestos $770 CAD - develop, test and Plus

770 $ CAD en 10 jours
(5 Commentaires)
4.1
1250 $ CAD en 5 jours
(3 Commentaires)
3.2
binarycodersvw

Hi.This is not another mindless automated bid. I am a Visual Basic .NET programmer with 10 years experience. CV and see screenshots+videos of exe softwares i made> www.GrigoreAndrei.com/a.htm Stay tuned, I'm still Plus

863 $ CAD en 11 jours
(3 Commentaires)
3.0