Before we get into that, why don't you try using a SUMIF formula? It lets you pick specific criteria for your totals, and honestly, it’s way easier than what you've got going on above. First, you just grab the range in the column where your data lives (from the first row down to the last), then you set your selection criteria, and finally, you point to the sum range. Basically, if you have 100 different product codes in Column A, it’ll only add up the numbers for the specific code you actually want.
For example: =SUMIF($A$2:$A$133;"product code";$J$2:$J133) - So, Column A holds all those product codes, you type in the specific code you're looking for, and Column J is where the actual values you need to total are located.
Now, if you're using Excel 2007, SUMIFS is even better! It’s more powerful because you can set multiple criteria instead of just one like with SUMIF. Just remember the order changes slightly: first you define the sum range (Column J), then the criteria range (Column A), and lastly the selection criteria (the "product code")
Like this: =SUMIF($J$2:$J$133;$J$2:$J$133;"product code") + as many extra criteria as you need
I'm not sure if I followed you correctly: Looking to grab a macro that can hunt down specific cells—say, ones using Calibri 11, bolded, and colored blue—and swap them out for something else? Like maybe switching them over to Arial 12, italics, and a yellow fill? Is that what you're after?
If that’s really what we're looking at, then it simply has to work. Is it possible something went sideways during the recording process? Maybe you missed a step—like forgetting to hit "Replace All" while you were capturing everything? I just bundled everything into a single macro and it works perfectly. I'm not really sure why you went with two separate ones—maybe I totally misread what you were asking?
I still can't quite wrap my head around it... Of course, I figured that was the culprit. All the fonts and colors looked perfectly "normal" (set to automatic, and I even tried switching to black, but nope, nothing worked...), so yeah, we all know how that goes. Some kind of colored "rules" must have been active, though I had absolutely no reason to use them, and I honestly don't remember ever touching conditional formatting.
Since I spent two months working in this software, it’s hard to recall every single little detail of my daily workflow—even though I keep a log of all my changes—but I definitely didn't make any notes about something like this. But hey, at least Charles remembered it.
It’s actually great being here because there are a few "pros" (kind of like the guys over at Best Buy) who are absolute experts at handling this stuff. 🙂
Man, brightcyclist2, you’re a total lifesaver. This was the fix:
Why didn't I think of this myself? I hadn't even set up any conditional formatting in these cells, so there shouldn't have been any "rules" to begin with. Honestly, I have no clue how it even happened. Phew, what a relief.
The numbers look super faint in the cell while I'm actually typing them in (once I hit Enter and move on, everything looks totally fine—the numbers turn black). So, while I'm actively entering data in A2 through A6, the numbers look washed out, but after that, they’re solid black.
Basically, there's this weird inconsistency where A2-A6 look light, but from A7 downwards, they look perfectly normal and black.
If you're saying things look fine on your end, then I honestly don't know why it's acting up like this for me. Even other people who downloaded this program from me are running into the same issue; the numbers are barely visible while typing, and it's driving them crazy.
I know I might have made things sound more complicated than they are, but the problem is still there.
I'll attach a screenshot so you can see what I mean.
You can clearly see the difference in color that's bugging me.
So, here's the weird part: when I hit Backspace to clear an entry, the text looks perfectly fine in standard black while typing, not this light shade. It works okay for me, but for the other people I'm doing this for? They can't see a single thing while they're entering data.
Unfortunately, that’s not my cell, Kyle Johnson2. The cells are just colored, but whenever I type numbers into them, they show up as this faint, almost invisible shade instead of standard black. If Hiden actually allowed you to select a locked cell, they’d probably just hide the formula inside it. The font settings are totally standard—Times New Roman, size 10, bolded, with the font color set to automatic. I tried manually switching the font color to black, but it keeps defaulting back to white while I'm typing, and then only snaps back to normal once I hit enter. I even opened up a new Sheet and tried using Paste Special to copy the formatting from the cells where the numbers look fine, but nothing works. Honestly, there are so many things I could list, but I won't bore you. Anyway, I have absolutely no clue why this is happening to me.
I’m with you on this—the biggest issue here is actually the thread title. It would be so much better if we had dedicated top-level categories for things like Word, Excel, and so on, where people could just start their own specific threads.
I honestly think Excel and Word deserve their own separate PDFs in this Top Threads section. It would make everything so much easier to navigate, right? Even so, I really appreciate this move toward breaking things up—it’s definitely a step in the right direction. If every little tip gets its own PDF, why shouldn't each major program have one too?
I’ve been losing my mind over this one little issue for two days now: So, I have these specific cells set up where you can only input numbers. But here’s the kicker—when I actually type something in, the cell looks empty! The data shows up in the formula bar, but the actual cell stays blank.
The rest of the Sheet is locked down, except for those specific cells where I've allowed data entry.
Then there's a second problem, though it's not quite as big of a deal: When I click a dropdown list in one of those cells, the selection starts from the very bottom instead of the top. I haven't really had the headspace to tackle that yet since the first issue is such a massive headache.
2007 / If you need to clear out every single comment in a file fast, just click on any comment first. Then, head over to the Review tab, look for the Comments section, hit the little arrow under the Delete button, and select Delete All Comments in Document.
Honestly, I don't think this even needs a translation since it's so straightforward.
Man, English just feels so much faster than life back home near Mount Rainier. The only time I actually think in English is when I'm on my computer, otherwise, it's just not how my brain works,😁.
Alright, alright, my bad! I honestly thought you were just messing with me, but I see you're being serious now. My mistake. Next time, though, could you maybe give me a bit more detail about what's bothering you? It helps!
So, you’ll need to build a custom function yourself by following these steps:
1. Open the VBA editor in Excel (just hit Developer -> Visual Basic) 2. Go ahead and select Insert -> Module 3. Paste this code right in:
Option Explicit Public Function Reversetext(Text As String) Reversetext = StrReverse(Text) End Function
4. Close out of the VBA window 5. Now, just type =reversetext(A1) into any cell, and boom—it flips whatever is in A1 backward.
edit: Wait, I just realized what you said about every single letter being in its own separate cell. Seriously? If that's the case, why is it even an issue to just flip the order in the neighboring cells?
I mean, why overcomplicate things? You can just set the column width to whatever you want. If you need it to be a tiny little line, fine—make it a line! What’s the big deal? Just go ahead and change the color or add a border if that's what the look calls for. (Just select the column -> column width -> maybe try 0.15)
Nicholas King said:If E2 equals zero, then E2*D3 is also going to be zero. You don't actually need an IF statement for that.
Honestly, I was actually trying to put a blank string "" instead of a zero in the formula, but it slipped my mind—I wanted to hide the zero from appearing (which, by the way, you can just fix in the settings anyway). Fair point, though!
There are a few different ways you can tackle this, but these are probably your best bets:
1. Just use the IF function like Jose Miller3 suggested; try something like =IF(E2=0;0;E2*D3) 2. Or, you could just wrap it in an error handler, like: =IF(ISERROR(E2*D3);" ";E2*D3) (this keeps those annoying error messages from popping up). In this case, D3 would be your discount and E2 is the total. 3. If you really don't want anyone seeing those errors when you print, there's a little trick in the Page Setup settings. Just go to Sheet and set "cell error as" to . That way, the #DIV/0! won't show up on the hard copy, even though it's still sitting there in the software itself.
Sorry for going off-topic, but wouldn't it be way easier to just create a hyperlink in Microsoft Excel using the existing web link (you know, the one with the car results and the table)? You’d really only have to deal with the updates. Since everything exports directly into Microsoft Excel anyway, the end result is exactly the same, and you skip all that tedious manual data entry.
I don't really have a specific example for what you're looking for right now, and my schedule is pretty slammed these days. Cheers!
