Find Jobs
Hire Freelancers

Create a copy/paste macro for open office. Multiple files.

€8-30 EUR

Completed
Posted about 5 years ago

€8-30 EUR

Paid on delivery
What I manually do now and needs to be automatically done: - open my main file; - open several other files called "target files" (similar files, data is different); - copy row21 from each of the files and "paste special" it in the main file. repeat with each of the "target files". close target files. Open the next ones. repeat. Need to do this without opening the files (less time) if possible. If not, only auto. So I will need a simple macro that will copy the same row from different .ods files and paste it "special" in the main file, always in the same sheet but in the next empty row. I must be able to select the "target files" so I can remember which files I already processed. (using like a button which allows me to select and open multiple files - multiple means 10 at once) ----------- "target files" =files from which I copy row21 "main file" =file where I paste Copy always row21 from sheet named "basketball stats" Paste will be made in sheet3 of the main file starting with the 9th row. Paste special, only "text" and "numbers" checked. (MAIN file attached here already has the data from the 5 target files, as an example).
Project ID: 18890469

About the project

9 proposals
Remote project
Active 5 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
I have such code written like it & can also develop if any more requirement is there like it. Just one click & let excel do that work for you. It will be 1 days delivery.
€10 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
9 freelancers are bidding on average €34 EUR for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
€60 EUR in 1 day
4.9 (13 reviews)
4.8
4.8
User Avatar
I AM SAHINUR & STUDYING IN ENGINEER FIELD, PROFESSIONAL WORK WITH VERY LOW COST BECAUSE I WANT CAREER WITH FREELANCING WEBSITE. IF YOU INTERESTED ME PLEASE CONTACT. I WILL 100% GENUINE WORK WITH O% ERRORS FOR YOU. MY TYPING SPEED 60 WPM & MY ACCOUNT FULLY VERIFIED. <<<UNSATISFIED CUSTOMER 100 MONEY BACK GUARANTEE>>> THANK YOU
€17 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi.. I have 8+ years of experience in Excel. I'm expertise in creating Dashboards and reports. I have worked on several automation request as I have been part of Robotics Process Automation Team (RPA). I have good experience in creating Pivots, Vlookups, Hlookups and several other formulas. So I can automate any reports or Dashboards using formulas or VBA. I assure I can fullfil your requirement through VBA with 100% accuracy. Do let me know to discuss further and take it forward. Thanks!!
€29 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, I am a new user .Cordially thanks to you. I would like to do your task wise and precisely. I think i am fit for your job. Yes i have an experience in this field for one years. I will take payment after giving your work. I think you would enough kind to give me your project. Thanking You Sadi Mahomud Arafat
€25 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a proffessional writer
€23 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am Himon. New to Freelancing side. i want to start my Freelancing job life with this job(if you choose me). i think i can do this job better than other. tq
€9 EUR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ROMANIA
Timisoara, Romania
5.0
4
Payment method verified
Member since Jan 27, 2017

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.