session

Hi - hopefully this is the right place to ask this. I'm working on coding a macro in Excel that will access IBM Personal Communications, cycle through 15-20 different screens, copy-append each screen, and then paste them all in Excel. I originally coded the macro in PCOM (version 13.0 if...

I am building a workbook to track training sessions. One worksheet will have fields to be completed for each training session. Some of the data would need to be copied into a log multiple times based on a couple of different factors: how many different documents were used in the training and how...

Morning all! Was working on an excel spreadsheet and could use your help please! Based on the table below, is there a function I could use to populate another cell with either "Yes" or "No" depending on the table's data? More specifically I have two separate sheets that are populated with...

Hello, I am trying to figure out how to count unique values in column C (session) based on 3 conditions. <tbody> Name Course Session Status Date John Writing Skills Writing Skills - May 9 Completed 09/05/2018 Kelly Writing Skills Writing Skills - May 9 Completed 09/05/2018 Steve...

Dear All I am not a massively experienced excel user and i am struggling to do a multiple look up and return in excel. I have read some posts but have got myself completely confused - apologies for my lack of experience and understanding! I have a list of people that are assigned to sessions...

Currently use BZ v6.1 web so the connection I use is the code to connect and interact with BZ Set host = CreateObject("BZWhll.WhllObj") h = 1 '== SET SESSION NUMBER '=== CHECK WHICH SESSION IS AVAILABLE ============ host.OpenSession 0, h, "S:\BlueZone\test.zmd", 10, 1 host.waitready...

I've got a web page that I can send a generated URL and the page returns some XML that I then parse and insert into my spreadsheet. All of the URL creation and XML parsing works but there's a problem with trying to run this in the real world. The website requires that the user is logged in in...

Hello all, Can someone please tell me why my code is not looping? It should be looping normally but it's not. Sub AddCorrectRanges() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim rng1 As Range Dim rng2 As Range Dim rng3 As Range Dim...

Hi there, I'm trying to randomize the forms we use for study participants for two different sessions without repeats. Specifically, at session #1 , participants are randomized to receive Form A, Form B, or Form C of the same measure. For session #2 , we want to randomize what form version...

Say I have 4 quizzes, and there is an optional Review Session. Student gets either 100 or 0 for attending/not attending the review session. If student attends the review, their lowest quiz scores will be replaced by 100, provided the quiz to be replaced is at least 70. Please note that there...

I am implementing some error checking in a form and want to ensure that the user cannot put in dates that are in the future or where Session Date is before DOB...here's my code: If CDate(SessionBox.Value) > Format(Date$, "dd/mm/yyyy") ThenMsgBox "Session Date cannot be in the future, please...

Hello all, and Thank You in advance! A sample data set is below. I'm trying to write a formula that tells me the total session length for any given date. In the data set below, the output I'm looking for would be 5:17 (3:04 + 2:13). There are only two sessions, one from 8:29 to 11:33 and the...

How can I tell when an excel file was opened and closed and the session time?

Is there a way to create an IF statement that will locate a cell and if they find text to return something particular or keep the current value? My IF statements are rusty. EXAMPLE: ColumnA ColumnB Description Contact Type Travel A Session...

Hello! Currently, I have a set of raw data that has a time-stamp for each question, each session and for each individual. For example: <tbody> Subject Session Question Time 1 1a 1 08:59:22 2 1a 1 09:00:13 1 1a 2 09:01:58 2 1a 2 09:01:33 1 1b 1 08:33:24 2 1b 1 08:31:22 </tbody>...

In column B, the following options are available: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>Session 1: Sunday July 1st – Friday July 6th, Session 2: Sunday July 8th – Friday July 13th, Session 3: Sunday July 15th – Friday July 20th...

I've tried using a pivot table for the following but I can't seem to get it to work. Basically my raw data has 500 names (I've just shown a sample below), a year group against each name and an activity against 3 different sessions. I want to be able to summarise the data as shown below (so...

Please help. I am working in Power BI. My primary data table has a variable called "Distance" which is recorded within three levels: "Session", "Athlete" and "Drill". In other words, within each Training Session, multiple Athletes participate in multiple drills, all of which have an...

Hi I want to write a formula =sum() and select cells from different file as an argument to this function. Lets say I have the formula in a file called ABC.xlsx and the data in another file called XYZ.xlsx. I noticed that to do that I need to open both file in the same excel session (program)...

Hello guys i have attached images of the file that i have: Main sheet: https://imgsafe.org/image/0a2759f0ff Data Sheet: https://imgsafe.org/image/0a275c795a I am collecting information from 12 departments and i need to collate them all into one sheet. Each department has it's own tab where...