pre

A colleague has asked to see if there a way of creating a formula to calculate the progression that a group of young people have made through a survey folllowing a short course. The table below shows 9 young people and where they gauged their level of understanding before and after the session...

Hello, This is my second thread. I hope it goes as well as my first one in which I got all the help/tips I needed. I am an accountant who loves excel and has come across vba to put my love for excel on steroids. anyways - my boss heard I am good with excel macros (Lie - I am an amateur lol...

Hello, I have a formula that finds text between the second / and third / Hello/Waste Sludge Processing/Sludge Pre Conditioning/Sludge Thickening/Thickener Stream/PRIMARY SLUDGE THICKENER so for this I have...

Hi, Wondering if anyone can help with this.... I'm trying to make my code set up two filters on my sheet - the first is a date on column 39 (based on pre defined date dat minus 28days) and the second is to filter for containing not blank cells. With Sheets("OPS PLANNER")...

Hey folks Have a column (R) to populate with data depending on the answers in several other columns. I've started it with .... =IF(S5<>"",VLOOKUP(S5,'Look Up Tables'!$T$2:$V$29,3,FALSE),"********") Then in the ******* I need these options from cols AA, O & P to enter the correct treatment AA...

Hi, Overview: Macro to open various data source files and create CSV sheets to independently save down Process: Open source files, extract data, close file Problem: Some source files contain data not needed or after extracting data, post process is required. For this example, Timesheet is...

Hello folks, I am looking for help to work with pre 1900 dates by adding days. As an example i have a date of 1 Jan 1788 and would like to add (x) days to it working toward 1 Jan 1900 in multiples of (x) days when Excel starts to work. 7 Feb 1788 plus (50 days) = 28 March 1788. 28 March...

im attempting to create a workbook, that basically expires itself. id like this to no be visable on the sheets it self, but when a pre determined time or date comes up, the workbook will erase all content throughout and save. essentially making the workbook useless. is this possible?