Excel Macro / VBA Code

已关闭

描述

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 "[url removed, login to view] Avenger [url removed, login to view]" (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

技能: Excel, 软件构架, Visual Basic的应用程式

查看更多: small script vba macro excel, vba macro excel, need someone write vba macro excel, convert vba macro excel menu item, vba macro excel update inventory pricing, vba macro excel text file, vba macro excel googlefinance, vba macro excel freelancer, record list vba macro excel, software write mq4, software write chip epson, useful software write book, software write web specs, free vba macro excel stocks, free software write user guide, pre written vba macro excel, software write edid, free software write company profile, software write websites idea, software write book images, vba macro excel enable paste protected sheet, software write books, vba macro excel display contents, software write protection, free software write book

Project ID: #12029188

已悬赏给:

DanielVizcaya91

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 us 更多

$199 AUD 在2天内
(61条评论)
6.3

9 freelancers are bidding on average $169 for this job

$250 AUD 在3天内
(21条评论)
5.1
marketiplace

We have 8+years work experience in .NET,FLASH,C#,Linux,Visual Studio2010,Joomla,ASP,Javascript,Java,PHP,Python,Prestashop, MS access,SQL,Shell script,XML,moodle,AJAX,CMS,HTML,Drupal,SEO,CSS,wordpress,Bootstrap,Photos 更多

$155 AUD 在3天内
(4条评论)
4.0
webanis

Hi , I am interested by your offer: Excel VBA code. I will be happy to do this job even though I'm new in the field of freelance. I can give you an example of my work with Excel VBA code. Let me know more deta 更多

$155 AUD in 1 day
(8条评论)
3.4
oguzyilmaz

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 referen 更多

$150 AUD 在3天内
(3条评论)
3.1
$250 AUD 在3天内
(3条评论)
2.1
hcmarceb

I have been working with VB and macros for Excel. I have created some excel management software too.

$144 AUD 在2天内
(0条评论)
0.0
IdeaCentre

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 p 更多

$60 AUD 在3天内
(0条评论)
0.0
JohnHenrry

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 a 更多

$155 AUD in 1 day
(0条评论)
0.0