Find Jobs
Hire Freelancers

Excel:filter and copy/paste data from sheet 1 to sheet 2 with macro

€8-30 EUR

Completed
Posted over 7 years ago

€8-30 EUR

Paid on delivery
I have existing Excel file, i have created the macro code for moving some numbers from sheet 1 to sheet 2, but I need help. Sheet 1 have 3 sections, first section is A,B,C,D columns, second `section` is from column E to KT, and third section is from KU to end I would like a macro code which will go through section three and if value <1 is found copy that row to sheet 2. I dont want complete data to be c/p to sheet 2, if in third section value <1 is found, copy to sheet 2 only from that row : section 1 and from section 2 only 2 numbers which when merged produce result in section 3 I have vba code which is already doing 80 percent of this, you can use this or create your own.
Project ID: 12880147

About the project

41 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Thanks for your detailed instructions. You will get it today. I will provide you vba macro script under Windows excel which will be able to process any number of rows with one click.
€9 EUR in 1 day
4.9 (17 reviews)
3.6
3.6
41 freelancers are bidding on average €19 EUR for this job
User Avatar
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working sample work before you consider awarding me the project. Thanks, Jay
€30 EUR in 0 day
5.0 (777 reviews)
8.6
8.6
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
€25 EUR in 1 day
4.9 (264 reviews)
7.6
7.6
User Avatar
Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
€15 EUR in 1 day
5.0 (213 reviews)
6.9
6.9
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
€20 EUR in 0 day
4.9 (272 reviews)
7.1
7.1
User Avatar
!!! Dear Honor !!! We Can Help You Make That Happen !!! Let's discuss............. Choose wisely!! Cheers :)
€30 EUR in 1 day
5.0 (78 reviews)
6.6
6.6
User Avatar
A proposal has not yet been provided
€11 EUR in 0 day
5.0 (261 reviews)
6.5
6.5
User Avatar
Hi, I am interested to work with you. Please contact me on chat, I am waiting for your response. Thanks Sajib.............................
€14 EUR in 1 day
5.0 (66 reviews)
5.7
5.7
User Avatar
Hello, I'm excel and visual basic expert and I can help you with. Please contact me by chat and then we could discuss better your project. Kind regards, Luis Romero
€20 EUR in 3 days
5.0 (143 reviews)
5.7
5.7
User Avatar
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a hotel price comparison system that pulls data from the website's API - Built a complex shift allowance calendar and calculator - Built a complex lookup to sort products into multiple categories You can see the reviews of the same in my profile
€20 EUR in 1 day
4.9 (90 reviews)
6.0
6.0
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. 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. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I can start working on the project immediately and complete the job within one day. Regards
€19 EUR in 1 day
4.9 (64 reviews)
5.7
5.7
User Avatar
Hi, Experienced Excel Macro Developer. I have read your instructions carefully. Now please read my logic carefully. I will start Loop from Row number 2 (because row no.1 is always heading) and check All columns of Sections 3 one by one. If Value is <1 (it means 0 or minus value) then Copy the Current Row, Go to Sheet 2 and Paste it in current available Row. Thats it. I can do this job nicely. I have excellent knowledge and experience of Manipulating Data from Multiple Sheets, Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly this type of job where data manipulation is required. Please check my portfolio to see my work. Ready to start please reply soon. Thanks, Virendra
€30 EUR in 1 day
4.8 (89 reviews)
5.7
5.7
User Avatar
Hi, I have taken a deep look on this project, and I am sure that we can work together. I have experienced in these kind of task. Please give me a chance to serve you and i will never let you down. I will complete this task with your timeline and budget.I have already successfully completed these kind of task recently. I am sure that once we work together then we will get a best result at the end. Hope for positive and favorable response from your side. Thanks
€19 EUR in 1 day
4.9 (78 reviews)
5.2
5.2
User Avatar
Hello, I can do the task in less time, and 100% accurate - I have a long experience with MS-Excel (formulas & VBA macros). Also: - I'm an experienced software developer specialized in desktop applications, tools, and scripts. - I write programs using .NET since 2012, and using classic VB6 since 2007. - Have long experience with web scraping applications, socket communications, FTP connections, mathematics & formulas, applications that manipulate files & folders, and creating mini-tools that automate tasks while working in background. - Very good experience with multi-threaded applications. - Very good Experience with database based applications (MS-Access, SQL Server, and MySQL). - Accuracy and precision is one of my principles, also one of my best advantages. - Commitment to deliver tasks in time. I I'm looking forward to working with you, helping you to solve problems :) Please feel free to contact me to discuss any further details.
€20 EUR in 1 day
5.0 (19 reviews)
5.1
5.1
User Avatar
Hello! Please send to me more details about this project and i'm ready to start work right now. Select me please.
€23 EUR in 0 day
5.0 (14 reviews)
4.4
4.4
User Avatar
Hi Please consider , I can provide your solution in few hours, please share me your file , so i can see and better analyze that Thanks Faisal
€29 EUR in 0 day
4.8 (26 reviews)
4.5
4.5
User Avatar
Hi. I am an expert in excel vba. I can write excel vba projects as you request. I can auto read write excel files from a standalone application. I can start right now
€14 EUR in 1 day
4.6 (24 reviews)
4.0
4.0
User Avatar
Hi there, I'm interested in the job. I'm an excel expert with rich experiences of excel macro programing. I can get it well done. Look forward to hearing from you and discuss more details. Best Regards, VL
€23 EUR in 1 day
4.9 (11 reviews)
3.7
3.7
User Avatar
Hello there, I have good experience in excel macro writing, and would like to be considered for job. Thanks, Ramesh
€14 EUR in 1 day
5.0 (4 reviews)
2.8
2.8
User Avatar
I have sound experience (5+ years) in Excel/MS Access/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy.
€19 EUR in 1 day
5.0 (3 reviews)
2.4
2.4
User Avatar
STATISTICAL ANALYST BSc of Economics and Macroeconomic Analyst. 3 years of experience on research and statistical analysis. Hard working, fast-learning, excellent logical and analytical skills. - Proficiency: Economics, Labor Economics, Demographics, Econometrics, Time Series Analysis and Forecasting, Panel Data Analysis, Data processing - Programming: STATA, Excel/VBA, R and Matlab
€8 EUR in 3 days
5.0 (1 review)
1.7
1.7

About the client

Flag of SERBIA
Novi Sad, Serbia
4.9
4
Member since Aug 19, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.