I need to have a VBA macro written for Mac for Excel 2011. Will enable me to 1. Select a cell in a worksheet 2. Open file name 3. Choose file (which is a picture). 4. Insert picture into a specified cell. 5. Resize picture automatically into cell, while maintaining the aspect ratio.
...a custom invoice/quotation template developed for use in Sage One (Accounting Software). Sage One has custom templates, however, I also need to add a 2 page Terms & Conditions to the back of the invoice/quotation. Terms and conditions have been written and I have in a Word doc (need to be included in the template). I have logo etc. Invoice/Quotation
Hi, these are the desire outputs: 1. VBA code that converts : a. ALL the text values in the workbook to "A" b. ALL the dates value in the workbook to "1/1/1970" c. ALL the numbers values in the workbook to "1" d. Formulas should NOT be effected AT ALL 2. VBA code that converts : a. ALL the "A" values in the workbook to a random text...
have created a macro and need fine tuning. Just a simple work. Just to summarize 1. Autofilter and create new worksheets based on the filter value with keeping the same format of the original file. 2. Loop the process until the filter fields get over. 3. AutoFill Destination Range("A5: A6") to the end of the column. Note (To be done)
I need vba script which can download the historical data of a specific ticker along with option price. Please see the attached excel file on how the data should look also attached is a word document explaining the requirement.
Dear sir/madam , i need the following a) QUOTATION , b) INVOICE , c) RFQ ( REQUEST FOR QUOTATION) , d) JOB REPORT , e) DELIVERY REPORT , f) SALES REPORT . as customized standard formats , where the contents alone can be filled by the staffs .
...modifications on the following files in order for the customer to get a receipt or an invoice depending on his choice during checkout process: Under : /templates/shaper_varsita/html/com_virtuemart/orders : [url removed, login to view] That is where we decide if we will show a button for invoice "Τιμολόγιο" or receipt "...
I would like to to enter on one sheet projects with 8-10 departmens start dates and duration days: Example Department 1 Department 2 start duration start duration Project A [url removed, login to view] 5 [url removed, login to view] 10 Project B [url removed, login to view] 15 [url removed, login to view] 3 ... details ...
I need someone to scrape simple data from specified website. More details will given to appropriate programmer. This is a simple job therefore looking for those who will ask low amount and a 5 star feedback. Thanks
...with cost UI Invoice Design with two format UI ALL reports UI development Functionalities Integration DB Architecture design Customer add, edit and delete functionalities Session functionalities integration with role restriction Service category add, edit, delete functionalities integration Add invoice and generate invoice Sales Report
Hi as per title, client can upload file according to the invoice. 2. admin/client can check/view the picture after uploaded 3. will show in admin dashboard who uploaded. 4. create in module and make sure no effect when whmcs update.
I have a excel file with existing vba code, but I need some changes to it for fit my needs. I attached file here please have a look. Here is my requirement: Once you open the attached file -> Go to the sheet: KANIFUMI KAMABOKO VN-2. Now the dropdown box is in column C. I would like to make it in Column D. Column D will get data from sheet Setting
I want to edit the VBA Macro code of a Word document. So I want from C#: Get the current VBA code of the document, edit it, and next replace the old VBA code for the new one. There are not complex code with many modules or classes, it's just the main code (thisDocument) that I need to edit / modify. If you know what I need and you know how do
...parameters and formula’s within Excel and now it is just a case of changing variables such as ‘Number of wind turbines’, “Number of Solar Panels”, “Battery Capacity” etc to find the optimum solution. Currently I can run the Excel Solver and obtain this but I need to write a similar more streamlined process into the Excel VBA...
Need someone to write macro for scraping info from links provided in excel. Lowest bidder will win. Thanks!