I have a workbook with over 1000 pages/tabs. Is there a command to quickly access a specific page/tab without scrolling through the entire series to get to...

Ok.. Not sure if this is possible at all.. I would like to create a column in Excel that automatically numbers. I'm creating a seniority list for my...

I have one column with a,b,c,d rankings I have another column with related $ values How can I add sum the $$ values related to all of the a,b,c,d separately

I have a workbook that has different classifications based on a dates (Classifications = Red, Green, Yellow). On the cumulative sheet I have all and then I...

Hello all, I have two column one with date & Time and other with status of vehicle, I want to count how many startup during 08:00 to 20:00 and how many...

Can I select cells to 'countif' instead of selecting a range of cells? As in every other cell, or every 3 cells?

I have a list of names and addresses that are listed in rows vs. columns, is there a way to convert the information to columns so I can do a mail merge for...

hi, i want to insert a lenght into a cell and have another cell display a size required based on a size range: say lenght 138cm gives size2 100-149cm ...

Hi, I know you can use VLOOKUP or HLOOKUP to search for value and return whatever. What if you want to search for text and return value? Mike

I am trying to figure out how to create a Vlookup formula that would do the following: I want to find the names in Column D that are not in Column A. Column...

Hello I work remotely and have to map my network drives on a daily basis. Is there a macro I can create that will allow me to map network drives? ...

I need help... I have two spreadsheets, named 2008 and RS, both with file numbers in column A1 with different information in the other columns. I need to...

I am using Ron de Bruin's "Mail one worksheet" code to send email through excel and outlook. Is there a way to cc the sender so they can confirm the email...

I want to create an order book from a order form template in excel 2007, including automatic update for a new order number, saving selected elements to a...

I have a column of data with invereted commas. ex- "123456". I need to remove these inverted commas and make the number 123456. Any Help Pls ?

I've read about Sharing, but what I really need is for several workers to use a copy of my Master SS and input their own data, and have it automatically go...

I have a list of dates (column A) say from 01/01/2005 to present and attaching values at column B. Is it possible to have a conditional format where the...

I am having difficulty applying sub-total to a filtered worksheet. My worksheet has 11 columns (6 shown in the example below). At the bottom of the...

This is the formula im using & i want it to read a zero value if these cells are blank or read zero, The only cells that have values is D Column & this...

How can I send data to an external database (to Excel from from Excel)? I need to collect variable line items from multiple users and would like them to be...