We need a VBA Macro which will loop through a list of Excel files and perform the following functions: Open the file, insert a row between rows 1 and 2 (below the first line), save the file, close the file, move to the next. It should be very easy and take less than an hour. The attached files are samples, so we need the code to be generic enough that we can modify the same sheet/macro to insert/delete rows as needed when the system that creates the files changes their formatting.
Hello there, I can write macro for this task. I have just one query . Do you need this macro to ask for folder selection that contains the excel files.
9 freelancere byder i gennemsnit $20 på dette job
Hi, yes this is not hard to do and yes it can be done under an hour. If you are interested in working with me, please message me, i have few follow up questions. I am able to start immediately. Thanks, Milan
Hi, I have understand the project requirement & interested to make for add and delete row for this project. Please send a message so we can discuss more & start the project. Thanks.