We need to automate and speed up the process of copying formulas from on Excel Spreadsheet and inserting into another Excel Spreadsheet. The formulas reference links and can take up to 20 minutes to refresh. In addition, we need to add a custom function into the Excel workbook for the formulas to work. The most important aim of this project is to have a process is repeatable; this means either a Excel Macro or exe
There are two spreadsheets : BoatTemplate and Stocktake with Itemcode. BoatTemplate has the information I need to copy to other spreadsheets in column H - R. BoatTemplate also has the VBA Code in module. Stocktake with Itemcode spreadsheet is only provided for reference purposes as linked to BoatTemplate.
The two spreadsheets will always be located in C:\BoatTemplate
I need to open a spreadsheet such as "4.4m Avenger [login to view URL]" (the name of the spreadsheet is will different each time) then run the macro. The macro needs to do the following:
1. Add column H - R (as it is not include the active spreadsheet
2. Add the VBA Code to the active spreadsheet so the custom function is available
3. Open the BoatTemplate spreadsheet and copy column H - R and paste into the new active spreadsheet
4. Copy the H5 - R5 range to cells
5. Copy column H - R and paste as values
6. Select column H - R and Replace #VALUE and #N/A with ""
7. Save
Hi there. My name is Daniel and I would be glad to help you out with this project. I understand the process that needs to be automated and I think I can come up with a solution that will be both efective and easy to use. I can guarantee an excellent job and deliver as soon as possible. Thanks!
$199 AUD în 2 zile
4,8 (98 recenzii)
6,8
6,8
7 freelanceri plasează o ofertă medie de $159 AUD pentru proiect
Dear Sir/Madam,
Requirements are clear and i believe i can finish this task in 3 days.
I'm well experienced with excel and VBa. Please check my references.
I would like to show my qualified work for a reference.
Thank you and have a nice day.
Oguz YILMAZ
Hi John here, I hope you will consider me for your project. I will assure you a quality end product at a competitive price. I know you will be swamped with bids so thank you for the time. Hoping to hear from you soon and if you have any queries please do not hesitate to message me and i can talk. thanks
Hello, how are you doing today? Click on that__CHAT__button below so that I can ask a few questions concerning your project. I have read all the provided instructions and I am the right person to work on this task. I provide exceptional quality services on time, leaving you fully satisfied and this is what your money is worth, right? I do not outsource any part of your work. Producing quality work is my habit thus i am highly valued by my clients who always rehire me. My record speaks for itself most of my clients have succeeded be the next.I am ready to start working on your job today. Thanks and welcome.