General

Does a HasDependents = True property exist?
Does VBA code exist that returns a True when a cell has one or more dependents? Thanks ... 13 Apr 2010 17:22

auto fill or if function
Hi, I have a RMA form (sheet1),and I set up a customer dropdown list on column A on sheet 2; column B and C are corresponding phone number and address. I already validated A1(sheet1) with customer list on sheet 2. When I select any customer from the dropdown list on A1, how will it automatically show its phone... 12 Apr 2010 22:34

Get Data from Quickbooks
MAC Powerbook G4, OS 10.5.8 Office 2004, Excel 2004 Version 11.5.6 Quickbooks Pro 2007 I use a simple spreadsheet (CurrentBalances.xls) to keep track of the current values of my personal and business checking and credit card balances (10 different accounts) by pasting the current balances from the bank on-line ... 12 Apr 2010 21:28

Question on the formula
I would like to set up the formula based on three cells. I have data as follows: A B 10:34 Yes In column C I would like to set up formula to get the differance between column A1 and 11:00 based on the column B1. If B1 has yes then the calculat... 12 Apr 2010 21:28

Excel error: "The path you entered, ---------- , is too long. "
I get this error and must make the file name shorter even for files previously saved and used. Is there a way to increase the allowable characters for a file name. Even when opening a previously save file and simply hit resave, the name must be shortened. ... 12 Apr 2010 20:23

copy cells but lock editing
Hi everyone I have a spreadsheet where I have locked cells and password protected. within this sheet though I have not locked a specific range of cells as they are used in another sheet as source data. Is there a way that I can allow these cells to still be copied for the source data but not actually change... 15 Apr 2010 08:05

How can I insert rows BELOW, in Excel
How can I insert a row BELOW the currently selected row? In Excel 2003, after selecting a row, I could go to the Table menu and click insert rows below. Now the only option seems to be on the Home ribbon, cells group, insert button then insert sheet row, which does so ABOVE the selected row only. I a... 13 Apr 2010 17:22

Simplification of Formula
I have created the following formula from by reviewing other treads. While it works, it is very long. Any suggestions for simplification? Ideally I would like to create a Name reference for the formula but it is too long for a Name reference. ... 13 Apr 2010 10:36

Sumproduct...Average
I have 12 different tabs. I want to average a number on each tab only if the number is greater than zero. So, on tab 1 cell b6=140, tab 2 b6=245, tab 3 b6=0 and so on with b6 on each tab having a number greater than 0 sometimes. ... 12 Apr 2010 23:41

math
hi "julz" wrote:hi I'm comparing to spreadsheet but on one spreadsheet the invoices have " - " hi in the middle. Therefor it can't look up the correct number if one hi spreadsheet does not have it. How do I remove " - " from the number ?hi hi hi ... 12 Apr 2010 18:09