Forum Widgets
Latest Discussions
Help with VBA Code
Hello Experts...I am a novice, self taught, old golfer who has developed a workbook for calculating our golf game. The part I am struggling with is the calculation of team scores. I believe I need to have individual VBA macro buttons since the team game we play is different depending on how many golfers show up (typically 8-20). The scores are entered in the following format: The team score calculation needs to look at team #, gross score (yellow cells), calculate net score based on handicap (HDCP) and the number of scores needed for the team score. Net scores are determined by taking the gross score and determining if the golfer is eligible for a handicap stroke. Example: Bob M has a 7 HDCP (cell G2), on the #1 thru #7 handicap holes (row 16), one stroke is subtracted from his gross score to determine his net score. Team scores are reported relative to par (row 17) for the total 18 holes. The output should be a simple two column table with team # and 18 hole team score. Typical team games are: 2 golfer team best ball net score - The lowest net score of the two players. 3 golfer team 2 out of 3 net score total - The lowest 2 net scores of the three players. While there are additional games we play, if I can get these two programmed, I can use them as a guide to help script the remaining games. The workbook is 182MB so I can't attach it (it does a number of other things; team set up, payout calculations, etc...). Am I approaching this problem in the most efficient way or should I be focusing my efforts in a different direction? Thank you!Solvedschlag58May 14, 2025Copper Contributor188Views0likes7CommentsExcel won't print
Since about 2 weeks I can't print anything from excel. The error message says something about "not enough storage": I can print from Word, PDFs, etc. but not from Excel. If I open the file with a different tool it prints just fine. I tried different spreadsheets, different files, but nothing help. I also tried the solutions I found eg registry permissions, repairing Office 365, etc. I'm using Windows 11, Office 2024 Professional Plus, the printer is a Minolta bizhub C300i. All software is uptodate. Any help, ideas much appreciated ThomasVFRMay 14, 2025Occasional Reader19Views0likes1CommentComplicated formula help for a budget spreedsheet
Hello everyone, Normally I can find what I'm looking for and apply it to my project, but this one is a bit complicated, if it can even be done. I'll try to explain it as best as I can. I've got a calendar type layout on one tab(Forcast Template), with bills listed on anoter tab(All Bills). What I'd like to get it to do, is automatically fill in each bill for the corresponding day. The complications are as follows: some days have multiple bills due, and some bills only apply to certain months. I'm familiar with if/then functions as well as xlookup, but combining the two for this application is proving to be a tad more complicated. Again, that's if it can be done. Not sure how to attach the file for viewing, but I'll post screenshots so hopefully you can tell what I'm trying to do. Let me know if I need to clarify anything. Thanks!ComicazyMay 13, 2025Occasional Reader59Views0likes2CommentsAdding data ONLY when two cells match across sheets...
Hi all, Apologies: this is complicated... I'm working across x2 sheets in an Excel book. On sheet 2, I have my export page, where I paste the uploaded data for it to fill in sheet 1. On sheet 1, I have the historical data which I need to add to weekly. Sheet 2: Export Page including current formula (based on a working formula on another sheet we use. I need both forename and surname to match on the next page, and automatically paste columns C and D if/when/where they do, then tell me where any names have been missed (new students, etc.) so I can add them to the doc. So if A2 and B2 were on A6 and B6 on sheet 1, that is where the data (C2 and D2) would be pasted, to ensure that the student retains their own points balances. Sheet 1: Overview Page - I intend on the above columns C and D then being put into columns J and K on this page. I'll then just copy and paste the data across into the correct week following analysis, ready for the formula to re-populate those cells with the coming week's data. I switched forename and surname around for readability but can return if that makes it easier (for GDPR purposes, I have removed all names). The formula there had green "Yes"s through the page when I used the original data. When I have gone to update today, everything is a red "No", as you can see, so I clearly don't have the right formulas!! Appreciate your help, as I've been working on this for a couple of weeks now and just can't figure it out!! The formula on the other sheet that I was trying to work from was: =IF(COUNTIF(Table1[@[Name and tutor]],A2)=1,"Y","N")KirstyMay 13, 2025Copper Contributor75Views0likes4CommentsHelp needed Exel Newby
I want to make a date range in Exel. if something is due to run out in less than 15 days I want it to be red if something runs out in 90 days I want it to be green and if something is runs out in 15 days to 90 days I want it orange. how can I do this? where can I find simple functions?Michaela1234May 13, 2025Occasional Reader21Views0likes1CommentUsing Filters to Auto-Update Complex Formulas
Hi, This is my first post here. Hoping someone here may be able to assist me. I have the below spreadsheet. There is currently 500 rows of data. At the Top is a Summary Grid with formulas summarizing the data below (Rating, Employee Level, etc. ) I'm also showing an example of one of the formulas in Cell F3. The other cells contain similar formulas. Ask: How do I get the Summary Grid to only display the data based on the rows visible, which is determined by Column T filter selections. For example, if the user selects "Level 4 Manager 2" and this manager has 10 employees, how do I get the Summary Grid to display just the data based on those 10 employees (versus the total 500). I've seen videos/sites that use the Subtotal or Aggregate formula, but it appears those can only be applied to specific functions, not a more complex formula. Is this possible?ebellezaMay 13, 2025Occasional Reader50Views0likes1CommentHave text list of files, need to group like with like within same cell.
This is for a museum database, we have a list of filenames of photographs. Each filename starts with the collection number. We need to group all the filenames that start with the same prefix into a single cell to be placed into the appropriate record. We want to turn this: ANSPIP-000001-photo1 ANSPIP-000001-photo2 ANSPIP-000001-photo3 ANSPIP-000002-photo1 ANSPIP-000002-photo2 ANSPIP-000003-photo1 ANSPIP-000003-photo2 ANSPIP-000003-photo3 ANSPIP-000003-photo4 into ANSPIP-000001-photo1; ANSPIP-000001-photo2; ANSPIP-000001-photo3 ANSPIP-000002-photo1; ANSPIP-000002-photo2 ANSPIP-000003-photo1; ANSPIP-000003-photo2; ANSPIP-000003-photo3; ANSPIP-000003-photo4 I am attaching a set of sample data to test with, a formula or macro (more likely) is fine! Thank you!SolvedCygnataMay 13, 2025Copper Contributor42Views0likes2CommentsLooking for Xlookup with IF function
Hi! I'm trying to find a formula that allows me to search for a sku in column E but I need the return to be based on whether or not the cell in column F says True or False. If it's true, I need to return the sku that includes a letter. If it's false, I need to return the sku that does not include a letter. I have 2 line items for the same Item Number, but one includes pots and the other one doesn't. If I just do a normal xlookup, the return doesn't work the way I need it to. Help?! I hope this snip helps. In column H you can see that the return is the same for both lines, the top line should have a -P in it.AmyJMay 13, 2025Copper Contributor153Views0likes10CommentsMake a list that auto-populates data
I'm working on a workbook with 2 tabs. The intent of this workbook is to create a order list based on what is entered. What I'm trying to achieve is the following: In TAB 1 all information has been populated except QTY. I would enter a number (my numbers below in red) under the QTY column. Note I would not be putting values on all rows. Then, in TAB 2 it would auto-populate all the same information but starting at the top of the list, per the order it is in TAB 1. I'm keeping TAB 1 and TAB 2 separate since one will have a master material list where information will be added and edited. The other tab is what we would use to give to our procurement agent, who we don't want to confuse with the master list and a lot of blank QTY cells. I imagine 'if' statements and vlookup would come into play here but I just can't wrap my head around it. Any input would be appreciated. This is a spreadsheet that would also be shared on Teams. Not sure if that would affect anything. TAB 1 MASTER MATERIAL LIST QTY Item No. Description Model No Manufacturer Spec. No. Page 100 1001 3/4" pipe A T A1 4 1002 1" pipe B U A2 5 100 1003 2" pipe C V A3 6 1004 14 wire D W A4 7 1005 elbows E X A5 8 200 1006 F Y A6 9 TAB 2 QTY Item No. Description Model No. Manufacturer Spec. No. PageSolvedcontractormecMay 13, 2025Copper Contributor41Views0likes2Comments
Resources
Tags
- excel42,680 Topics
- Formulas and Functions24,765 Topics
- Macros and VBA6,419 Topics
- office 3656,046 Topics
- Excel on Mac2,657 Topics
- BI & Data Analysis2,380 Topics
- Excel for web1,926 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,640 Topics