What I need is a way of automating a process that I need to do on a monthly basis. Basically I have 1 main file that I manually enter data onto file Titled May 2007(this is the one I completed last month) I attached the blank Template as well. The other individual files that start with 050107-053107 contain the information that I need to enter onto the blank template. I would like to set up some way that I can import this information into the spreadsheet instead of manually entering it data into each cell. I wouldn’t mind importing each individual file. this step 1 of the long process I need completed. Once I figure out how to explain step 2 and have an example for it I will let you know. Please give me a quote on this IF there is a way to set this up whether using macros or some sort of spreadsheet merge. If this can not be done in less time that it currently takes me to enter it 4-8hrs depending on my work load and how seamlessly I can get through it, then I will just continue doing it this way.
18 freelancers are bidding on average $48 for this job
This can be done easily with a special command in excel. I have experienced automating before excel file for their inventory system. If you give me this opportunity, i would gladly share my knowledge about excel file.
I have this this project completed. With my solution, total time to populate your empty spreadsheet is seconds. Different input files can be selected as needed via a pop-up form. Code can be emailed immediately.
hi, I can work for you exclusively for 6 hours doing your tasks , 5 times a week a total of 10 days, 60 hours per week. I can guarantee you of a good and efficient work. Thanks, marie