...errors and PPT cant refresh the OLE data from XLS file. We manually have to correct the file location for hundrets of datapoints in settings. Goal: I would like to have a macro which has two steps when file is opened: Step 1: Do you want to refresh the data from XLS file? - Yes – Go to step 2 - No – leave everything a it is. Step 2: Let customer
...rows (the amount can vary). I need a macro where I can decide a percentage value and then have that many rows removed RANDOMLY from the file. For example, if I set the random value to 20%, 2000 rows would be RANDOMLY removed. If I set it to 10%, 1000 rows would be RANDOMLY removed and so forth. I need this macro for future use and I need it done today
I'm looking for someone to develop an Outlook plugin for windows that you login with a VoIP SIP extension credentials and whenever a call comes in it searches the number in Outlook and if it finds a contact it opens up that contact in a new window. If it doesn't find a contact it opens a new contact window with filed in the details from the caller ID
Create Windows Macro/ Bot Browse, Screenshot and OCR Selected Region Immediate start
Hi, I need a Macro to check if for each "ID" under column E, (Type) "Services" under column B exists. If it does exist, then any other row where Type <> "Services" for that same ID should be deleted. If type "Services" does not exist for that ID, then all rows for that ID should be deleted except one and value under Column C (Value) for that ID...
Hi there, I'm looking for a developer who can piece together a simple script or macro or app to grab data from CSV and post with that data on OfferUp. 1) You must be familiar with OfferUp app. 2) OfferUp App does not provide API. 3) OfferUp App require emulation of real mobile data entry, they do not allow for automation. 4) OfferUp is not a website
I need a Macro to check if for each ID under column E, (Type) "Services" exists, if it does, then any other row that has same ID should be deleted. If no type "Services" exists, then all values under Column C (value) for that ID should be deleted and replaced in one cell (whichever cell for that ID) by the amount that is in one cell in column D (amounts
Looking for an experienced Bot Developer to teach me 1 ON 1 (I've basic experience), How to build custom-made bots for web automation processes such as scraping, posting ETC. MUST HAVE PRIOR EXPERIENCE IN BUILDING BOTS FOR WEB IN JS / PYTHON. * Looking for a long-term tutor
Please see attached input spreadsheet and output spreadsheet. - Create new WS "Aggregate" & "Volume" - For each worksheet matching "Data-*" - Copy and Transpose cells area matching "Host Name:" to "Aggregate" WS - Copy and Paste cells area matching "Aggregate Name" to "Aggregate" WS - Forward fill cells area matching "...
We are Looking to have Signature of our Emails in outlook . with the Online access such as this website has [login to view URL] but we need Few Creative Work on Marketing where Banner get changed automatically . every one of our company staff has their Own Signature and that is acessable through Our Website Server as Online Storage
...and run macro once complete the macro, MS Access will export summary report in excel format and exit open 1st excel and copy data form particular sheet and range open 2nd and past data in required raw or column or end of the previous data refresh pivot table and formula select a fixed range data and copy form 2nd excel open outlook new mail
I need someone to creata python script or excel macro to scrap data
We are high-end Binoculars producer, with B2C / B2B channels. Sincerely invite you help design an outlook of kids binoculars. Requirements : 1. Targeting users : Europe & USA kids. 2. Style & Colors: fit in Europe & USA kids preference. 3. Based on our attached binoculars model parameters. 4. Design result: 3D modeling diagram, so that our factory
I'm looking for someone to develop a custom Outlook addin to connect to a SIP extension and when an incoming calls comes in it should give a pop up notification with the contacts info from outlook. It should be exactly like this: [login to view URL] but it should be able to connect to any asterisk
We require a macro for Access that will look at a table called Numbers which contains numbers 1 thru about 100,000 and determines which numbers are missing an places them in a table called Missing Numbers. I have attached a sample .mdb. I placed the first missing number in the table so you can see what’s required.
I get a lot of projects where I need to create complex user forms attached to databases in excel. I also have various types of VBA projects that I need done or excel projects. I need someone that has availability, speaks good English, and is a pro.
Have multiple excel files that need to match/cross reference columns, if matching occurs then it performs a series of pre-fill copy/paste data from another excel. Then if no match, then perform something else. This is multiple reports that will need to connect to each other on a weekly/daily basis and run output based on conditions that are met or not met.
Request: write a VBA macro that creates a button to duplicate template sheet based on the number of line items, automatically perform calculations depending on input values, create button to add columns for cost inputs, create button to show/hide added cost input columns. Starting workbook with notations is uploaded for reference.
I have two excel documents that that are modified daily into one. I would like a macro workbok that i can use daily to upload the document and format quicker. The colume/tab are the same. The formatting requries color, conditional formatting, and moving cloums around.
I require a professional but modern and classy email signature for outlook. We do not have a company logo so just a simple design of the company name, website, office address, my telephone number and of course name and job title.
Need an Advanced Frontend PHP designer to change the outlook and order of the checkout set in my Woocommerce. Optimized the outlook of our checkout pages.
offering $10.00 . I have a website hosted on Host Gator([login to view URL]). A domain [login to view URL] hosted on Az... A domain [login to view URL] hosted on Azure and I bought a mail service called Zoho to host my email service for email@example.com. I cannot get it to work in outlook properly. I believe there is an mx record issue.
I need you to develo...table with 100 rows and approx 200 columns. I also have a worksheet with a custom template to drop in data in specific locations from the large table. I’d like to creat a macro that will populate the template with row 1 and then print the page. Then populate with row 2 and print the page and keep going for the entire sheet.
Deliverables An excel macro that processes a standard, populated Excel workbook (containing projects and project date) to generate the following: 1. A PPT project deck that pulls data into pre-defined slide templates from the Excel workbook 2. An Outlook email draft pre-populated with a) Static subject + today’s date b) Attached the above PPT deck c)
I'm trying setup new rule for arriving messages. In our company are many public groups. Suppose we have # GroupA # GroupB TO: # PersonA CC: # PersonB I have set up rule, which is saying: Apply this rule after the message arrives where sent to # PersonB move it to the To PersonB folder But this rule detects # PersonB as recipient, so it moves the message to folder ToGroupB, which is not wh...
Platform:- Office 365 + Outlook 2016 We are looking for outlook add-in that will work on the outlook new item (email) to read the from/to fields and lookup an external API. The Add-In will perform a query on the api It will then display information from the API It will also allow a post to the API with specific information from the Email
Hello, I need a Macro for Excel written for me that will allow me with the click of a button to take values (item SKUs) from SHEET 1, search for it in SHEET 2 (a database of all items w/ descriptions in the 5th column), and paste the results in SHEET 3. Sheet 1 will have two columns that need to go into SHEET 3, quantity, and "DESCRIPTION". Quantity
I have a database with users and their grades (a value). Each student also have a field indicating the name of his manager. I need someone to create a macro in Microsoft Access to generate different spreadsheets, one for each manager, containing the users under his supervision. If possible, I would like to see the creation [REMOVED BY FREELANCER.COM
I have a spreadsheet with a list of websites in them. I need a macro to validate and check if the website is valid or not. Examples: [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL]