Please advise regarding the VBA code that allows me to have a password for each sheet I have used a code that allows me to always have the main sheet...

Is there any way to set up in Excel to catch duplicate entries. Expamle: the same address entered in different worksheets

I’m trying predicting some sport results (14). I know I can predict very well some of them ((lets say 10) but I know some are very hard to predict. Let say...

I have the following: A table with the following data: AR LA MS ...

I am using the following sumifs statement: =(SUMIFS(EVERYTHING!$D$1:$D$3856,EVERYTHING!$B$1:$B$3856,A2,(EVERYTHING!$E$1:$E$3856),"07/13/2008"))/1000000 to...

How do I make the status bar larger so it is easier to read the sum number in the status bar. Or... is there a way to display the sum of highlighted cells in...

I'm trying to use autofill to copy cell references from a different workbook/sheet. On the worksheet i'm trying to copy from, the data i would like to...

Is there a way of adding more than 3 conditional formats?

Exel Chapter 3. Lab 3 Mannually decrementing values in a worksheet.

Hi there, I have some data formated as below 7:00 15:00 7:00 15:00 8:00 16:00 7:00 15:00 7:00 15:00

My toddler's playgroup needs to arrange worksheet data in a bizarre fashion (one record per every 4 lines) from a conventional worksheet table with one...

Hi I need asistance with this problem: Column A Column B P1 08:22:00 P2 02:45:00 P1 03:15:00 P3 ...

I am trying to use the following function to get an average using letters as variables under a criteria. However, there are blank cells which are being...

I place a formula that calculates something for me in a cell, then I have a cell on a different worksheet reference that formula cell. The problem is, onc...

Hello Community: I several columns of data. I need an excel macro that will look at a specified column (I:I) and delete all cells that are a value I...

I'm trying to combine a number and word using the &. The formula bar says =2007&"utah", and it's giving me a #value error. When I copy the cell and paste...

I have 20 salesmen, each with different quotas and start dates. For example Guy A has $424 in and shows 57% since his quota is 783 YTD. But Guy B has $18...

I have a time sheet calculating comp t time used if hours worked (G18) under 8 (based on time in and out) =IF(G188,0,8-G18) If the employee doesn't work...

Hello ... I'm sure this is a very simple issue, but I just cant figure it out! I am creating a purcahse order and have a list of product name. I want to...

I am exporting the "Actual Work" values from MS Project into an excel worksheet. Unfortunately, 40 hours is stored as "40h" in excel which makes it...