request

Hi All, I've spent the bet part of 2 hours trying to get this to work but can not seem to find a way to do this. At the end of the day after a user has entered all data into a user data form I want the user to be able to push a button and let VBA determine if the request is for tomorrow based...

Hi, I have the following WinHttp request code that opens an ASP.net page (using .NET CLR Version v4.0.30319) on my website which returns data in the JSON format. The problem I'm experiencing is when WinHttp opens the URL, the Session and Application variables in the ASP.net webpage completely...

I have a worksheet that is used to request flight legs from my aviation department. At the top of the page, the user can enter the total number of legs (1-10) requested for the trip, and that will populate column A with the entered number of legs, and also through VBA, require that certain...

Hi We are working till 3:30AM and Networkday formula doesn't consider time. 1) If we receive a request on Friday after 12:00AM or 1:00AM it'll be considered as Saturday and Networkday formula does not consider this. 2) * If a request was submitted on 11:30PM and completed at 12.30AM it'll...

Hi Everyone! I know I'm close but I've hit a brick wall. I have a form where users fill it out and submit via email. There is a Hyperlink Mailto cell (O12:V15) that I want them to click and it generate an email with proper subject depending on cells within the form. Here's what I have already...

Hi all, i'd like to ask for any help for my request. Sheet1, my data in/out flow frequency for every week(updated once a week) Sheet2, my request. i need to process sequence & accurate: -by date, by time flow, by EP01IN/EP01OUT, EP02IN/EP02OUT.....(even more).... -Sheet2 is no necessary to...

I am trying to search for something on the spreadsheet. my code to search is below. the text I am searching for is this : "COST REQUEST EFF. DATE" Set FoundCell = SearchRange.Find(What:="COST REQUEST EFF.Date", _ After:=LastCell, _ LookIn:=-4163, _...

Hello everyone, i really need your help .. i am daily adding data like this into my daily report RAW DOWNLOADED FROM SAP <colgroup><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody> Request LI 13752408 10 30031716 40 30036782 20 30031492 10...

Hi All, I need formula help.. Total count of data is, 90,000 or 95,000 max. In my Col A, i have Types and the type names are.. In my Col B, i have Time (HH:MM:SS), some example for this.. note:- 1. output require in Col C. condition's to make formula.. 1. if its MR.. TAT = 4 hours per...

This is probably easy for you folks. I have a tab, "Request Form" where the customer will place the material they're requesting along with quantity and unit of measure (B3, C3, D3). The first tab, "Items Not To Move" has a list of materials that they are not permitted to request. So here's my...

Hello excel friends, I have an issue trying to make a button to send an email containing a PDF of a certain range on a certain sheet. The purpose is to send the worksheet to others, so that they can then fill in the sheet and send the information that i want from them back to me by simply...

Hello everyone I need a meeting request system. I've tried myself, but at this point I might need a little help from the community as I'm not an expert at all. The basic idea is as follows: 1. A bunch of command buttons in an excel sheet (setup by time, day and meeting room), and when clicked...

I would like to create a button to allow a sales person to send an e-mail to purchaser and populate the subject with fields withing the file.. so I have a sheet called Employees and in that sheet there is a table defined as "Purchasers" with names and e-mail addresses...

Hello- I have data that is in 2 columns where the Ticket # is in column A and the data from the ticket is in column B. I am trying to write a macro that converts the data to 1 row per request. The caveat is that 1 ticket can have up to 10 requests within it (number of requests vary per ticket)...

Hello all - Hoping someone can assist. Considering the data below, when the Request ID changes, I would like for Excel to return the number of work days that have passed by looking at the DispositionDate column. For example; 5 work days passed while Request ID 177 was being approved. Thoughts...

hello i have been trying to get the program to record the worksheet name into a cell but i could not get it working. anyone can advice? here is my code Sub ButtonPRGenerator_Click() x = MsgBox("Welcome to Purchase Request Generator.", vbOKOnly + vbInformation, "Purchase Request Generator")...

request = to separate the 10 trios, from each line of draw of 5 numbers, then in the group of 5 numbers it is possible 10 formations of three = 000 000 ... ten 000 the macro should be automatic when placing new drawings (updates)...

Request = separate pairs with repeating digits Ex = 01 21 = yes 01 32 = no The repeat can have 2 or 3 repeated digits The list has more than 4 thousand formations

Hello all, Please help me with a formula in sheet1 D17, to do this: (please download the test file from my Drive account) https://drive.google.com/open?id=0B9tH3lTneqQUdWkySHlqVGFNQTg - search for 16.10.17 in sheet2, column A, and copy the corespondent number from sheet2 column D, to sheet1...

We have a mailbox that receives work requests. We will use Excel to get the emails from Outlook, extract the work request information from each, and create a spreadsheet. Someone will go over the spreadsheet and assign names to each work request, and then VBA will "chop" the spreadsheet into...