Posts by Kyle Johnson2

northernseal12 said:So basically, I need to grab values from Sheet1 and dump them into Sheet2 using cells AA6, AA10, AA14, and so on—basically every fourth cell.

Just head over to Sheet2, hit cell A1, and drop this formula in:
Code:

Then, in the cell right below it (A2), use this one instead:
Code:

Drag that down as far as you need.
Boom. Now you’ve got every fourth cell from column AA on Sheet1 copied over, starting from the sixth row.

northerncyclist32 said:Thanks for the quick reply. That'll help me out at work. I'm gonna try it tomorrow and let you know how it goes.

Glad it helps!
Just watch yourself in the Registry Editor. If you mess things up, there's no undo button.
Make sure you do a full Registry Backup before you touch anything.

Anonymous said:Hope someone gets what I'm asking and can help out

Not really clear what you mean. What kind of mass message? Where is it coming from? You trying to blast out a file or an Excel Spreadsheet or what?

If you're just talking about sending standard emails to a bunch of people at once, just toss all the addresses into the CC field.

If you're messing around with Excel stuff, just go look up some tutorials.

- How to email all files in a folder using Excel
- How to email a Workbook with a signature included
- How to email the active worksheet to an address in a cell

Bradley Perez91 said:Man, I don't mind waiting if you're actually down to do this..

Alright, here's what I promised

- Quarters and seasons based on dates

Bradley Perez91 said:Thanks for the help, guys, but I'm totally lost! Honestly, I don't really get what you're suggesting 😁
Can anyone walk me through this step-by-step? 😁

Busy right now, but I'll whip up a tutorial over the next few days and drop the link here on this Excel page. Hope you don't mind the wait. peace

Kate Foster12 said:Basically, I'm stuck. I can't figure out how to make it recognize there are only three values so it calculates the percentage for just those, rather than giving me a value based on all hundred people.

Just swap the row/column in the chart properties

hiddenotter98 said:I've got this massive database—rows and columns for days—and it always resets to A1 when I open it. I just want to be able to click once or twice and jump straight to a specific cell, like AA4301, so I can actually see what I'm working on.

Just split your window into two panes.
Keep whatever you need at the top visible, then use the bottom pane to jump to the cell you're actually editing.

btw: maybe hunt down some VBA code so you can just hit a shortcut key and teleport right to that cell.

Bradley Perez91 said:So, how do I write a formula—or what kind of logic should I use—to turn dates into seasons so I can sum them up in the cells to the right?

Give this formula a shot (I'm slammed right now)
Code:

or check this out
Later on, just use COUNT to get your totals

stormycrane16 said:so I messed around with those features and they work, but only halfway

I don't touch *.exe files. Upload it as a *.xls or *.xlsx file for download

hiddenotter98 said:Is there a quick way to jump straight to a specific cell after I've filtered a column?

Just type the cell address into the Name Box and hit enter.

stormycrane16 said:I want to pick an item and have the computer automatically spit out the unit of measure and price. Anyone know how?

Set up a Drop-down menu first, then just lean on the VLOOKUP function in Excel. Pro tip: give your data range a name—makes working with functions way smoother.

Jeremy Hill2 said:I need some kind of database template for writing invoices... but I'm wondering how to actually build one in Access so it links up with Excel

Look, you can grab an sample invoice in Excel and then check that same tutorial—it should have a link somewhere to download an invoice setup for Access.

Roger Thomas2 said:How do I split an A4 sheet so I can print 4 equal flyers on one page? Is there a specific program for this or can I just do it in Word?

Just set your print settings to "4 pages per sheet"

silvergull10 said:How do I sum specific cells across different sheets when they aren't even on the same row?

You could try using stuff like this: VLOOKUP, SUMPRODUCT, or SUMIFS if you're running Excel 2007 or newer. Pro tip: give your data ranges some names on those base sheets first.

For your specific setup, this formula should do the trick:
Code:

In this case, 'XY_baza' would be your named range from A1:C100.

George Morris3 said:I've got this list of names ready to go—how do I get them to automatically pop into every document? Hope you catch my drift.

Just use Mail Merge in Word.

- Mail Merge in Word 2003
- Mail Merge in Word 2007

Samuel Price58 said:Can someone refresh my memory? How do I block or mark a specific sender as spam in Outlook 2013?

Google Lots of good ideas popping up on this thread.
Some of the topics... Outlook 2003 either/or Outlook 2007 Can you take a look at this?

For Outlook 2013 right here.
- Wanna set up a rule in Outlook 2013? It's pretty simple. Just head over to the Home tab, look for the Rules section, and hit "Rules" then "Create Rule." You can pick from some quick presets or go into "Advanced Options" if you want to get specific with it. Done.
- How do I filter out this spam crap in Outlook?
- Setting up Outlook Spam filters.

In this latest visual guide, you just gotta pick the first option—basically, you're selecting the sender, whether that's a specific person or a whole distribution list.

driftingeagle16 said:Can anyone help me figure out how to use AutoText in Office 2003?

Check out AutoCorrect - AutoText in Word 2007. You should be able to find your way around Word 2003 since the commands are basically the same, just in different spots.

Quote : fooreest said:By the way, under the latest updates to federal IT regulations, using the Office 2003 suite
is actually banned.

??? That's an argument you might want to use.

Benjamin Wilson7 said:Finally dug some stuff up. If anyone else is stuck on this, give it a look:

Man, your code is totally freezing my entire Excel😕
Did a little digging online about this specific task and managed to round up some useful basic VBA snippets in one spot.

- Tracking changes in Excel

Gary Fox4 said:Thanks, man, but I’m a total newbie here—I have no clue what you're talking about. If you could just break it down step-by-step, I'd really appreciate it.

Everything you need is right there in the tutorial, plus the link for what comes next.

- Want the cursor to jump straight to the end of a Word document the second you open it? You can automate that with some quick VBA. Here’s how you do it: 1. Hit Alt + F11 to open the editor. 2. Find "ThisDocument" in the project explorer. 3. Paste this in: ```vba Sub AutoOpen() Selection.End Key:=wdStory End Sub ``` That's it. Simple. Every time you fire up the file, you're already at the bottom. No more scrolling like a maniac.
- How do you set up a VBA macro in Word?

Look, it just comes down to what you want. You gotta decide if you actually want this action—you know, that whole thing where you jump the cursor straight to the end of your Word document—to happen or not.
Every single time I open an existing Word doc (no point doing this for a brand-new one, obviously).
Just for one specific document.

Look, I'm tapped out. Can't help you much more—unless you want me to just fix it for you, but even then, I'm stuck since I can't get into your Normal.dot file if you want this applied to all your documents.

You say you're a newbie? Stick to the shortcuts. Ctrl + end Look, you gotta get better at using Word first. If you actually want to learn, just go hit up this tutorial and follow the instructions.

- Word for beginners in 63 steps—visual guides for getting around Word 2003.
- Word 2007 tutorials.

Gary Fox4 said:Is there any way to make the cursor jump to the end of the doc when I open it in Word? I just want to keep typing. Right now it always starts at the top so I have to hit > every single time.

If you're using Word, honestly, I don't see why hitting > is such a big deal—takes like a second.

But if you’re dead set on automating it, just Google "auto-position cursor at end of Word document."
Or, you could set it up using a bookmark (if it's just for one specific file). If you want it for every single doc you open, you'll need to change the default in Normal.dotm.

Alternatively, you can use some VBA code.