Posts by Walter Jackson48

steeltrucker142 said:I really need some help here...

You might want to try preventing those date or time fields from updating automatically. Here is what I do—just highlight the field and hit Ctrl + F11, print out the document, and then before you start filling it out again for, say, a different employee, you just unlock the update functionality on those fields by hitting Ctrl+Shift+F11. Honestly, you could probably just bundle all those steps into a single macro to save yourself the headache. (Just so you know, I'm still running Office 2003 on my machine).
Might be worth a shot.

Bryan Fowler7 said:I followed every single step you laid out, I really did, but now I'm just staring at this error message

Look, just give it another shot following @Start's instructions, but listen—instead of selecting Microsoft Print to PDF , try picking whichever physical printer you actually use normally. It ought to work that way.

Maybe this formula is a bit more straightforward, or perhaps I just missed something in my haste while rushing through this...

=IF(C25*D25=0;0;IF(C25*D25div>

First, just build your table, then follow these steps:
Go to Home, select the table, hit the References tab, and then click Insert Caption. (Honestly, you can also just right-click the table itself and select Insert Caption from the menu—it’s much faster). A little box will pop up with some default text, like Table 1, and you just type your title right after it (for example, PAYROLL OVERVIEW), then hit OK. Now, if you actually want Figure instead of a table label, just click on New Label and type in what you need. Easy enough.
Once you've done all that, you'll see "Table 1 PAYROLL OVERVIEW" sitting right under your table. Of course, you can move that caption wherever you want. If you're one of those people who prefers the title to sit *above* the table, just grab the table with your mouse and drag it down underneath the caption.
It works pretty much the exact same way for images. The only annoying part is getting the image to actually move where you want it; you have to right-click the picture, go to Text Wrapping, and select Thigt. Once you've done that, you can just drag the image under the caption. There isn't some magical one-click way to automate the whole thing at once. It's just how it is.

brighttinker12 said:Can anyone please help me out? I’m trying to figure out a formula to build a table where the final column—the balance—automatically adds or subtracts based on whether it's a deposit or a withdrawal. I've been banging my head against the wall for days now. I've tried looking for advice everywhere, but honestly, nobody seems to get what I'm asking. It shouldn't be this hard, and a simple solution would really save my life right about now... thanks. Here is the situation:

Try doing it this way:

In E1, type "Starting Balance"
In C2, enter: "Deposit",
In D2, enter: "Withdrawal",
In E2, put in your starting amount, say 1000
In E3, use this formula: =IF(OR(C3<>"";D3<>"");E2+C3-D3;""). Then just drag that formula down column E as far as you need.

Everything should be set up and ready for your entries. Just double-check that it does exactly what you're looking for.

p.s. Use OR instead of AND here.

I’m still running Windows XP myself—honestly, I only keep Windows 7 around just to access this forum—but you might want to give this a shot:

Open Microsoft Word on the Windows 7 machine, head over to Mailings, then select Mail Merge, and finally hit Envelope. Inside the Envelope settings, you can pick your specific envelope size, and under Printing Options, you’ll figure out how you want to feed it into the printer. In the Feed from field, you can choose your Manual Feed method depending on how you prefer to load the envelopes; personally, I use an ML-1710P Samsung printer, so I just slide the envelope manually into the top tray, then hit OK. Once you're there, go to the bottom of the page and left-click; a text box should pop up (it looks like a little dashed outline), and that's where you type in the recipient's address. If you hover your cursor over that dashed border, the pointer turns into a little crosshair—just click and drag that box wherever you need it to sit on the envelope. After that, just hit print. That should pretty much wrap it all up.

I mean, at the very least, they should have the decency to let us know if we actually ended up being useful to them.

I might have missed your point here, but what actually happens when you type "NO" into A1?

Maybe try just dropping this formula into B1: =IF($A$1="YES";Sheet1!G1:G20;Sheet1!H1:H20). That way, if someone enters "YES" in A1, column B pulls the data from column G on Sheet1, but if they put "NO," it grabs everything from column H on Sheet1 instead.
Obviously, you'll need to drag that formula down from B1 to B20.

Look, when you're trying to type out a formula like =IF(C14:G14=1;1;I14/H14), you can't just hit Enter and expect magic to happen. You actually have to mash Shift+Ctrl+Enter
. It’s one of those little quirks that drives me up the wall, honestly. I spent twenty minutes staring at my screen last Tuesday thinking I’d broken the entire spreadsheet before I realized I was just being lazy about the keystrokes.
But this other formula? That one works just fine.

Go over to the References tab, then hit Insert Caption. Once you're in that little pop-up box, just type the image title right there in the Caption field (it’ll show up after Figure 1), and then click OK. That's it.

Give this formula a shot, assuming we're on the same page here:

=IF(OR(AND(A3>=10;B3>=2);AND(A3>=15;B3>=3));"YES";" NO")

p.s. I see one of my colleagues beat me to the punch; I completely missed his post earlier.

Here’s an idea I’ve been chewing on—feel free to take it, tear it apart, and make it something actually useful:

So, I set things up in A1:A30 by typing in numbers from 1 to 30. Then, in B1:B5, I just threw in a few random numbers from that same 1:30 range. To tie it all together, I dropped this formula into C1:
=IF(AND($B$1<>A1:A30;$B$2<>A1:A30;$B$3<>A1:A30;$B$ 4<>A1:A30;$B$5<>A1:A30);A1:A30;""), then I dragged that whole thing down through C30.

Look, if you want to actually get things done without losing your mind, you need to stop messing around with the basic presets. Just go straight to the source. You’re going to want to format that specific Cell using the Custom option—you know, go into Format, select Cell, and then hit Custom. Once you're there, just type exactly what you want the layout to look like directly into the formatting field. It's much more efficient than clicking through endless menus, believe me. I spent half my morning yesterday fighting with a spreadsheet because I was trying to be too "standard," and it was a total waste of time. Just do it the right way from the start.

Give this a shot, maybe it'll actually work for you:

First, take column A—wherever you're typing those dates in the MM.DD.YYYY format—and just format the whole thing as Text first. Then, go to cell B1 and drop in this formula: =MID(A1;4;7). After that, just drag it down to cover every date you've got in column A.
Once that's done, we’re going to sort by column B. Just click on cell B1, head up to Data, then Sort. When that Sort Warning pops up, make sure you check the box that says Sort numbers and numbers..... and hit OK. Is that it? Hopefully. That should do the trick.

Take a look at this:
http://office.microsoft.com/en-us/ex...dates_or_times

Melissa Hayes41 said:If I put C5*$D$9 into cell D5, then according to the course solutions, the next two cells, D6 and D7, should end up being C6*$D$9 and

So, if I'm following you correctly, you're trying to get results in cells D5, D6, and D7 by multiplying those changing values (which sit in C5, C6, and C7) against a constant held in cell D9.

Basically, you just type the formula =C5*$D$9 into cell D5. Then, you grab that corner and drag—or "fill," if we're being technical—it down through D6 and D7. If you did it right, those cells will automatically update to =C6*$D$9 and =C7*$D$9. It’s basic Excel logic, really.

Look, just try shrinking that bottom margin first. If you manage to pull that top line from the new page back up to the bottom of the previous one, then it wasn't actually empty space to begin with. (The eye can be a real liar sometimes, believe me). But if that doesn't work, and there’s clearly a massive gap staring you in the face, here’s what you do: take your cursor, hover right under that last line on the previous page, hold down the left mouse button, and just drag it downward. If you see a highlighted area pop up, hit delete. That means the space was actually occupied by something invisible. Otherwise, if you're trying to nudge a line over to the right and it's acting stubborn—just totally frozen on you—hit Enter and that should force it through.

wearyviper6 said:Hey there,

Just getting started here.

Look, it’s pretty straightforward if you just stop overcomplicating things. You basically just need to split your document into two distinct sections. I'm talking about setting one section for pages 1 through 4, and then starting a completely separate section from page 5 all the way to the end. Once you've got that set up, you can handle the page numbering separately for each part. It's not rocket science, really.

Alright, here’s how you handle it: First, grab that cursor and drag it all the way down to the end of page 4. From there, head over to the Insert tab, find the Breaks option, and select Next page. Once you've done that, switch over to the View tab and click on Header and Footer—that should pop up a new ribbon full of icons for you. Now, just click into the area you want, like the Footer, and pick exactly where you want those page numbers to show up. Oh, and don't forget to turn off the printing setting once you're done. It took me forever to figure this out last week when I was wrestling with a massive report for work, so hopefully, this saves you some of the headache. same as Previous So, you go ahead and click that little icon on the Header and Footer tab we were just talking about. Once you're there, you’ll see the icon for format page Number right on the same ribbon. Just head down toward... field start AT Type the number 1, then click that icon on the toolbar. I was looking through my old files earlier—you know, digging through those dusty digital archives like some sort of amateur historian—and I realized I had completely forgotten how much of a headache basic formatting can be when you're just trying to get things done. It’s one of those little tasks that seems simple on paper, but then you actually sit down at your desk, staring at the screen, and suddenly everything feels unnecessarily complicated. Anyway, if you're struggling with the basics, here is how you handle it: you need to go into the Page Layout tab. From there, look for the option to Insert page Number. It sounds trivial, doesn't it? Just click, select where you want it, and you're finished. But honestly, between the endless menus and the way software designers seem to hide the most essential tools behind layers of sub-menus, it’s enough to make anyone lose their temper. I spent twenty minutes yesterday just hunting for a setting that should have been right in front of me. Absolute madness. And then that thing will just go ahead and input the number 1, and after that, you just close the tab. Honestly, it’s one of those little quirks that drives me absolutely insane when things don't follow the logic you'd expect. You'd think it would be more intuitive, wouldn't you? But no, we're stuck doing it this way. Just enter the digit and hit Close on the tab. Simple enough, I suppose, if you enjoy the headache. CloseThat should do it. I'm talking about the 2003 version here, but honestly, the steps are probably identical if you're running Word 2007.

Look, I’m still running Word 2003—honestly, I much prefer the old interface—but since I actually have some downtime on my hands, I decided to take a crack at fixing this issue on Word 2007 myself.

Word 2007:
So, I’ll open up a Word document—could be a brand-new one or just some existing file I've been tinkering with—and then I'll just drag my cursor all the way down until I hit the very end of the fourth page.
So, I was digging through the settings again—don't ask me why, I just have this habit of clicking around when I should be working—and I got stuck on the Page Layout tab. You go into Page Layout, then you head over to Breaks, and then you're looking at that whole "Next page" mess. It’s one of those things that seems straightforward until you’re actually staring at the screen trying to make sense of it. Just one of those little hurdles, I suppose.
Alright, so I’m in there—I go to Insert, then Footer, then I hit EDIT Footer... and then I head up to the top to find that "Link to Previous" option. I need to uncheck that "same as Previous" box sitting right above the Footer frame so I can actually get things done without the whole document acting like one giant, annoying mess.
So, here’s how you actually do it without losing your mind. You go into the page Numbers settings, pick where you want them to show up—say, the Bottom of Pages—then you head right back into the page Numbers menu. From there, hit Format page Numbers, type "1" into the field start AT box, click OK, and then just hit Close. And that’s it. Easy as pie. Honestly, why does everything have to be such a convoluted mess sometimes? It shouldn't be this much work just to number a document.

Maybe you could try getting that Macro to stick by using the Save as function. You know, go down to the "Save as Type" option and just use the little arrow to pick the right format from the dropdown menu. It’s a bit of a hassle, I know, but sometimes that's the only way to make sure the software actually remembers what you did instead of just tossing it out the window. So, I was staring at my screen again today—just me, a lukewarm cup of coffee, and the endless grid of Excel—when I started thinking about those old-school MS Excel Add-In (*.xla) files. You know the ones. They’re like those vintage muscle cars sitting in a garage; they might look a bit dated to the uninitiated, but if you know how to tune them, they still pack a punch. I remember back when I first started out in Chicago, trying to make sense of massive data sets for a firm downtown, I used to rely heavily on these specific add-ins to automate the grunt work. It’s funny how things change. Nowadays, everyone is obsessed with the newest cloud-based shiny objects, but there’s something to be said for a solid, reliable Macro that just *works* without needing a constant internet connection to validate its existence. Anyway, I digress. If you're looking into working with an Excel Add-In, just make sure you've got your Security settings dialed in correctly. You don't want some rogue script running wild on your machine because you were too lazy to check the permissions. It’s like leaving your front door unlocked in the middle of the city—not exactly a brilliant move, is it? Just a thought while I try to get this spreadsheet to behave itself. It's being particularly stubborn today. Honestly, sometimes I think the software is doing it just to spite me.Look, you just need to go into Tools, then hit Add-Ins, and simply check the box next to whatever name you gave it. That’s it. It’s worth a shot, really. I mean, sometimes these things just work if you follow the steps, even if the interface feels like it was designed by someone who hates us. Just give it a try.

Give this a shot: Open up your spreadsheet, head over to Tools, then Macro, then Security, set it to Low, and hit OK. Go ahead and Close the file by selecting Yes. Now, try opening it back up again. It’s possible the security settings are cranked up too high, which would explain why the macro isn't cooperating.