I have a certain form in access I'm trying to make, where combo boxes are filtered based on selections of the previous combo box, and the last combo box ...all the combo boxes in it, but I can't quite figure out the SQL to put on the controls to make it work the way I need. Should be a super simple task for someone with Access, VBA, and SQL experience
I need a freelance developer who is very familiar with Bloomberg functions in excel (mac and windows). I need someone who is based in Dubai. Please send your CV with professional picture to email@example.com.
Need an excel VBA that can highlight duplicate emails for multiple rows. I know Excel's built in "highlight duplicate" already highlights the exact value of 1 cell to another. But what I need is a little different: Some of my cells contain only 1 email ad, while some contains multiple email ad in one cell, separated by semicolons. What I need is
Create and Run a macro that wil copy automatically many cells by changing some values like Year. Some values are repetitive and we don't want to copy them everytime because they have to be duplicated for 10 years. I want to be able to give a range of years and define the cells that need to be copied.
...As Range Dim xCol As Long On Error Resume Next [login to view URL] = False Set Rng = [login to view URL]("Please select the url cells:", "KuTools for excel", [login to view URL], , , , , 8) For Each cell In Rng filenam = cell [login to view URL](filenam).Select Set Pshp = [login to view URL](1)
I want to Synchronize Between Synchronization Between Desktop App and Web App SQl server And C# or VB Automatically and Schedulable .net and Software Architat
...need an excel file to filter tables in an interactive way (working with macros/vba etc.) What i need is showing different locations (tables). After clicking on an item, there appears a list of different items. And when you click on a specific item, you see few data numbers (results). See this link about vba [login to view URL]
I need the expert for Python 3, PostgreSQL 10, API integration and VBA knowledge an absolute MUST. Details will be share with winning bidder. Please bid if you are expert.
...specific data on a daily/weekly basis. Based on the few conditions , it has to be put into specific cells in the main database with minor manipulation. Looking for an expert excel/VBA freelancer to assist . Sheets DQ-45, DQ-46, DQ-47 & DQ-48 are identical. However they represent 4 different people who move to various locations . On each location various
...automate tasks in Excel by writing so-called macros. This is for a project repeated every 3 months. Attached are the spreadsheets we have put together. I also attach the end result which gets fed through the excel information. We take the financial statements for ten banks in one given country. We then input all info on to the excel model. Only on the
we have a database in Microsoft Access and we want relied this a management planning for our drivers. please disc...Microsoft Access and we want relied this a management planning for our drivers. please discuss in private for more details not need you share with me your other skills, I want only VBA developer and if you share other skills I not reply
I need a VBA script that will use the spreadsheet and create outlook emails that will send to each individual recipient listed. Example email body: Hello, I see that PO# (value from spreadsheet) was not picked up yesterday. Can you please advise if this freight is ready for pickup today?
I am an individual who wants to develop a prototype app from an Excel which uses a VBA uder-defined function. I have no plans to make this commerical yet, I just want to see what is possible and at what price. The minimum viable app will be called "Mr Simple" and will need to work on Android and iOS entirely offline and the app must be capable of
Need someone expert in Excel. I have an excel file and i want to translate it in English. Also it downloads data from web, and i need to have it online, so i need to transform it into a googlesheet file.
We have an input sheet with multiple columns where each contains number of alphabetic variables ranging from 7 to 60. Obj...Example input data: [login to view URL] I have highly detailed instructions written out for this project that I can provide upon further discussion.
Hi, I have a VBA code written in excel file (macro). It performs the calculations. I will provide you the code and I need someone to provide detailed description for each line of the code. (eg. how code works, what each line does, what each line means etc.)
I just need a form where I can enter details and that should be added to my access database, it's very simple. You should only use VBA code in MS Access, no other language or inbuilt feature of MS Access. I will give you all the table related information
Need VBA to sum numbers. First, the VBA looks into column B to identify product category. After it looks into column D. In column E it creates the sums with a MAX value of 800. As you can see on the picture we have many sums within the same product category.
Hi there! I have been working on an excel vba macro that transfers data from one workbook to another. The part that I am stuck on is how to transfer several rows of data from one workbook to another and at the same time setting things up so the next time data is transferred, it will go under the previously transferred data. The majority of the macro
...pricing program in Excel and need assistance finishing it. For this moment you are bidding on debugging the macro "Building 1" Located on the "Quote" Worksheet. The winning person will: *Have advanced knowledge of Excel. *Be able to start immediately *Be available for hourly work over the next 10 days to assist me complete the project. *Normally works
Desired output is an Excel (Mac Version 14.7.7) spreadsheet which prioritizes restock from vendors by sales volume and/or profitability. Inputs are two data files exported from Quickbooks ("sales" and "stock") which are attached. Note that these data export files can be modified to some degree if required. Also, "sales" data file includes data for all
I need a faster VBA macro. It's important to mention that the data I intend to scrape needs expanding to view the data required. It's like vertical tabbed content if you will. XML http is faster you can use it or other way but goal is fast vba. Apply if you can deliver this and pls do so within my budget.
Some Solutions Require in Already Made & Running Project in VB 6.0 Only Person Contact who have strong knowledge in VB 6.0 Must Understand Hindi Language & Require Face to Face Meeting Also Reward if problems are solved
I am looking to get someone to create a VB Script to create a button in the Quick Access Toolbar in Microsoft Word 2016 so that when a section of text in the Word document is highlighted, and the button is pressed, it will find a document (usually .pdf) within the same folder that the word document was opened from or child folders and create a hyperlink
I need a XXXXXXXXX expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
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.
...higher in Computer Science or related field • Solid understanding of MS Access, MS SQL Server database technologies and experience with SQL query/SQL programming • Familiar with VBA scripting programming and C#, .NET skills • Experience in system administration or development is preferred • Open to fresh graduates who have a passion in the data-related field