...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 Management capabilities, and a Windows File Explorer functionality
...this workbook, sheet 2 should have the macro that processes the data and give the output on sheet 1 and than saves it as the same name but can be with .xlsx to have the excel file in same folder. (This is open for discussion,to find out the best way to do this). 3. For association part I have one database excel sheet that I have attached. It has info
These are Dynamic formulas with IIF statements. There is a variable in the formula so they are not basic or simplistic. So 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...
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
Pls refer to the sample file of the attachment. Is there any way could pick mobile 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
Need Help writing a Macro. Would do the following; 1. Show 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) [login to view URL] the Date in Cells A6:B6 which would always be the first row o...
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 to a nominated directory on the tablet HDD a...
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.
...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 import/export of products from Woocommerce which would also include images for these products. 2. Update Quantities on existing items in Woocommerce
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
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. ...within those folders. In 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?
I need certain quite simple VBA macros written, which mainly do copy/pasting from excel file to another excel file, number searching, etc, quite simple operations. I will be available online as you work, so you'll receive all guidance real time. Project starts asap.
Will discuss over chat i have lot of work to discuss
I have a list of people in excel, who each h...people in excel, who each have a unique msg, that I would like to be able to send as msg or picture in wee chat to their wee chat account. I would like automate this process by vba code or similar to scroll thru the list of people, update the msg each time, and send it to the relevant person via wee chat
Construction business and we use Excel to create estimates. When creating estimate for complex...worksheet (create copy of original) to mock up different options for customer. Would like to use VBA to create a 'Comparison' tab which shows the highlighted cells (yellow) for each of the tabs on file. I have attached a very small mockup of actual file
In my company, we use a macro PPT and EXcel to help us copy/paste elements ; we’re experiencing bugs and need the support of an expert in Microsoft VBA programing to refactor in full the current macro. Need a native French speaker to run the project.
I am on Microsoft Visio 2010. I need a module written to sort all of the sheets in my workbook alphabetically. There are over 300 sheets. The data is sensiti...for someone in the know, I found a guide online but couldn't get it working. [login to view URL] Thank you
Hi, I need an Excel formula or VBA function that will extract all occurrences of a string, it’s an src=“[login to view URL]*/*” string, where the * can be different text. There can also be multiple src strings in one cell. I need all the src strings to be copied into a new column. File will be shared in messenger.
...minute promotional video for a VBA application that I seek to develop into a mobile phone application through using crowd funding. The VBA application is already developed and a video of the working prototype will be used in the promotional video to encourage people to support making it into a mobile application. The VBA application runs over the course
I need someone to build a macro for me that can enter customer data from excel into a webform The form consist of 2 drop downs and text fields. After...is a popup where you have to click OK then another confirmation where you have to click OK. should be simple. I need it to add the word complete to an open space in the spreadsheet after each is done.