challenge

Hello All, I have this code for clearing data from certain range of some sheets in my workbook. What I want the case statement to do is to pick sheets that I want to exclude from the clearing. Sub ClearRange() Dim Wsheet As Worksheet For Each Wsheet In Worksheets Select Case...

Hi everyone, I am currently creating an employee scheduler using a Reversed Gantt Chart, one where the user plots the schedule in the chart then the START and END details are automatically updated (using formulas) while plotting. I used legends such as 0 - vacant hours, 1 - working hours, 2 -...

I'm an after-school educational assistant working with young kids with a focus on math. If I can figure out how to get this to work in Excel (Using the 2016 version), I'll be using these puzzles on a yearly basis (switching from addition/subtraction to multiplication/division ect.) Anyway, the...

I have a table that tracks a bunch of info such as, person, category, department, description, due date, and priority. I have, at best, extremely weak VBA skills, so I REALLY need help. Here is what I'd like to do, if it's even possible. I would like to have a VBA code that will...

I would like to have one or more macros to be shared with anyone working on the similar worksheets. I would like it to create a sequence to read like the following example: ABC-0001 ABC-0001 ABC-0001 ABC-0002 ABC-0002 ABC-0002 ABC-0003 ABC-0003 ABC-0003 and, start from a higher number...

Hi all, I am trying to use application.worksheetfunction.countifs in order to do a quick countifs across 4 columns where the follwing criteria is met. Column 1 (ref_Col) has values lower than £50 columns 2,3 and 4 have no entries and are blank cells. If the above condition is not met then do...

Hey everyone, I think this may be possible to do in Excel, but not sure. For you Excel gurus out there, here's the challenge: On the main sheet of a workbook, there is a list of contacts (in column A, cells A2 onwards. A1 is the heading of the column titled "Contacts"). In columns B onwards...

I'm trying to do an RFM analysis. I was given a Customer Database with multiple transactions per customer during a year's period. How do I sort through and find each customers most recent purchase, without sorting by Customer ID and then picking each one out from multiple transactions 220...

<colgroup><col span="5"></colgroup><tbody> Hi, I'm starting to work in a project and I know a little of BA, but I really need to do this macro in order to save hours of work a week. So I'm really thankful if someone can help me. I have to analyze some data from the prices of food. Week to week...

This might be difficult to type out but I'll do my best. I am trying to convert some financial documents to the current fiscal year, and in order to do so I need to change file names. No matter how many times I duplicate the files, they are still sourced to the original document, which we need...

Hi there. I would like to have a macro, that I can use. When I hover my mouse over any row, in the background eg. my mouse is over cell d4 , I want the whole row d4 to be highlighted. But note that it would be better to have eg a shape highlight the row and not a colour highlight such as...

Hi, I am trying to figure out a way to create a list in one sheet depending on the value of cells in another. I have in "Master List" sheet Column A the names of projects, and in that same sheet in columns I:L I have names of people involved. What I want to do is in another sheet (called...

So I am trying to arrange a set of data in which there are certain codes that correspond to numeric values. Basically, I need to either find a way to assign text values, or to sort through a complex function that I am not sure how to compose. The values in decending order are as follows: 16M...

Hey guys, I have been using excel for a long time now and I consider myself relatively good at it. However I have been having a headache trying to solve a kind of complex weighted average in a table like this: <tbody> Client name Broker Share Client&Share Quantity Avg Price (in Broker) Avg...

Team, I am using excel as a checkbook and would like to be able to Create a function e-mail button - specific to each row line item Assign an e-mail action to the button when clicked Once the button is clicked - it pastes the word "Closed" into a specific cell P7:P375 - pending which row is...

2014 ModelOff New York Live Finals (FREE) If you’re in New York City this Sunday, join leaders from the Finance and Excel communities to witness the crowning of a new Financial Modeling World Champion. Who will follow in the footsteps of Alex Gordon and Hilary Smart and claim the $30,000USD...

Hi everyone, So I have a challenge for you all. I have some code that I've written that works perfectly, but is a fairly slow and inefficient at doing it's job. Wondering if anyone is up for a challenge and wants to come up with a more efficeint way of handling this. Purpose: The code looks...

Hi all, I have a sheet as follows; <tbody> 1800 18001 18002 18003 1234 TRUE TRUE 1235 TRUE TRUE TRUE 1236 1237 TRUE TRUE </tbody> What I need to do is sort this so that; All 1800 TRUE cells are grouped together All 1800 + 18001 TRUE cells are grouped together All 1800 +...

Hey guys, I am new to this forum and new to advance excel functions. Currently, I am writing my master thesis and have found many of the tasks to be extremely cumbersome and time consuming when wanting to do it manually. Currently I am facing the following problem that I hope that you can help...

Hi all, I'm new to this forum. Generally i'm learning by reading others problems but, this time i couldn't find the answer. The thing is i'm trying to sort an alphanumeric column with different length size of letters and numbers. Here an example: a1 a10 a12 a2 bb1 bb10 bb2 bb4 The column...