requests

I currently have a VBA form (a worksheet with some text boxes) that lets me easily input requests sent by different colleagues, however one annoying part is that I have to always copy and paste my colleagues' name (which most of them are common "customers"). Therefore, I would like to ask is it...

I am running into an issue trying to count by employee and by month, the number of weekends in time away requests that span multiple months. In one sheet "EmployeeList", I have a column with a list of all of my employees and have columns for each month of this year and next (Jan 2019 through...

I've never used 365's PowerQuery before, but I'm told that it can handle exactly these kinds of requests. Here's a static Yahoo URL with all the stock option data for symbol AAPL: https://query1.finance.yahoo.com/v7/finance/options/AAPL But not sure where to go from here; following online...

Good Morning, Thanks in advance for your help. I have a complex sumproduct that totals unique values in a date range. It adds the request that are obligated and the requests that are approved: =SUMPRODUCT(IF((''!N2:N79conditionxyz<=C11)*('conditionxyz'!N2:N79>=C10)...

Hello all, I am inquiring about this here because i am seriously stuck. I don't know if the solution is simple or complex in truth i don't exactly know how to search for it. Here is a little background followed by my problem. I work on the service desk of a medium sized company we are a small...

I'm wanting to import a CSV file into an excel workbook, and previously had just recorded this operation and tweaked the code generated from the recorder. Now with the PowerQuery / Get Data features in excel it wants to create a query connection which seems like overkill for my needs. Is it...

Hi All, First time poster so go easy on me.... I have been learning VBA and applying it as i go to improve the function of the workbook. I have been working on a spreadsheet that records and reports on requests made. The data has been recorded for less than 6 months and is at approx 2000...

I hope someone can help me. ABC Company is responsible for processing and fulfilling repair claims for a luxury wristwatch manufacturer. ABC Company receives customer repair requests daily (7 days per week). The next business day, a box is sent from ABC Company to the customer with a return...

I'm trying to translate some Python code into VBA. I've tried adapting multiple VBA codes relating to APIs but nothing is going through. Can someone point me in the right direction. <code style="box-sizing: border-box; font-size: inherit; padding: 0px; color: inherit; background-color...

You know how you can put a spreadsheet on a shared drive, and then anyone can use it, but only one person can use it at a time? Well, I just got around that limitation. :) I work for a huge law firm. We send our closed case files to offsite storage, but we frequently have to bring some of...

I have a spreadsheet that is used to input incoming requests by date. a new row for each new requests received. in the same sheet in the last column i have some metrics that calculate how quickly the requests are dealt with etc. i have a data collection sheet on a separate tab to collate the...

I'm requesting stock quote data via RTD from my brokerage's server, but they have a limit of 50 quote-requests / second, and the server disconnects you if you exceed that. The worksheet is currently set to execute 500 rows of formulas at once (each requesting 1 symbol quote), which I need to...

The server I'm pulling stock quotes from has added a request-limit of 50 quote-requests / second; if you request more than that, it disconnects you. My current code requests 500 at once, so I need to revise it so that it spaces out those requests over 10 seconds. The way the formulas are...

Lots of threads like this, but not answer my problem. I tried to explain in a previous post, but my logic was wrong and I'm not authorized to edit my posts. My issue is similar in that I have two columns; Date of Request and Status of Request. For those requests in a PENDING status, I want to...

I have a workbook where I need to count the number of Requests that are pending and how long they have been waiting. I have two columns; Status of Request and Date Submitted. I need to identify those requests in PENDING status, then determine how many of them are less than (<)90 days old, how...

We use a SharePoint library for end users to submit requests for changes. Because they can submit multiple lines of changes, this produces an output file like the one below. I don't mind copying the data and pasting it to another sheet. However that can be quite time consuming when there are...

I have a macro that is designed to open files from a folder (Support Requests) and copy all the relevant data from each to a database file (zzMasterSupportDatabase). It copies all the information needed onto the next empty row in the database. Right now it is set to run for all files in Support...