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

Completed Posted 7 years ago Paid on delivery
Completed 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.

Excel VB.NET Visual Basic

Project ID: #12880147

About the project

41 proposals Remote project Active 7 years ago

Awarded to:

excel4engineers

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
(17 Reviews)
3.6

41 freelancers are bidding on average €19 for this job

jaylancer43

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 More

€30 EUR in 0 days
(777 Reviews)
8.6
paris2785

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 y More

€25 EUR in 1 day
(264 Reviews)
7.6
ksriniravi

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 Reporti More

€15 EUR in 1 day
(213 Reviews)
6.9
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, models and macros. Check my reviews. They speak for themselves. Best rega More

€20 EUR in 0 days
(272 Reviews)
7.1
oadsmedia

!!! Dear Honor !!! We Can Help You Make That Happen !!! Let's discuss............. Choose wisely!! Cheers :)

€30 EUR in 1 day
(78 Reviews)
6.6
watersev

A proposal has not yet been provided

€11 EUR in 0 days
(261 Reviews)
6.5
sajibdigital

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
(66 Reviews)
5.7
beltran0404

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
(143 Reviews)
5.7
archanaoswal

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 More

€20 EUR in 1 day
(90 Reviews)
6.0
nagybatonyi

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 macr More

€19 EUR in 1 day
(64 Reviews)
5.7
vsprybhanu

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 co More

€30 EUR in 1 day
(89 Reviews)
5.7
standarditech

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 More

€19 EUR in 1 day
(78 Reviews)
5.2
GeniuSBraiN

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, More

€20 EUR in 1 day
(19 Reviews)
5.1
anachirilov7

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 days
(14 Reviews)
4.4
faialeem

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 days
(26 Reviews)
4.5
huongth

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
(24 Reviews)
4.0
vivirain

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, More

€23 EUR in 1 day
(11 Reviews)
3.7
rameshmahala

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
(4 Reviews)
2.8
rafeemd

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
(3 Reviews)
2.4
tiagobarreira

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 More

€8 EUR in 3 days
(1 Review)
1.7