I have attached a small portion of my file. In worksheet 1 the only thing I want to have to change is the date (cell A1). I want cells B2,B5,B8 to select the...

Using Excel 2000 is there a way to do the following: Copy collapsed subtotals to another location and paste them so they do NOT expand into the detail; only...

I am trying to find a way to create a workbook with many worksheets for our employees. I would like to limit access for each worksheet by password and only...

Hi, I have a sheet (sheet1) with 2 columns, column 1 has customer name with duplicates and column 2 has customer number with duplicates. I have removed using...

Thanks everyone Reference Thread preceding this text Background I need to show a minus figure in the total if the result is better than target ie target (c40)...

Hi all I have the following code to change the color of the cell( the cell underneath from where the data is). I have values from 0 to 100 in Range...

I'm trying to add up values in one row if the values in two other rows (in the same column) fall in the right values. In Sheet 1 I have a list of dates, Y or...

I am using the topsheet of my workbook to reflect the information on all subsequent worksheets - each worksheet is represented by a row. I have a ton of...

I need help with a function I don't quite understand. I have a column of numbers that are coded by initials in the next column. Example: Column A has 30...

Hi, I have a sumproduct formula which I need to include an "indirect" function. How does it work? e.g. when I...

I have a cell (B5) that is referenced to another cell (A1). It simply copies whatever is inputted into A1 into B5. How do I make it so if there is nothing...

Hello all, can someone pls tell me how to protect one single cell in a worksheet..... thank u Lara

I tried the below formula and it doesn't work properly. It's a macro. What I would like to do is print certain worksheets within a workbook on...

I have a macro that automatically saves a purchase order file with the name of the sales rep, but I want it to also include a value they enter in a particular...

Is there a way to sum data for cells that are visible, that is not hidden? An example is below. With Columns C through G visible Col B Col C Col D Col E Col...

I have used this newsgroup several times and always get my answer. Im just wondering who you people are that answer these questions? And thank you to you all...

Hi, I want to use a Dynamic Range Name. From visiting Chip Pearsons site (excellant site!) I have the...

I have this formula here which works as...

Hi, I have about 400 cells that contain the date and time in this format 05/04/04 11:34 CDT How can I get just the date from these cells so that I can use...

I am simply trying to enter data as minutes (i.e. 40, 30, 45, etc.), add those minutes (in this case, to get 115 minutes), but have the display calculated in...