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).
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.
9 freelance font une offre moyenne de €34 pour ce travail
Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Plus
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. Plus
Feel fee to contact me for Create a copy/paste macro for open office. Multiple [login to view URL] me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help Plus
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. M Plus
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 ex Plus
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 giv Plus
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