member

I use vLOOKUP a lot, but haven't gotten into Index Match much. What I'm looking to do is get the column AR in the Sheet "Order Detail" to return the Name of an employee from "EMP List" by cross referencing the Store and Team Member ID. I can't use vLOOKUP because some employees have the Same...

Hi, For a few days now i have been having problems whilst making forms etc. Some good members here has advised the code or edit to use but when i copy from her & paste into my sheet i see errors etc. The member who put the advice here did not see any errors at all & as such worked 100% for...

Hello everyone! I'm not sure if I am just having a moment or what but cant seem to figure out how to pull in some data. I have workbook with two tabs. The first tab contains Member ID information. The second tab contains multiple diseases and episodes along with the member ID. Basically I am...

Hi everyone, Got a formula here that is calculating oddly. Not sure if I am missing something. =IF(AND(VLOOKUP(D23,D:P,11,FALSE)="Yes",G23=0),0,+Y23-Z23) The formula is FALSE (which is correct) so the bolded section is the part pulling the calculation of the following (the calculation is...

I run a report that I export into excel and it will have multiple names in one column separated by a comma. How can I move the crew members into their own column? <colgroup><col><col span="3"></colgroup><tbody> Current COLUMN A...

Hi I can do the following Workbooks("test1.xlsx").Worksheets("sheet1").Range("a1:b1") = "test" to me that means "Worksheets" is a member of "Workbooks" class; otherwise excel would not accept: Workbooks.Worksheets But when I check the members of "Workbooks" class, I do not see Worksheets...

I have attempted to search for the answer to my issue but even though there seems to many posts similar, I have been unable to adapt any of the solutions provided to achieve my desired outcome. From the answers I have read it appears to be quite simple but being new to VBA I have been...

Good morning, hope everyone is getting a nice three day weekend and has a safe and excellent holiday I've looked in several places for an answer and searched my books and can't seem to find an answer, I'm sure it's something I'm overlooking or just not using the right terms for searching. It...

I'm banging my head against a wall here. Can anyone help? Bascially, I've got a structured table where the last x# columns are week ending dates for staff and the user will fill out hours in each column for each staff member. However, the trick is that each staff member may be on multiple...

Was notified that I received a pm from a member. But I cant open it. Its like theres no messages there. Anyone can help?

I made a table with several links to other spreadsheets for our membership files, however I missed a member who I need to add. So I am trying to add this member but it will not let me without this message popping up, "This wont work because it would move cells in a table on your worksheet."

Some how I'm making this hard. trying to use VBA only I have a master list of Names on sheet "Member", First name in Column C, Last name in Column D, ID number in Column A I have a second sheet "Sheet2" with combined names in Column I. ex: Bill Gates I need to loop through the names in...

I get lists from our offices where they have multiple records for one employee. I would like to highlight those cells where the first and last names appear more the once. In other words, highlight all the records that are duplicated using the first and last name fields (two different columns)...

In my procedure I save the value of a lookup data item as the name of a button. ie. member = Worksheets("Current Members").Cells(c, 1) <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000 ; background-color: #ffffff}span.s1 {color...

I have a spreadsheet which lists members who hold multiple leadership positions. I have an array that pulls positions from a different sheet. If they hold 3 different positions, then I would like the position to be on 3 rows, instead of one. Right now, for example, Joe Blow holds there...

I need to apply two different filters to a measure. I can do them individually but cannot figure out how to combine them. I want to get total pounds of linen per month. For a table "Forecast" <tbody> Start Date Member Linen Type Activity Weight Linen Group Feb 22, 2019 Member A...

Hi, Had a macro that worked, they have now changed the data. I have a column that can contain a name with the following after the name , space, then (Team Member) ie George Smith (Team Member) The next cell may have up to 6 names, each with (Team Member); after each name Gary Wing (Team...

Hi, I'm trying to help a friend create a Excel workbook so the church can track "Withdraws" and "Deposits". I have most of it completed, but I can't figure out how to "SUM" every 10th cell on the last row and give the results in the last row in the last column. Below is an example of one church...

I have a spreadsheet with six tabs (one for each team member) and one additional tab to be used as a dashboard. I'm trying to pull data from each tab and have it populate the dashboard tab. Each team member has the same layout on their tab and uses the same status names. So, Column E has a...

Hi everyone, I am trying to implement a count formula using sumifs but I couldn't wrap my head around it. I want to be able to count member depending on the code column. Anything less than or equal 3. Also, date will be another criteria. Trickiest part is amount will be a criteria for counting...