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.
53 freelancere byder i gennemsnit $867 på dette job
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
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
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