Can I save steps in a repeated process so it will automatically run?

I know nothing!! At the moment, my skills consist of the add/subtract/multiply/divide formulas and that's about it. I just recently learned how to use VLookup and was thrilled to death about that. I want to know more!

Question: is there a way to save a series of commands that are consistently used over and over so when you have a spreadsheet with a LOT of data these steps are automatically run for you without having to go through and click each command one at a time to sort/filter/delete to get down to the data you need? If I need to give an example, let me know. I will.

Hi Janice and welcome to the forum and to the world of excel

I have changed your thread title for you (this time), but for future reference, Please see Forum Rule #1 about proper thread title

Not exactly sure what it is you want to store, but once you become familiar with certain functions/formulas, they become almost automatic. Plus, each time you use most of them, the application will vary each time

This forum is a great site for help on these functions/formulas, I suggest you ask questions and look at other members threads to get ideas etc

That's what people use macros for.

I cghanged it again for you. To change your title yourself, click on EDIT on you're 1st post, then Go Advanced and change your title[/LIST]

See http://office.microsoft.com/en-us/ex...001054837.aspx and many other links by googling Excel record macros

there are a ton of books out there, but a good place to start ( I know this sounds counter-intuitive), is to start making your own. If you look in the bottom-left corner, see the READY icon? next to it is another icon, sorta looks like a worksheet with a red dot. That is the macro record button. when you click that, ANYthing you do in your workbook will be recorded, and can be played back/repeated afterwards.

Play around with it on a workbook that contains some junk data - copy stuff, paste it elsewhere, move stuff, add or delete rows, type text and/or numbers...have a blast. then on the ribbon, select VIEW, click macro, click VIEW macros, you should see the name of the macro you just recorded (it asks for a name when you start). Select that and watch it do what you just did

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.