Suoritettu

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

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).

Taidot: Excel Macros

Näytä lisää: copy paste macro excel timed, run excel macro open office calc, exel 2003 copy paste macro, maker macro open office calc, clipboard copy paste macro excel, excel excel copy paste macro, run excel macro open office, java execute macro open office, create multiple files excel macro, open office permissions files, copy paste multiple excel files, convert excel macro open office calc, copy paste macro vba, macro to download multiple files from website

Tietoa työnantajasta:
( 4 arvostelua ) Timisoara, Romania

Projektin tunnus: #18890469

Myönnetty käyttäjälle:

gautamkumar342

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 1 päivässä
(0 Arvostelua)
0.0

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

jaylancer43

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 ( Lisää

€100 EUR 1 päivässä
(27 arvostelua)
6.7
schoudhary1553

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. Lisää

€60 EUR 1 päivässä
(13 arvostelua)
4.8
RushService

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 Lisää

€30 EUR 1 päivässä
(1 arvostelu)
0.0
SAHINUR2

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 Lisää

€17 EUR 1 päivässä
(0 arvostelua)
0.0
mi3pranesh

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 Lisää

€29 EUR 2 päivässä
(0 arvostelua)
0.0
smarafat113

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 Lisää

€25 EUR 1 päivässä
(0 arvostelua)
0.0
shojibboss2074

I am a proffessional writer

€23 EUR 1 päivässä
(0 arvostelua)
0.0
Himonafroj

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 3 päivässä
(0 arvostelua)
0.0