members

If I have a range, C4:G4, where I want to place an "X" to indicate a size, but there can be no more that one "X" in that range, is there a way to do that with Data Validation, or will it have to be VBA? This is a sizing chart to send to members and them to mark...

I have a roster of members that have joined our non-profit organization. I have their start date and for some their end date. I think I am looking for a formula but just can't figure it through. I'm trying to get a running total of number of members per quarters starting with our first...

Hello Friends! It can happen to everyone from time to time. When we post questions, help requests etc, some forum members are replaying with no answer or the problem is just above their skills. They are asking for some explenations and the post is getting more and more replays with no...

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 number of members that I need to exclude from a particular query. What I did was to have a string of Not Like Statements in the criteria section of the query to exclude these members from the query. Is there another way to do this in access? This is the what I presently have and it...

I have to create directory reports for members who hold leadership positions within our organization. Some of our members hold multiple leadership roles in either Local, state or federal positions. Say, for example, I wanted to create a query that would exclude all members that held federal...

I am running MsExcel 2016 and Outlook 2016 I have a large master worksheet that contains many members names and addresses and contact details, including email address. Members are in different groups (300) and members in a group are linked by a common ‘secretary’. e.g. 30 members are associated...

Hi I have some excel documents that calculate wages for band members depending on certain criteria and band cost. However I want to reverse it so I put in the criteria, enter the band member hourly rate and works out how much the total quote is. It’s difficult trying to explain without showing...

I'm a relative novice when in comes to excel. I know my way around the basic formulas and even delve into if then formulas in excel, but I have no experience with macros. I thought this would be a relatively easy problem, but I have searched for an hour and not found an answer. Here's the...

I've created a VBA-based query that uses a worksheet cell value as an input parameter. The query uses an Access database and returns with the desired record(s). It works just fine BUT....I get a new "Connection" listed in my Data - Connections and a new "ExternalData" range name listed in...