Search results for query: *

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 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...

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 "drop" 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!!

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

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...

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...

I have a spread sheet with 26 tabs (A-Z). They act as a log book. Names, dates, etc getted added throughout a period of time. Sometimes these sheets need to be printed. But all I want to print is the info that is there, not all the blank lines. Is there a way to do this? Let me know if I...

I have a spreadsheet that needs to be sorted. It contains over 200 listed stocks. But each stock has an additional row of info and a blank line after it. Is there a way to sort the stocks by name without losing the rows after it? This is what the sheet looks like: Astock Common Stock...

This will take some explaining. We have a Tax Return Log Book that we keep here at my firm. It has the client names, the date the info came in, intials of who prepared it, intials of who reviewed, intials of biller. I want to keep track of how many there are TO BE prepared, reviewed and...

We have some issues with a lot of our company's Excel spreadsheets. When we go to add borders to cells the default color is grey instead of black. It's that way for the entire workbook. So every time we want to add a black border, we have to select the cell, right click, format the cell, and...

Is this possible? I have a shared workbook with two macros. There are five of us that use this workbook. Is there a way to add a digital certificate to the macros or file so they don't have to click on enable every time they get into this file? If so how do I go about achieving this?

I have a search box in a spreadsheet that has 26 tabs (A-Z). This is so you can find a name or a client number. This is the code I used: Sheets(Array("A", "B", "C", "D", "E", "F", "G", "H", "I&quot...

We use a form for filing instructions in Word. Things like client name, date to file, form name, where to send, etc is entered for each client. I want to add a clear form button that does not print and that clears the data entered so we don't have to delete each item every time we want to enter...

When we are in the form we use the most we sometimes need to look at a public Outlook calendar. Instead of switching to Outlook, finding the calendar and brining it up, can I make a button in this form that brings it up?

I have a 1216 line spreadsheet, not created by me, that needs the city, state zip column split up into three cells, for converting reasons. Is there a quick and easy way to do it besides re-keying?? Of course this person needs it yesterday... Help please! Thanks so much!

I have a 1216 line spreadsheet, not created by me, that needs the city, state zip column split up into three cells, for converting reasons. Is there a quick and wasy way to do it besides rekeying?? Of course this person needs it yesterday... Help please! Thanks so much!

I have a form that is a list of names... I want to be able to have buttons at the bottom of the form ie (A-D), (E-G), etc. When the E-G button is clicked the cursor would go to the first record that begins with an 'E'. (the rest of the records after that would display under the 'E's...

I have set up a roster for the front desk at our office. This way the receptionist can keep track of where the employees are and when they are returning, along with having their extensions handy. This is also a set up where the rest of the admin department can view and make changes as needed...