I need help with developing a VBA code for the attached example document which essentially only uses two functions: copy-paste and goalseek. If you can develop and implement the code in the attached document using the named ranges, then I can import the code into a confidential document it shall be used in.
I have some issues to be solve immediately in database I have. • Responsible for MS Access, MSSQL database administration and management (capacity planning, installation, backup, recovery, monitoring, optimizations, troubleshooting, etc.) • Support the development team for database design • Review existing software architecture and contribute to improving
Need Excel VBA macro to Get EndDate+Time from StartDate+time and Duration (hours) Requirement 1. The calculation should account for holidays (see holiday format below) 2. The calculation should account for workdays (see details below)
I would like to create an application that will integrate with Microsoft Outlook 2016. VBA and .net framework are definitely a requirement for this application. Some design experience would also very helpful. It would be ideal if we can determine if this application will also work on Outlook for MAC. I would like to be able to create a full CRM, Document
I have to sort Bill of Material data that I am getting from Inventor and than associate additional material to that data and arrange it in a pre-defined format. Images attached are explained below. 1. BOM (Bill of material) exported from Inventor.(saved as "name of [login to view URL]") 2. Workbook 2 (can be called as Association), In this workbook, sheet 2 should have the macro that pro...
These are Dynamic formulas w...please read through the attached carefuly before bidding or accepting the project. The formula are DateDiff but the formula depends on whats selected in one of the fields on a form in the database. My Max price $45 US. Please Dont bid more. If you know what you are doing this will take you less than 30 minutes to do.
Looking for an Excel expert to create a spreadsheet for entering parts onto our ERP System. The purpose of the spreadsheet is it will capture all the required fields to be entered and perform some basic error proofing, such that we can see that all departments have entered the relevant data. The spreadsheet exists and pulls some basic information from SQL for error proofing and selecting correct o...
Pls refer to the sample f...phone number(this is companies list in Jordan, mobile phone number contains 77 and 79) and email from the excel? I can do it in manual, but too many files and I think excel VBA could handle it in short time You can see phone number and email locates in several columns, not seperate one, increasing difficulty in manual work
...Input Box to prompt User to select 2 Cells of Date - Named/ Customer Name and Project Name 2. Copy that Data 3. Open Another Sheet in the Same Workbook 4. Unprotect the sheet 4. Insert a Row into a table named Active_Jobs (row to be on top of table) 5.Paste the Date in Cells A6:B6 which would always be the first row of the table 6. Protect the sheet
I have two tabs that need combining and a batch of PDF invoices created. One tab is a database of sales transactions (Value, Address, VAT number, etc) ('Invoice Back Data') and the other with an invoice template ('Invoice Template') which needs one order per template. Currently the template is linked to the order. The macro will need to produce a pdf invoice for every order on ...
We have a single for form in MS Access accdb 2016 for collecting asset data during a site audit of furniture, fittings and equipment in a commercial site. The form needs to have a button and image control to take a photo using the tablets built in back facing camera. We are currently using a Samsung Galaxy 4 tablet with Win 10. The image would be saved
Need Excel VBA (Macro(s)) for building an Excel database in an existing spreadsheet, and backfilling data changes/updates made in one worksheet of that workbook read to that database back into separate database. The macro(s) will allow users to change or update data inputted in one worksheet, and have it copied and pasted (values) to another, then another
Hello, I found a little company. All the entries my expense and revenu are organized in a excel spreasheet. I have my budget for each location. I'd need help to how my entries in my ledger can be linked to my budget so everytime I put a need entry with a refresh it can updated in the budget in column called actuals.
Hi, I have a field 'Field' in attached excel and I want a VBA code that will loop through the column values in Field and create a new field 'Field2' which will flag 1 when loop hits the last value in the Set of same values. Finally, the macro should delete the original Field, retain Field2
If [login to view URL] = 8 And [login to view URL] = 25 Then If [login to view URL] = "" Then Cells(8, 24).Value = "" Else Cells(8, 24).Value = Format(Now, "HH:mm:ss") End If End If End If i found this code on internet, but it does not work on excel table.. i want to update timestamp on a particular cell (cell A) based on changes that happ...
Working with Outlook 2010 - Inbox and any sub folders. Have set up various Categories, which are assigned to an email via Quick Steps. When s...assigned to an email via Quick Steps. When sorting by Categories I want the 'Done' Category to Collapse, so that no Category 'Done" is visible. I assume that it will require VBA, but open to other options.
We are looking for Freelancers that can help us in building a solution where we can upload products from an MS Access database to WooCommerce using their API. [login to view URL] We would need an expert in communicating with the Woocommerce API and Parsing XML data. The goal is 1. Automate and
Hi, I run a warehouse. In order to manage our inventory dispatches to our customers, need to build Excel tool (using VBA and macro) for inventory management. Need someone who is very good with VBA and excel macros. Thanks
I need a salary tracker, that will determine my gross and net pay also will counts days worked. I need this to also once it get to 170 days worked, on the 171 day plus wi...hours, it will calculate a set day rate . I'm including this sheet as a guide, but I'll be looking for something new from you, not the same one. You will need to be able to do VBA
I have a database with the Tables in it. I need work done in Macros and VBA. No SQL. See the Attached Power Point for Project description and See the Access Database and Excel workbook for examples and more explanations. I need this in the next two days ( I need it Tuesday). If your late I will give a rating that reflex that it was finished late
Looking for freelancer who is well versed with Excel VBA to be used on simple finance question. Looking for someone who can help code out NPV and IRR values for the scenarios, create a graph visualizing the NPVs. Drop me a message if you are into this
...in years and months. I can work out the ages in years using the datediff function but can’t work out how to refine that to include the date as well. I have no experience with VBA codes....
its a small project for that i volunteer for
This request is for a MacBook! I have a folder with several sub folders, and sub folders within those folders. In these folders I have s...these folders I have several excel files. The excel files all have the same format. I need to compile certain cells from each file into a table. I don't know how to write the VBA code and need help. Thank you
I have this worksheet with dates in column B, and name in row 1 and sub headings in row 2. I have set up this userform, so the user can select a name, choose a tra...have also defined the name row as name in the worksheet. And here is the code I have developed so far, could someone please kindly give me some advice as I am very new to this VBA coding?