Posts by Kyle Johnson2

hollowmaker11 said:The spreadsheet isn't actually messy, mostly because I didn't even send you the whole thing.

(well, for me anyway, since I don't know all this stuff)

hope you can get this sorted out
later

hollowmaker11 said:sending it over via PP

WHY via PP? I don't do private messages for this stuff because then I feel obligated to fix it on my own time, and I'm just not feeling that.
The forum is public for a reason. Helping people out here helps everyone see the solution, especially when you show examples. Ever thought about how someone else might run into the exact same headache down the road?
If we solve it for you, we solve it for them too.

Looking at your setup—which is pretty chaotic, if I'm being honest (hard to tell since I don't know your whole workflow)—I didn't quite catch what you meant about it working fine a while back. Looks like someone set a specific Print area for one cell? My guess is the original creator was messing with some VBA macros. Maybe check an old backup of the file if you have one and look at the formulas there.

now for shift 2, the taken amount is 803.80 and it has to stay that way... try putting different items in the left table and you'll see the "taken" and "given" columns change. I don't want that "taken" number moving. It needs to be 803.80 regardless of whatever items I toss into the left table.

That's standard behavior if the cells are linked with formulas or references.
Organizationally, it's a mess. You should structure it differently. My advice? Use one Sheet for every single day (just identical tables all tied together with links/formulas).
That way, after a month, you'd just have a set number of sheets in one Workbook (covering all three shifts, though you could even manage the shifts within a single workbook)

It makes sense that the total changes when you enter new items, because there's a formula in that cell summing them up. Just throwing an idea out there—if that doesn't work for you, maybe someone with more free time can jump in.
Check out this example in the attachment, cheers

hollowmaker11 said:i've got two spreadsheets. the left one is set up like a basic list, counting up cash by specific items... and that's where I'm stuck... thanks a ton to anyone willing to actually wrap their head around this and help me out 😁

Man, those two example tables of yours would be worth their weight in gold if we weren't just spinning our wheels here.
Put in a little effort and show us an actual example of what you're trying to pull off (add some comments, show what links to what, color-code the results, etc... get creative 😉

Carol Rivera32 said:Can you re-upload that? please
thanks

Link's working fine

btw:

crimsondriver37 said:Sold 2 cocktails. Can I use Excel or maybe Access to make it so once I log a sale, it automatically subtracts the ingredients from my stock?
don't know how to explain it better lol

It’s not impossible, but you need some serious organization to build something like an inventory tracker. You basically need tracking for incoming stock, outgoing sales, and current totals. Access could handle it, but honestly, you’d probably need a pro programmer—not just an Access guy, but someone who can code in whatever language fits best—to build it exactly how you want it.

If you try to DIY this in Excel without knowing what you're doing, you'll end up needing someone else to fix it anyway. Plus, you risk messy data or accidental deletions.

Before you dive in, ask yourself a few things:

- What’s the actual goal here?
- How does this fit into your daily workflow?
- Have you considered all the variables? (Like, tracking stock by unit vs. volume. For cocktails, you’re looking at liters, deciliters, or milliliters, right?) 😉
- How much cash are you willing to drop on this?
- If you go the Excel route, do you actually have the skills to troubleshoot when things break or if you need to scale up?
- If you pay for a custom .exe app, you’re just the user. You enter the data, and the dev handles the heavy lifting—but yeah, that costs money.
- Is there a long-term ROI for this investment?
- And look, I’m not trying to talk you out of it, but think about the time sink. If you grind away at Excel yourself, are you okay with the risk of everything crashing? Or would you rather pay a pro to build it so it's ready whenever you need a change?

For example, check out this complex invoice setup done in Excel. This took a lot of work to organize properly. A programmer would have built the backend so you'd just see a simple entry form. This invoice structure is pretty similar to what you're asking for.

Carol Rivera32 said:Assigning shortcuts in Word isn't the same as in Excel (you don't get that "Options" button in the macro window like you mentioned: ALT+F8 => select macro => Options), honestly, a ton of stuff just doesn't work the same way as Excel...

I wasn't even talking about Word, I meant Excel since that's what you brought up.

Alright, let's get back to the Word macro.

When you're building a template and making a Macro, you gotta assign a shortcut or maybe just add a procedure that triggers automatically whenever the Word doc opens.

Haven't messed around with this much myself, but these links might help along with the example in this message (unzip it and run the *.dotm) => Let me know if this one actually works for you.

I think you're messing up how you save the macro in VBA. You shouldn't be saving it where it references Normal.dotm; it needs to point to the actual TemplateName.dotm file—meaning it belongs in ThisDocument.

Basically, if you send over the template file but the macro stays stuck in your own Normal.dotm, then obviously the user can't run it.

Bottom line: with a *.dotm file, you need to include the macro itself, which is why yours isn't working right now.

Check out these links: LINK1, LINK2, LINK3

vividbison82 said:How do I turn this off so it looks normal again? It prints fine, though.

Check if you did it like this.
Steps:

Adam Mendoza4 said:Hey, quick question—in Word 2007 on Windows 7, how do I set it up so only the first page has a header and footer, while the rest stay clean?

You gotta use Section Breaks in Word. Different headers and footers are handled via sections, or just hit those Section Breaks in Word. Plus, using different sections in Word lets you set up unique chapter headings throughout your document.

frozenheron7 said:Downloaded it and works fine for me too 🙂
Just had to right-click -> update field on that last cell.
Running the 2013 version

and it runs on Word 2007 without any issues

Carol Rivera32 said:I don't think the block is on viewing the macro itself, but none of us have any restrictions on loading them—at least not visibly, since the PC doesn't even throw an error message.

You really should've just posted that chunk of the document with the table and the Macro for download so someone here could actually test it out.

cosmicbadger10 said:How do I get rid of this text background color in Word?
Any ideas?? This gray stuff keeps showing up behind my text.

If what @Arthur Anderson49/">@@Arthur Anderson49 suggested doesn't work, you probably just copied some text from the web and can't strip the background shading. Is that what's happening?
Just upload a small sample file for us to look at if you still can't fix it.

hollowfalcon said:Standard settings. Here's the file: http://goo.gl/vlAKi

Honestly, both answers are right if I’m following the question correctly.
If it's a JPG, the text wraps around the image frame in Word.
But if you use a PNG with transparency (like a clear background), the text wraps around the actual object instead of the bounding box.
At least, that's how it works for me. Check the attachment.

Here's the file back with an example

hollowfalcon said:if we're using Text wrapping - tight on an image without an alpha channel, does the text hug the actual object or just stick to the edges of the bounding box?

looks to me like they used some kind of specific style or shape when they set up the wrapping

Arthur Anderson49 said:Depends on what his defaults look like. On my end, that icon wasn't even on the toolbar by default.

I wasn't even talking about how to find the Show/Hide button. It's pretty obvious you just gotta hit Customize to add it if it isn't already there. Word 2003 I'm sorry, it looks like your message was cut off. What's on your mind? 2007 Different approach entirely (didn't even say which program—Word or whatever else—he's actually using).

Just trying to let him know—it’s got nothing to do with the OS here, specifically Windows 7.
Hey.

vividmarlin10 said:I'm on Windows 7 and I can't figure out how to get rid of these paragraph marks and stuff. Where do I go to turn them off?

That’s got nothing to do with your OS.
In Word, just hit the button (icon)



or

Alex Barnes4 said:but what I was actually asking was how to get that sum without expanding column "c"—basically just getting the total in one single cell and leaving everything else alone.

Yeah, totally missed the point of the first question. 😉My bad.

Try using the SUMPRODUCT function.
Code:

Or just use SUM paired with an IF function, but you gotta hit it as an array formula
Code:

Alex Barnes4 said:in cell c1, I'm adding +1. can someone write me a function that does this exact thing (so I can just tweak it for my actual project later)?

You didn't specify what exactly you're adding that "1" to, or what happens if the number in A is actually smaller than the one in B.

Just use the IF function.
This formula in cell C1 will do this:

If the value in A1 is greater than the value in B1, then add 1 to A1 and show that result. If not, leave the cell blank.
Code:

Basically, the IF function/formula takes three arguments: =IF(condition; result if true; result if false)

Ryan Clark5 said:some advanced Excel course in Washington, D.C.

What even counts as an "advanced Excel course" to you? Like, what specific field or actual skills are we talking about here?

Jeffrey Moore4 said:Is there actually a way to just type this stuff—name, address, whatever—once and have it automatically update everywhere else in my files? I need it to sync across all the different spots in the text without me doing the manual grunt work.

Maybe just run a macro to pull the data straight from a TXT file.
Or just go through. Autocorrect settings. Either use shortcuts or just go through Autotext. Or both. Whatever. automation for repetitive tasks
Same in Excel.

rapidhawk23 said:Whoops!! Link's crawling with viruses!!

Not sure where you're getting those viruses from—give me some details if you can. Is this just some free file-sharing site?
What browser are you using? What else?
My AVG and Malwarebytes aren't flagging anything.
Here’s the link back on that server
If you don't want to deal with that, I put it on my own server. It'll stay up for a few days before I scrap it. Download link here

Hope you figure it out. Maybe go brush up on some Excel basics or something.