VERY IMPORTANT: The macro must work with Open office version 3.1.1 !!! It`s not the same thing as code it for excel!
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 open the "target files" and copy the same row 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 a keyboard shortcut which allows me to open a dialog and select and open multiple files by CTRL+click; multiple means 5-10 at once)
"target files" =files from which I copy row21
"main file" =file where I paste the data copied
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).
Target files and Main files will have different filenames; files in here are only an example. Sheet names inside them will always remain the same as they are.
Automation to copy the same line from many different files and paste as special (only values and without format) to the main spreadsheet, always changing to the next line avoiding overwrite. Result of 10 source spread Plus
I can help you I think, I can figure out your problem. I have rich experience in excel and VB, and I do my best to save your time and pocket. please feel free to contact me. MySkills: • Data Management .......... Plus
4 freelance font une offre moyenne de €26 pour ce travail
Hello, I have OpenOffice 4.1.6. To be honest I don't know if there will be any issues with your older version but considering that the code is not very out of the ordinary, it should be fine. I can build the macro Plus
bonjour , je suis disponible et efficace vous pouvez compter sur moi pour faire l travail comme il faut et merci d'avance