Posts by Kyle Johnson2

stormyowl5 said:basically you need a database for items, quantities, and prices—plus the part where you handle invoicing. so when you send an invoice, it automatically updates your inventory levels so you always know exactly what's sitting in the warehouse.

Check out this tutorial, might help since it does something pretty similar

- INVOICING in Excel

restlessdrifter12 said:I just can't get this thing to work... anyone willing to walk me through how to actually pull this off?

check out How to sum hours in Excel
btw: just enter time as 0:00 or 1:12

Wait, what? You’re kidding me. Just "blum"? That's it? Give me something to work with here. kaže:
I can't even begin to process what you just said. What does that even mean? Give me something to work with here.Unless we find some other way out.

Take a look. Think this guy could help? Wants to hide or unhide columns based on what’s sitting in a cell? Easy enough. If you're looking to automate this in Excel without manually clicking like a maniac, you're gonna need a quick VBA macro. You can't really do this with standard formulas—formulas just spit out data, they don't go around messing with your spreadsheet layout. Here’s the deal: you write a little script that looks at your target cell, checks the value, and then triggers the `EntireColumn.Hidden` property. If you want it to happen instantly every time you change the value, toss that code into the "Worksheet_Change" event. It's way smoother than hitting a button every five minutes. Need a hand with the actual code snippet? Just holler. Or at least toss out an idea.

redcanyon5 said:Alright, look, I need a function that sums up all weights based on matching dates and codes. My Excel file is huge—we're talking over 200,000 rows here.

Say your table covers the range A1:C8

Put your criteria in cells E2 and F2

E2: date
F2: code

In cell G2, just drop this formula: =SUMPRODUCT((E2=$A$2:$A$8)*(F2=$B$2:$B$8)*($C$2:$C$8))

btw: check out this tutorial on using SUMPRODUCT for multiple criteria if you want to dig deeper

cosmicbison19 said:quick question... how do I pull off a chart like this in Excel (maybe a pivot chart?) if I've got two values, like actual hours worked vs. max allowed hours?

You gotta use an extra column to calculate the gap between current time and the max limit.
Check out this link Time periods on charts

slyskipper95 said:can i use something other than those built-in designs in PowerPoint?

PowerPoint lets you build your own templates from scratch, too. Just go for it.

cosmicbison19 said:Some columns are bigger, some are smaller... so what if we set a rule where anything over, say, 50 turns red, and everything under 50 turns blue?

You can actually have a PivotTable refresh itself just like a chart does. If you want to get fancy and color-code things based on the raw data values, you're gonna need some VBA. Check out this link for an example.

Arthur Ramirez20 said:I've got no clue how to fix this—whenever I type stuff into those columns, the text just spills over into a new line depending on how much data I'm dumping in. How do I stop that?

Every single "text Form Field" has its own character limit. How do you cap the number of specific characters? What can I actually put in a text Form Field?
If you just drop a text Form Field from those Legacy Forms toolbars, it’s not gonna stop someone from hitting ENTER and completely wrecking your layout. It's a mess waiting to happen. If you want to actually keep things under control, you gotta wrap that field inside a table and lock down the cell constraints. That's the only way to keep people from breaking your form.

Raymond Collins18 said:I need a formula that finds the last non-zero cell, then does an OFFSET upwards from there—specifically, that last non-zero value plus the 9 cells above it. I've tried everything, but nothing's working.

If you can just stop those zeros from showing up in column A (try using an IF statement), this formula should do the trick:
Code:

Ethan Anderson8 said:I need to set up page numbering so it starts on the third page. It's for a term paper.

We've actually covered this exact topic on the forum before. Just hit search or scroll back through the threads.
btw: if you can't find it, here are the links for Word 2003 and Word 2007

Henry Lewis37 said:Alright, I’m gonna lay out a simplified version of this Excel sheet and the tasks I need to tackle—basically some formulas and stuff. I'm totally stuck, but I need this done ASAP... Please, please don't delete this thread before someone gets back to me. It's urgent.

Just upload the file to a free hosting site. Put the task in there, and use cell comments to explain what you need and what the result should look like in a specific cell.

rapidhawk23 said:Actually, how am I even supposed to send it??

Just upload it to some free hosting site.

There are a few ways to lock down a worksheet. The standard way is using a password on the actual Sheet or workbook, or going through VBA.
The real question is what kind of protection we're dealing with here and why it's there. Are you the one who locked it, or are you trying to crack someone else's work?

If you want it gone, you're gonna need the password.
btw: check out this link

Upload the file so we can actually see what's going on.

Amy Rivera66 said:I need some help with rotating things in Word. I want to rotate the page, the table, and this text above all at once—like you just turned the whole sheet 90°.

Check out this tutorial. So, you want to rotate a table in Word using Excel? Yeah, okay. Here's the deal.
Grab this file. Here's an example.

It really just boils down to a few simple steps.

Copying a table in Excel.
Transposing columns in Excel.
Sorting columns in Excel (reverse order)
Transposing tables in Excel.
5. Messing with cells and text in Excel
Copying back into Word.

Grace Miller said:I'm trying to figure out how to pick numbers from a list that add up to a specific total, like this:
15
20
25
30

for example, which ones hit exactly 50?

Just use Solver2 with a helper column or row. I dropped an example at this link.

btw: check these links too
- Solver1 and Solver2

amberpanther3 said:: "The Spelling & Grammar check is complete. Text marked with 'Do not check spelling or grammar' is skipped".

Which version of Word are you running?
Check those grammar settings. Take a look at the third pic on THIS link.

Raymond Collins18 said:Just trying to be helpful.

Look, if you need a hand, just go Google it, ask around, and learn from how other people handle things. That’s my move. And hey, if I can give back to the community, I’ll do it just like this example here whenever I’ve got some free time. 😉

Later.

Raymond Collins18 said:Guess my help was useless! :-(

Your table layout is a mess. Stop hiding columns in the middle—it’s a nightmare. Just Google 😉
Check the attachment

Raymond Collins18 said:Hey guys, thanks for the help and my bad if I was being vague.
Let's try this again. Here's the data we're working with.

You're still being super vague with this info. You should've just uploaded an example of your spreadsheet for us to look at. Show us what goes where and what the final result is supposed to look like. It would've saved everyone some time.
Here, take this File for download (assuming this is what you meant)

Amy Hughes50 said:I tried that too, but it’s just not working... Plus, I can't even select all the images I put in the doc. It won't let me highlight them at all......

You haven't actually tried everything yet. I don't know which version of Word you're running, but those images were set to "Behind text"
Basically, your "Text Wrapping" settings are messed up. Switch them to "In line with text" or "Square" depending on how you want the layout to look (@Walter Jackson48/">@@Walter Jackson48 already gave you the rundown). Check out that link I sent earlier about image formatting—it covers a few different ways to handle pictures.

Also, that "First Line Indent" thing is just messing with your margins; it's that little slider at the top of the ruler. I fixed it for you, so take a look at this file for Download
later

Amy Hughes50 said:Tried doing that, but no luck...
Any ideas? Help me out here...

Just make a copy of the file, wipe everything except a couple of lists, and drop a link download right here on the forum. It'll be way easier for someone to jump in and help you out.