health

Hi I have an excel sheet with two columns <tbody> ABC Org Assist Prod-Pers Care/Safety Disability Safety Whole Family Health Interpret/Translate Assist Prod-Pers Care/Safety Personal Mobility Equipment Early Childhood Supports <tbody> Visability Ltd </tbody> Service1...

I have a spreadsheet with 2 separate sheets set up as follows: Assignment: <tbody> Department Bucket Shift State Product Home Health Nights Toys Nights Sporting Goods Nights Grocery Days Toys Days Furniture Days Pets Days </tbody> Summary: <tbody>...

I'm using the following formula to automatically determine a form specification based on whether the user selects custom questions or custom questions in conjunction with a specific client but it keeps returning an error message that only tells me there is a problem with the formula. It's...

Hi, I have a table with various columns. Cells in Column A can contain one of "First", "Same", "Last", "Unique". Cells in column B specify whether or not a client is homeless. So cells in this column can contain any one of "Homeless", "Not Homeless", "N/A" Finally, Cells in column C specify...

Hi all, I am doing a vlookup on loop and it is taking a long time to cycle through 20,000 rows. I am new to arrays, dictionary etc so looking for some guidance on this one. Much appreciated. Here is the code that works fine albeit slow along with some sample data: Sub test() Dim rng...

Hi, I am trying to check to see if two cells in Sheets("CHECKING") or (ws2), correspond with values in Sheets("Category Hierarchy (5)") or ws3. In row 1 of ws3 there are "Departments" and below that department from row 2 onwards are categories and these categories are unique values to only one...

Hello, I wonder if anyone can help me. I am a complete novice at VBA so please excuse me. I have some code, which opens another work book, "saves as" in a different folder then deletes the file. This is done to keep the links on a linked document when moving the linked documents. I want to...

<tbody> <tbody> Youth Service - NEET / Youth Payment, Support and Training for Service Providers - Education, Programmes for Young People, Elder abuse,Local Community, Elder abuse </tbody> <tbody> Intellectual Disabilities, Finding work, Community Courses, Work </tbody> <tbody>...

01-12-2018 Greetings, My question relates to my desire to use a spreadsheet to compare various Medicare health plans – and I thought this group might have some ideas. Background. I’ve gone to Medicare.gov to obtain information about available Medicare health plans – and I find the site...

Hi all. Bit of a newbie to the excel world, most work ive done has literally just been going through googling and piecing bits together, so my knowledge and understanding may not be all there so bare with me :) A friend of mine does D and D roleplay and I said id try and make him a spreadsheet...

I have a large spreadsheet of San Diego businesses and their employee totals and a whole group of them start with VVSP which is messing with my sort. Is there a way to remove the VVSP from just those cells without affecting the rest of the data in the cell? Example: VVSP Sharp HealthCare VVSP...