I need to create a macro that formats a raw data coming as a text file, create several tables and graphs and then create a powerpoint slides with that information. the raw data change in size each week.
...spreadsheet with data. I need an Macro and VBA expert to help with data extract，need to update accounting related excel based reports for the following features 1. Auto-predict dropdow that start showing values as soon as user starts typing. This should work same like the auto predict works on google search 2. Automated report generation from raw data. We ha...
...needed to form the URL: -IP address -Username -Password The above data should be stored locally by logged in windows user so they don't have to enter it each time they use the app/outlook. If the user changes these settings, the links should be updated accordingly. VBA (or other related code) should be commented and unlocked and will be a required
I have a sheet in excel and want to use a macro that creates an exact copy of that sheet but renames it (according to what i put in a dialog box when prompted) that works off of a button. Once I go to this new sheet I want to be able to make changes and use conditional formatting to highlight cells that are different that the other sheets. I have all
I have an excel spreadsheet of email addresses and order numbers. I need a macro that can parse the data and create a spreadsheet of the email addresses of customers that have ordered three or more times (meaning there are 3 different order numbers with the same email address).
I'm looking for someone who can take our current Wordperfect macros, and create templates in Word, to do the same thing that the Macros were doing in WP 15. There is no conversion process, so the wheels will need to be recreated. Long time WP environment, that is moving to Word.
...you: - Do not read EVERYTHING CAREFULLY - Copy/paste pre-written replies - Use technical jargon/terms as html5, wordpress, java, drupal, CMS, joomla, API, SQL, xoops, xml, vba, etc. We help freelancers understand objectives and let them use imagination, ingenuity, talent and creativity. Please NOTE CAREFULLY: we will not award the job based
At the moment I have inserted VBA code into my spreadsheet to allow for clicks of the mouse to add or remove colour. When I try to insert code, in combination with my own code, to protect certain cells or use unlocked/locked functions it will not work. I need somebody to write some code that will allow me to still protect certain cells and click to
I am looking for an Excel and VBA expert to create a spreadsheet capable of generating lists of names. For example, out of 8 names, I want a list created by choosing only 3 names at a time - which should produce a list totaling 56 combinations. It is a "n choose k" combination problem without replacement where order is not important. For the list,
I currently have a macro for an excel workbook that contains multiple worksheets to; 1. Set page settings including page margins 2. Prints worksheet to PDF and the file name is defined per cell A1 Once complete, the macro moves to the next worksheet and repeats process 1 & 2. Macro Enhancements... 1) I would like the macro to calculate (refresh)
...Commerce inventory files through their API. Because I need to be able to tweak this over time, I need this to work within Excel 2007 VBA. I have done this in the past using web tools ([url removed, login to view]) with success. Specifically I need to be able to update the Products Fields: [url removed, login to view]
Attached is a tiny c# project - it amounts to less than 50 functional lines. It logs on to an Azure web service, sends a request and receives a numbe...tiny c# project - it amounts to less than 50 functional lines. It logs on to an Azure web service, sends a request and receives a number. I would like an excel spreadsheet with vba code to do the same.
I want an excel VBA to send a PDF attachment through Whatsapp web to a phone number. My excel file will have the phone number and the path to the PDF (locally stored on my computer). The macro should be able to retrieve the PDF file and send it to the phone number indicated through my Whatsapp Web (I will be logged in).
VBA project, automating population of word documents (test sheets) from excel with multiple versions of office. Existing system struggles with different versions of Microsoft Word Object Library. Also needs to be easily expandable for new and different test sheets. Test sheets are a controlled document which sit on a server in a separate folder to
I would like to create a macro that consolidates the following; > modify page setup settings (macro active) > print worksheet to PDF and file name as per A1 (macro active) At this point in time I run each macro individually for each worksheet. I would like to create a macro that consolidates the page setup and print to PDF for each worksheet and