Search results for query: *

Just combine it so it's all on one worksheet for sorting and filtering.

I have 26 tabs, a-z, I want to combine them into one worksheet. They all have the same columns. Is it possible without cutting and pasting?

I want the word form to become text within the e-mail that will be sent. Not an attachement, not a link. The three people will either be using MS Outlook or webmail via MS Outlook.

No, send it to 3 preset e-mail addresses. They would be the same e-mail addresses everytime. One person won't be printing them, I would be printing to the use as comparison for invoices, and the third person would be printing them to enter them in the company time tracker.

Any other suggestions? This can only send it as an attachment, which means that I would have to open every single attachment from 3 different people, everyday. Thats the main problem with that code...

I have created a form in Word for a department to use to submit their timesheets to three different people via e-mail. This file will either be accessed directly from where it is saved or via our intranet from a remote location. How can I set this form up so when they choose too it will...

Thank you! After the day I've had I needed a star. :)

This formula worked: =MIN(IF(B21:BD21<>0,B21:BD21,&quot;&quot;)) Press CTRL+Shift+Enter to make it an array formula.

Unfortunately, you have lost me. Mainly on the field name part. This is how the info is set up (There are 28 Agencies, A-AB) Entity AgencyA AgencyB AgencyC ...MAX MIN Indirect Cert. Costs 0 300 150 300 150 Visits 600 250 100...

I have a range of numbers that I want to find the min for and then the max for. But I want it to drop the zeros and take the numbers greater than 0. I'm sure you would use an IF statement but I'm not sure how to get it to &quot;drop&quot; the zero values.

I know in Word you can add a premade button that says Work... when you click on this your most used files appear (after you have added them). Can you do this in Excel? If so, how? Thanks!!

Thank you very much!! It stops it from appearing.

How do you make this box NOT pop up everytime you go to insert a Drawing object (i.e. text box, circle, etc.)???

We are at different offices but we are using the exact same file and are pulling it from the same place. I am not able to duplicate the runtime error... below is the code: Sub RemoveFilters() Sheets(&quot;Log Book&quot;).Select Selection.AutoFilter Cells.Select Selection.Sort...

I'm not sure if this is a version issue or something to do with the settings. I created a spreadsheet using Excel 2002 that has macros to run certain filters. These work fine in 2000. But when the other user goes to use the macro to remove all filters and sort the data by a specified column...

1. Select Tools, Letters and Mailings, Mail Merge Wizard… 2. Select the document type to the right, i.e. letter or labels. (If you are using a letter that you have created and you have opened the mail merge wizard from that letter, you will want to select, “Use the current document”.) 3...

I have step by step instructions on how to use the mail merge wizard in Word 2002. If you would like them e-mail me at amccammack@vlcpa.com. I would be glad to share them with you. It has helped the secretaries in my office a lot. I will completely agree with you, this version isn't as user...

This is a GREAT time saver!!! I export addresses and client names from our database all the time. There are a lot of children listed in it that do not need to get our mailings. I can now easily pick these out! Glad I found this.

I can get a tabular setup on the form itself but I can't on a Data Access Page, viewed through Internet Explorer. I'm trying to make this form so people that do not have Access loaded can view it, but I don't want them to edit it.

I have a database that I just want people to be able to view without them using Access. So I need to setup a data access page, but I want it to be in report form (headings with the info under the headings). All I can do is make it in tabular form. Is there a way to do this? If so could you...