User Profile
DaCrab_101
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
- 2.1KViews0likes0Comments
Re: EXCEL LIMITATIONS
NikolinoDE Thanks, that makes more sense. I'm good with excel, wrote a ten year program to run the business, we are in our 6th year. There is a folder called "TECHS TEMPLATES". In that folder are 300 excel files. Each file represents 10 years, 2026-2035. The old program ends in 2025. There is a MASTER outside of that folder. The TEMPLATES are in a "Cloud" but they are downloaded to a Computer Folder where the MASTER is housed. I would like to have 52 TABS in the MASTER, one TAB for each week of a year. I was going to create 10 MASTERS, one for each year of the ten year cycle I'm creating. When the MASTER is opened I would like it to pull information from each of the 300 excel files. There are 124,800 links from those 300 files to the MASTER. I'm running Office Professional 2016. What do you think?2.1KViews0likes0CommentsFORMULAS WORK TOO GOOD?
Morning Ladies/Gents, I was wondering if someone could perhaps give me an idea or two? The attachment is a Golf Game. Everything is working perfectly with one slight issue. I haven't gone past row 25 in programming. Looking at rows 6-7-8-9-10, I'll be hiding, and password protecting7-8-9. Of course only the cells used to enter a score will be functional. If you look at Cell A6 and take the name out everything is good. If you put in a name his/her handicap automatically populates in rows 7&8. This action causes the formulas in Cells E10, H10, K10, N10, Q10, & T10 to come into play. This provides scores in B10 before the game even starts. Now if a Golfer just ignored the Score, Played the Game, the end results would be accurate. However I know they won't ignore anything...lol Any suggestions greatly appreciated!583Views1like0CommentsRe: VERY DIFFICULT TO EXPLAIN
Thank you so much for the reply! Honest Engine. I'm fairly competent with excel. My CPA calls me a Master but I disagree. You have confirmed exactly what I think has to be done. I went to the Community as a last result before I began a completely different approach.1.1KViews0likes0CommentsVERY DIFFICULT TO EXPLAIN
What you see attached is a template. I'm working off one just like it that I designed to go from 2016-2025. Now I'm working on a MASTER to go from 2026-2035. The MASTER takes two separate formulas and compares them. This way I know Payroll is right for a given week. The first formula is simple. It's on the tab MASTER. It will look at 300 excel files, when I'm done, and will total up the weekly pay. 001 is what I call an EOW (End of Week). A Technicians work is filled in and it totals up his pay. It reports back to the MASTER and gives me a grand total for the week. Simple enough. Here's my "monster". The second tab, 01.03.26, is a combination of events. Take 001 for example. There will be a formula in B4, one in D4, he/she may have a debt to pay or is investing in savings so there would be an extra row added beneath and a formula would be in D5. Lots of formulas. Normally I run that out for 5 weeks. So when one week is done, I move the tab to the back and recreate all the formulas 5 weeks in advance. Starting to see my issue? This would be a typical formula for cell D4 for the date Week Ending 01.03.2026 ='F:\2026\TOSI 2026-2035 TECH (A)\2026-2035 TECH TEMPLATES\[001.xlsx]Pay Sheet'!O6 This formula would be duplicated 300 times but 001 would be 002, etc.etc. Can a formula be created where there would be a cell on 01.03.26 where you would change the O6 in the formula above to O9 and all 300 formulas on that sheet would recognize that change? Yeah I drive my CPA nuts too...Thanks Folks.Solved1.1KViews0likes2Comments- 916Views0likes0Comments
- 917Views0likes0Comments
IF ?
What's wrong with this formula? =IF(U5>=200,"DATA!J4*SCORECARD!U5",IF(U5>=400,"DATA!J16*SCORECARD!U5",IF(U5>=600,"DATA!J28*SCORECARD!U5"))) There are three teirs. I want the formula to look at one cell, determine what tier requires to answer, and deleiver a "this times that" answer.Solved1KViews0likes4CommentsRe: Drop Down Box
Yes I'm familiar with both. Every play Golf? I'm trying to design a portable Scoring Card for the guys I play with. At the top of the Card is a Drop Down Box. So by selecting Tim, VLOOKUP goes and finds Tim, displays his name on Row 3 Cell A, displays his Handi-Cap Row 3 Cell B. No problems there. Now I want to go back to the same Drop Down Box and select another player to be displayed on Row 4, Cell A & B, just like Tim. Problem is, at least for me, every time you select a new name on the names become the same on Row 3 and Row 4.1.1KViews0likes1CommentDrop Down Box
I would like to have one drop down box populate cells with different information determined by what is selected in the drop down box. For example; If I select Tim from the drop down box the in row 3 I would like Tim's Information displayed. Using the same drop down box if I select Don I want Don't information displayed in row 4, and so on through row 300.Solved1.1KViews0likes3Comments
Recent Blog Articles
No content to show