shadowhawk32 said:I actually ended up helping out a neighbor who was stuck with the same deadline. Sure, I was glued to my computer from 8 AM until 5 PM, but I still walked away with $167 😁
$13/hour. Honestly? Not too bad. It could have been at least 50, but hey, you aren't paying any taxes or payroll deductions on cash under the table, right? 😉
Danny, you could just breeze through that using filters—you know, the ones with all those options like equals, greater than, or less than... Then you just grab the results and paste them right into a new Sheet. Filters give you exactly what you need when you're looking for a specific range, even if you're dealing with decimals.
So, I've been dealing with a bit of a headache for a few days now—Excel, of course. I built this template called PLAĆA, which I use for processing employee payroll. Every month, the template gets renamed P1, P2, P3... all the way up to P12 for the full year. Inside each individual Pn, there are about 30 different tabs—one for each worker—and one specific tab within every Pn is titled rekapitulacija. This tab provides a monthly summary of various work parameters for all employees.
THE PROBLEM: How can I create an add-in (a program, or whatever works) designed to aggregate data from the rekapitulacija tab found within each Plaći_P1-P12 file? These summaries are formatted as pivot reports. Creating this for months that are already finished (January-March) wouldn't be much of a challenge, but I need this tool to also pull quantities from the future Pn tabs that haven't been filled out yet. All I know is how they'll be named: P4 (for April), P5 (for May), and so on.
One of the trickier parts is that I can't pre-name all the files from P1 to P12. I often have to modify the P template due to changing labor laws or our own internal company policies.
I should mention that John and Nicholas King have been incredibly helpful with their suggestions and ideas while I've been working on this.
So, I'm really just looking for a direction to head in. Once I have a strategy, I'll roll up my sleeves and try to make it happen.
Hey Gregory Rogers20, as far as I can remember, there was never any mention of maximum or minimum values. I just assumed you could skip steps, which is why I suggested entering the values directly into column D. Nicholas King 👍.
Let me jot this down quickly while I can—my head is spinning a bit today and I’m feeling a little off, so let’s see if this makes sense to you: Basically, just list the numbers you're looking for in column D1 and downwards. For instance, using your previous example, you'd put: 23, 24, 25, 26, 27, 28.
Pop this formula into cell B14 and drag it down the column. =VLOOKUP(D1;$A$1:$B$13;2)
Drag it down one more time just to be safe. Once you start seeing that #N/A error, you know you're finished! One huge thing to remember: your lookup table absolutely has to be sorted in ascending order. If it isn't, VLOOKUP is going to give you totally wrong results.
You won't have any empty rows now, but you do need to enter the specific numbers you want to search for in cells D1 through D6. You can always hide that column later if you don't want it cluttering things up.
If you actually want the formula to display the numbers themselves, put =VLOOKUP(D1;$A$1:$B$13;1) into cell A14 instead. Just drag that down until the #N/A pops up too.
I’ll try to brainstorm some ideas tomorrow afternoon, but I'm currently swamped getting things ready for tomorrow morning, so I just don't have the bandwidth right now.
Gregory Rogers20 said:It’s working now since I pulled it back! You should've told me sooner 😁 but, can't we just have it print everything from the start without skipping lines? (I mean those empty checkboxes), like, can they all just be filled in nicely? Is that possible?
Well, that's a whole different story. The easiest way would be to just drop in a macro that wipes out the blank rows. You can grab that code from Ivanac—just go back and read his instructions, he covered it a few pages ago.
I'm not saying that's the *only* fix, but we really need to put some thought into this and actually answer the previous questions. It's crucial to know how much the table being analyzed changes or stays stable, you know? I don't want to keep repeating myself...
That’s just how the American version of Excel works on your machine—according to the manuals, they don't use semicolons. But hey, if that's causing a headache, just swap them out for commas where needed; just don't go adding anything extra.
Gregory Rogers20 said:Ugh, nope. It’s just not working. I keep getting an empty cell, or when I try this: =IF(AND(A1>=23,A1 "false" at me...
- Honestly, it works perfectly fine for me, and it should work for you too! You probably just messed up the cell reference—it's not A1, it's B1. Also, did you see where I put the word false inside quotation marks? =IF(AND(A1>=23;B1);"") - just try copying this into cell B14 and dragging it down. You'll get letters as results or just blank cells.
- That first formula is meant for cell A14 if you actually need the numbers, but looking at your screenshot, you don't seem to need them since you've got those "f" letters sitting in columns A and B.
- See the difference? You can't use a comma; you have to use a semicolon, and don't put anything inside the quotation marks. It shows letters only for values between 23 and 28. For everything else, it stays blank because of the empty quotes ("" means nothing, aka a blank cell). If you take the quotes out, it'll just say FALSE, which basically means the formula's conditions weren't met. If they are met, you'll see f, g, h, and so on.
To make it simple: just copy both formulas into cells A14 and B14, drag them down, and then you can decide which one actually does what you want.
So, you just drag the formula down. I didn't realize those empty rows were throwing a wrench in the works!
Plus, didn't he mention that everything gets rewritten from row 14 to 26? So if he’s looking for values between 23 and 28, it makes perfect sense that the other rows stay blank. I mean, what else is a formula supposed to do besides pull existing data? It's all about finding the right way to make that happen.
This second option totally fixes his issue. From here, we could even play around with some variations—like, say, having the target elements (23, 28) typed into a different cell so he doesn't have to mess with the formula itself every single time...
Just a quick thought here—I think I can knock this out with either of these two formulas (or honestly, just the second one):
Put the first one in cell A14: =IF(AND(A1>=23;A1 Then put the second one in cell B14 =IF(AND(A1>=23;A1 - Just so we're clear, I used 23 and 28 based on your example
Looking at your screenshot, if you're planning to merge cells A and B (below the input) since you only really need the "letters," then you should just go with the second formula
Yeah. You want to know how to actually run it? And are you worried about case sensitivity? Because it keeps forcing everything into uppercase on my end. So, if you just tweak the code to use lowercase "czs," it should work perfectly fine.
Right-click on any PDF file -> properties, then where you see open with click "change" and set it to Adobe Acrobat Reader
Or if you're using Windows 7:
Go to Control Panel -> Programs -> under Default Programs, select "Make a file type always open in a specific program," find the .pdf extension, and pick Adobe Reader
Forget the formulas, it’s actually way simpler than that:
Click the OFFICE BUTTON (that big one in the top left corner) -> Excel Options -> Advanced -> Display options -> then just uncheck the box that says "Show a zero value in cells that have a zero value"
You read somewhere about how you can get this stuff without paying a dime, but around here, people act like it’s some kind of sacred taboo to even mention it.😉 There’s no such thing as a free lunch when it comes to this stuff.
Jack Martinez27 said:I really need some help with two specific features in Word 2007. They’re both super common and honestly pretty important to how I work. Any experts out there?
So, how do I go about generating numbers automatically? I’m really looking to move away from all that tedious manual typing. Is there a way to just let the computer handle it? On a scale of 1 to 100... or maybe just 1 to 50? What are we thinking here?
Just whip them up in Excel and then just copy and paste? Simple enough!
Jack Martinez27 said:So, I’m working on a document in Word, right? And the spacing between my lines is just... huge. It feels like there's this massive gap between every single sentence, and it's driving me crazy! Is there a way to actually fix this without having to manually nudge every single line closer to the one above it? That sounds like a total nightmare. Any tips?
There are actually a few different ways to go about this, but honestly, my go-to move for speed? Just highlight the rows, right-click, and... What exactly does "paragraph" mean to you? Is it just a block of text, or is it the heartbeat of a good story? I’ve been thinking about how we structure our thoughts lately. Sometimes a single sentence hits harder than a whole wall of words, doesn't it? But then again, without that structure, everything just turns into a messy sprawl. How do you decide when to break things up? Does anyone else struggle with knowing when a thought is finished, or are you all just natural pros at this? Just set the paragraph spacing to zero and select "single," or honestly, you can just click one of those pre-set styles... simple enough, right? No spacing? Is that really how we're doing this now? Seriously? No gaps, no breathing room... just one long, endless string of characters. It feels so claustrophobic, doesn't it? Why would anyone choose to write like that? It’s almost impossible to read! Are we trying to save ink or something? Or maybe just testing our patience? I don't know, it just looks so chaotic!
I've got this spreadsheet with a few hundred rows...
It involves some different product categories spread across various locations (honestly, that part doesn't even matter) 😁
I need to sum up every 7th row in a specific column at the bottom.
Any ideas how?
That’s actually a huge deal, isn't it? Now we're both just sitting here guessing what he's actually looking for. That's why I suggested seeing if there was a workaround... because honestly, I'm stumped too. - I mean, if he really needs every 7th row, shouldn't there be some kind of criteria tied to those rows?