submitted

Finding last occurrence cell of a mu <tbody> Item Action date ACTION TYPE PERFORMED BY Action date ACTION TYPE PERFORMED BY Action date ACTION TYPE PERFORMED BY Action date ACTION TYPE PERFORMED BY 45685 2-Jun-2019 Submitted (Jansson [Requestor]) 4-Jun-2019 Submitted...

Hi all, I am trying to automate a number of forms we need to submit on a weekly basis with the same details. I have tried writing a VBA code for this however I get an error once i read the first elementbyid. Sub SubmitSpark()Dim IE As Object Application.ScreenUpdating = False Set IE =...

Hello, I am trying to have contents in a cell in column 9 (Column I) to delete once the user selects SUBMITTED from a in cell drop down list over in column L. Once the user selects SUBMITTED it needs to delete the contents in Column I or 9 on that same row. I have this working for when it calls...

I have been trying to determine if I have indicated anywhere to be notified by email of replies to my submitted posts, but do not see this information anywhere. Please help!

Good day! I am creating a Shared Workbook and need to create a dynamic table based off of the CurUser (defined name). Want to know if this is possible. Table1 (Dynamic) <TBODY> ID # Correspondence Name Submitted By Submitted On Due Date Last Action Taken (LAT) LAT By...

Hi guys, I'm trying to code a submit button for my VBA userform although I'm a bit of a novice and this is a bit of a complex project! Here's what I'd like the submit button to do when clicked: 1) Send a notification email to abc@xyz.com, subject "new AOK has been submitted!", Body: "We've...

Hi, I receive an automatic dump of data on a weekly basis that looks like the below Table A. Basically, the first column is by category and the remaining columns are by week. How would I summarize the hours (found within the text) into Table B, which would summarize it by category (A,B,C) and...

Hi, I am trying to track my Retail Employees via Excel. They submitted their responses via Google Form which have various Leave Types like Annual Leave, Medical Leave and etc. Form Response 1 is their responses, but I am trying to do a LookUp Table to add on their leaves for the entire period...

Hello! I need serious help creating a formula that: 1. Calculates the time between two dates - submitted and printed I.e Submitted date 03-Jan-2017 16:33:46 Printed date 04-Jan-2017 12:39:48 2. And secondly shows as passed if lower than 24 hrs, or failed if greater than 24hrs. Thanks...

Hi All I hope this makes sense to some of you! Because after my fruitless attempts it makes less sense to me now that when I started out! I have this data (this is a fictional representation of the names!) in an excel worksheet tab called "Confirmation Forms" - <tbody> A B C D E F G 1...

Hi Guys. I so badly need your help. Here's what I wanted to do. I wanted to know if the following names from Table 1 have already submitted the documents considering that they submitted it after the Actual Date with the same infraction. Table 2 shows the documents submitted. I need a formula...

I'm working with the following table: <tbody> <tbody> EVENTID PAGE STATUS TYPE JOBID TIMESTAMP Time Elapsed: Days Time Elapsed: Hours 49239521 Scheduler Created Private 6622643 Wednesday, June 28, 2017 UNDEFINED UNDEFINED 49239522 Scheduler New Assigned 6622643 Wednesday, July 5, 2017...

Hello, I am stuck with one calculation and would appreciate some help. The data which I am having is showing how many work orders of a particular month were finalized in 1st week of submission, 2nd week, 3rd week, etc. Any suggestions on how to calculate the average time (number of weeks)...

Is there a way for the combo box to show the last item that was selected? if they choose Apples then submitted their data can Apples then show up in that combo box next?

I have two columns, one is an ID# for a particular institution submitting data and the other indicates the type of institution level. An institution might have submitted more than once and each submission is a new row. I want to know if each time the institution submitted, the data is missing...

I have a spreadsheet with multiple columns, a "submitted date" and a "predicted date" (which is 7 days after submitted date) also 3 status columns, "accepted", "accepted as noted" and "not accepted". I am trying to find a formula that will say if one of the 3 columns is not filled in by the...