Terminé

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

En voir plus : excel vba function return blank cell, gnenerate xml code vba excel, vba excel application sum multi cell, vba excel 2016, vba excel pdf, vba excel examples, excel vba programming pdf, vba excel 2013, vba excel functions, useful vba codes for excel, vba excel download, sql, visual basic, microsoft excel, excel vba copy cell, excel vba paste cell left, vba excel code extractor page web, excel 2007 vba code, vba excel code optimization, code vba excel primavera critical path

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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% CAD en 4 jours
(101 Commentaires)
6.2

51 freelances font une offre moyenne de 869 $ pour ce travail

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 10 jours
(158 Commentaires)
7.6
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(465 Commentaires)
7.4
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 12 jours
(137 Commentaires)
6.9
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 10 jours
(92 Commentaires)
6.4
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(93 Commentaires)
6.2
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 [login to view URL] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 20 jours
(27 Commentaires)
5.8
TonmoyRoy111

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(91 Commentaires)
5.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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(80 Commentaires)
5.9
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. [login to view URL] https: Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 5 jours
(64 Commentaires)
5.9
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 5 jours
(38 Commentaires)
5.8
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 20 jours
(14 Commentaires)
5.6
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 20 jours
(4 Commentaires)
5.7
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 10 jours
(40 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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 10 jours
(40 Commentaires)
5.7
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 5 jours
(17 Commentaires)
5.6
SShtv

I am ready to execute the project for the 500 CAD. Relevant Skills and Experience I have a successful experience of doing such work. Proposed Milestones $750 CAD - create a workbook

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 5 jours
(32 Commentaires)
5.2
zu02

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 20 jours
(23 Commentaires)
5.5
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(19 Commentaires)
5.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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(9 Commentaires)
4.9
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 20 jours
(3 Commentaires)
4.4