General

Locked Cells
I have a spreadsheet that contains locked cells. Others have to be able to type data into certain fields only, but when someone has Excel 2000, they can't type anything in. It gives them a message that the sheet is protected. Is there a workaround for this? I created this workbook in Excel 2007. ... 26 Apr 2010 17:14

Specify shape dimensions
Glad to know there is a way, although I am not that good at VBA. I was sad to learn that the dimension feature for shapes in Excel 97 had been removed the 2007 version. I depended on it a lot for various tasks. JakeA "SteveT" wrote: Thanks Chuck, I will look into that, Kind regards, Steve ... 26 Apr 2010 17:14

CONCATENATE by criteria and range
Wondering if there is a simple formula to concatenate row 1 values based on the criteria of "df" for each date. This formula could be placed in another column. Realize that eventually there will be upto 70 people and 365 Days. A B C E Bill Joe Frank 1-Jan-10 df df 2-Jan-10 df df df 3-Jan-10 df 4-Jan-1... 26 Apr 2010 19:31

Automate sheets list
Hi to all, I have been looking on how to get this through. I have a workbook with at least 3 sheets, that can increase to 20, 30, etc... or reduced to 3. the first 3 sheets are always in the workbook, as standard. The thing is that in the second sheet i want to list all the sheets present in the workbook, as ... 26 Apr 2010 21:45

Excel Formula
How do i get the data to the right of slash using a formula the formula below works for data to the left of the slash thank for any help. Cell A1 - 11.25 / 12.25 =MID($A$1,1,FIND(" / ",$A$1,1)-1) Results = 11.25 ... 26 Apr 2010 17:14

SUMIFS functions for excel 2003.
I want a formula that has a search for many different criterias: EX: Look for "Account", Int the "Account Group" ... look for "Production" In the "Production" column ... look for "January" Is there a way to do this ... any questions or misunderstandings or if you didn't understand what I said please let me ... 26 Apr 2010 17:14

clear inputs macro
THis macro seems to be clearing all items from the sheet I only need it to clear the rows i have listed Sub clear_inputs_new() ' ' clear_inputs Macro ' ActiveWindow.ScrollRow = 1 Range("I11:I114").Select Selection.ClearContents Range("AD11:AD114").Select Selection.ClearContents End Sub ... 26 Apr 2010 18:22

Help with SUMPRODUCT formula !!!!!!!!!!!!!!!!!!!!!
=SUMPRODUCT(('Sites Task List_Logical'!$B$2:$B$5776=$C26)*('Sites Task List_Logical'!$Q$2:$Q$5776=FALSE)) =SUMPRODUCT(('Sites Task List_Logical'!$B$2:$B$5776=$C26)*('Sites Task List_Logical'!$Q$2:$Q$5776="FALSE")) why are the above formulae giving me a "#VALUE!" error ... 26 Apr 2010 16:06

'Save As' hangs Excel XP 2002 SP3
I have a problem in our office. For the most part Excel works fine. We can open files and save them as long as we dont use the 'Save As' feature and try to save it to a Network Drive. Files can be saved locally then have to be copied to the Network Share. Of course my first reaction was 'Permissions Issue'. BU... 26 Apr 2010 14:57

Can I open a new Excel document in a separate instance of Excel?
I need to work with multiple spreadsheets side by side, and Excel's default behavior is driving me mad. I don't want all 4 workbooks open in the same instance of Excel; even the "compare side by side" is too cramped. How can I open each document in a separate instance of Excel, or a new window that I can drag a... 26 Apr 2010 14:57