people

Hi I just wanted some advice really. I'm pretty confident with excel formulas and working but never use VBA so just wondering where I best to start to learn myself. What have other people find works best for them. Are there any good guides knocking about to look at Cheers Joe

Hi I need a macro/formula to pull through names of people if they have a value against a client onto the master spreadsheet I have separate client tabs, with people putting values against an activity. I have a master sheet which lists the clients under each column. I would like to pull...

Hi, I'm trying to find a logical way of doing a task that's not going to take me 100 hours, which I'm learning that this isn't a bad idea as it teaches me more and more about excel. I'm trying to the total amount of people showing up for duty on certain days. My call center sends out a...

Hello, I'm using the following formula on B2 =ROUNDDOWN((TODAY()-DATE(E2;C2;D2))/365,25;1 to display the current ages of a list of people on column A. E2 is the 2-digit year, and recently some people born in the 2000s have been added to the list, making my life difficult. If I type 2000 the...

Hi there team. So I have a 1 issue that has got me... Please help I have code that allows me to add a few values and divide them by the number of times someone works in a full week. but what i want to do now is after i have allocated the number of days each person works i want to deduct a...

Hi All, i am trying to find a a function that can filter a column of supplier codes (the column will have the supplier code in it between 1-??? times) then return it on a new sheet just once along with the supplier description (adjacent cell) eg: the source sheet <tbody> <tbody> 20935...

Sorry - probably not the best terminology in the title, but I haven't had my first coffee yet! I just wondered how those of you who work with spreadsheets that are edited by multiple users go on. I am our office's unofficial Excel expert (even though I am VERY far from expert). And I make the...

I am working on a sheet that will have columns Name 1, DOB 1, Age 1, Relationship 1, Name 2, DOB 2, Age 2..... up to 24 total. Info will be entered with a Userform.... and not every row will be filled with 24 people Form Uses the following code for each of the people 'Adult 1...

Hello, If someone has helped out with a problem and given the solution, how do you post a Thanks or a Like on their answer? I see that some people have received Thanks or Likes from people but I can't seem to figure out how the heck the person did it. Jenny

This is somewhat what I have. A The following people will be in Rm 5 B John Smith C Michael Townsend D The following people will be in Rm 6 E Jennifer Tucker F Samuel Rodriguez G The following people will be in Rm 7 H Allison Taylor J Jonathan Thompson This goes on for about 25 rooms. If I...

I may regret trying to do this myself, but I dont know til I try... First off, I dont know VBA code, but there are some people here who do, so this may turn into a reference thread for them to accomplish this, unless I can somehow manage to get it done with help from forum members who are waaay...

I have this information in which applicants for a conference are ranking their preferences for example (red, yellow, orange). What formula can I write so that I give the person their first choice, but then when that area gets filled up with more than 1/3 of the people at that conference it shows...

I am new to Pivot Tables and am having a problem with percentages. I have a Pivot table which looks like this Block Incidents Cumulative Incidents People Cumulative People Percentage Answer should be 1 47 47...

Hi all Can I share a workbook from the cloud but prevent people from downloading it or copying it? Thank you! Russ

I have another task in excel that I must perform that I hope you'll will be able to help me with. Once again I am allocating limited money however, this time I need to allocated the same to everyone in increments until the pool is exhausted. So its almost like dealing cards. For each round...

Hi All, I ran into a wall and hope someone can help. I currently have a clunky spreadsheet that will randomly distribute 16 people into 4 teams of 4 for our volleyball games. What I actually need to do is for the spreadsheet to distribute 20 people into 4 teams of 4, and hold the 4 remaining...

Hello, I am struggling in creating a Pivot Table based on two data sets I have. Tab "Population" contains a dammy data of population information. Tab "Distribution" contains a dammy data of an individual person receiving goods. The common denominator in both tabs are the column...

Hi I know Macros are written in vba code but I guess people usually refer to Macros when a user "recorded" the steps. Then the result of this recording is called Macro. But when a user open VBE and write the code, people do not call it Macro but they called code or sub. Am I right?

Hello, everyone This is my first post here and I have a question I apologize in advance for my bad English My girlfriend has a home for elderly people and I want to simplify her work I have an Excel workbook in which I have made several documents and two lists of people who are housed in...

Hello, I have a data set that is updated weekly. Multiple pivot tables/charts are outputted on a separate worksheet showing Top 5 or Top 10 jurisdictions, people, practice groups, etc. with the corresponding fees. The pivot tables/charts are already filtered by one of two main clients. However...