Excel Program to Copy Subset of Rows and Columns to New Tab

Completado Publicado Feb 16, 2015 Pagado a la entrega
Completado Pagado a la entrega

I have a few spreadsheets that have a massive number of records and columns. I need to generate reports from those of a limited number of rows and columns. I expect that I will mark the rows I need to print on an ongoing basis by adding a column for printing, and entering any character in this column will mean that the corresponding row should appear on a report.

One way this idea could be implemented would be to have a "report" tab in the spreadsheet. The report tab would have inputs set at the top:

1) Name of the tab to report on.

2) Column that contains a marker about the rows to be printed

3) Columns to be included in the report

4) Space between records

When you select a button like "Generate Report" then the excel program would copy over the marked rows and columns. The new tab could then be printed like any Excel tab.

Please be the programmer who does the work. Please, no firms bidding on this job. I do not want you farming out this work to someone else. I want to see the resume and work of the person writing the code.

Please show me some fragments of code you have written in the relevant programming environment. I want to see how you organize code and how you document it.

Excel Visual Basic

Nº del proyecto: #7147891

Sobre el proyecto

24 propuestas Proyecto remoto Activo Feb 16, 2015

Adjudicado a:

gokulanand

Hello, The task looks pretty simple to me. I can get this task done in the next 3 to 5 hours. I had worked on many VBA ( Excel programming ) related projects here in freelancer. Let me know if you are interested. Más

$70 USD en 0 días
(115 comentarios)
6.1

24 freelancers están ofertando un promedio de $107 por este trabajo

elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards

$88 USD en 3 días
(334 comentarios)
7.5
zExcel

A proposal has not yet been provided

$145 USD en 1 día
(257 comentarios)
7.7
maverick44000

Hi Sir. Please share the Excel sheet and identify the marked rows and columns. I shall write a VBA script that will filter the data to new tab. I have done similar work before and I can do it for you with ease. Regards Más

$120 USD en 2 días
(93 comentarios)
7.1
finecodervw

Hi, Would appreciate if we can discuss on this and I would be more than happy to share what I have already done and how structured I am on the code that I write. I am well versed with writing macros in Excel, Wor Más

$100 USD en 3 días
(199 comentarios)
6.9
aarifakhtar

Hi: Please note that I have 100% completion rate and 5-star feedback on all projects (>50 total completed projects). More than 90% of my completed projects are related to Excel and macro. Please connect with me to disc Más

$111 USD en 3 días
(171 comentarios)
7.1
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I have done many projects like this. Next steps: Lets discuss/validate the complete requirement and I can start to Más

$147 USD en 1 día
(175 comentarios)
6.6
sknadeem123

A proposal has not yet been provided

$101 USD en 5 días
(72 comentarios)
6.3
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 225 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Más

$75 USD en 3 días
(123 comentarios)
6.3
mhmhz

Hi I understand the requirements. Can you provide Excel file example then i will provide a desktop application that do the task? Thanks

$263 USD en 2 días
(54 comentarios)
6.3
srinichal

I like to discuss further about the project and deliver the same to your needs .

$157 USD en 3 días
(50 comentarios)
6.0
renesontiongson

Hi! excel automation is my masterpiece in my accounting field. It is my pleasure to help your project. Feel free to message me with your actual data. Thank you.

$60 USD en 1 día
(73 comentarios)
5.7
bizwizz

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have bee Más

$150 USD en 3 días
(19 comentarios)
5.7
abdolah2014

HI I am an excel-vba Expert and I can finish your project so fast pm me ................................................................................. ready to start

$100 USD en 3 días
(38 comentarios)
5.3
salih0vicx

Hello there, I've been working overseas as HR Supervisor (HR Data Cell) for an US based company. During 4 years contract I've developed numerous auto-reporting tools by combining Excel, Access, Outlook, PDF forms (J Más

$99 USD en 3 días
(9 comentarios)
4.9
FreeLAS

Hi, as employee of the Bank I've a lot of experience with Excel reporting, you can see feedback on my previous MS Excel related projects as well, I can't attach any files to my bid, but will be happy to demonstrate the Más

$114 USD en 3 días
(18 comentarios)
4.8
rajafaizan

Hello Sir, I guarantee you 100% satisfaction. Would you like to discuss with me.....we negotiate about price and time.....My expertise lies in quality service and delivery on Time. Kindly if you want high quality work Más

$94 USD en 3 días
(30 comentarios)
4.5
sreejithakaz

I have over 9 years of experience in Excel, Access and Outlook VBA. I have developed several Tools, Automation, Dashboard, Database CRM and Online Extraction Tools using VBA. I have done a similar kind of project for Más

$55 USD en 1 día
(14 comentarios)
4.1
MarathTamizhan

Hi. Have been doing programming for past 12 years in excel. Please send your file to me. I'll produce results you need and give it. If you are happy with result pay me. If not satisfied you need not pay. Indeed yo Más

$56 USD en 1 día
(2 comentarios)
2.4
hammougua

Hello, I am an engineer and I can do this job quit easily, with more creativity. My idea is the following: After you click the "Print Report" button, a message box will appear and you can select the columns you wan Más

$55 USD en 3 días
(1 comentario)
0.4
nimanthadasun

Ready to start now and will finish in your given time period. To check my data entry experience please visit my profile. I'll charge only $30 for this task. Best regards, Nimantha.

$30 USD en 3 días
(0 comentarios)
0.0