Excel grouped data21935 (11/15/2009 4:31:01 PM) UtfI am using an Excel 2002 spreadsheet with 20+ worksheets that all contain
grouped data. Can anyone help with a macro that will automatically expand the
grouped data in each of the worksheets, and go to the ...
Is it possible to set tabs within an excel cell?21273 (11/15/2009 11:38:02 PM) UtfI am working on a booklet. One of the pages has 2 columns. I need to tab
over to the 2nd column rather than splitting the cells, because it will mess
up the following page if I start moving lines because ...
Calculating Difference Between Two Dates Using Only Year51089 (11/16/2009 4:37:02 PM) UtfI'm using Excel 2007. I'm trying to calculate the Age at Death when given
the birth and death years.
I tried using the =DATEDIF function, but 2007 doesn't seem to support it.
Then I tried =YEAR(C3)-Y...
Text box disappears with 2 columns01458 (11/16/2009 4:25:01 PM) UtfI have added a text box with 2 columns to an Excel spreadsheet. If I keep
the text in 1 column, I can see it when I'm elsewhere on the spreadsheet but
as soon as I create 2 columns, I can only read the tex...
Would like help making a function4609 (11/15/2009 7:45:05 PM) SarahHi, folks!
I'd like help coding a VBA function. Here's what I'm looking for: I want to
be able to use the function in a formula like this:
where "Foo" is a match from a predefined ...
engaging filter option in multple tabs0779 (11/16/2009 3:05:02 PM) UtfWhat is the best way to engage a filter to the value '1' in all tabs of a
large spreadsheet? The filter itself is specified in cell A1 of each tab of
the spreadsheet except the first tab which has no filter...
email addresses tied to a spread sheet0658 (11/16/2009 2:13:03 PM) UtfWhen I attach an excel spreadsheet using the ‘send to mail recipient’ and
then select ‘send the current sheet as the message body’ the email addresses
that we always had tied to each sheet are no longer sho...
Save or Export to CSV2906 (11/16/2009 1:24:01 PM) UtfHello, I have a macro that i recorded that is intended to export (save) data
from the active worksheet within a workbook to a CSV file. The problem i'm
having is that the macro is saving the entire workbo...
what does "calculate" mean in status bar?21857 (11/16/2009 1:30:01 AM) UtfIn a single file, when it is opened, the word "calculate" appears on the
status bar on the left next to the word ready. Can anyone tell me what this
means and why it only appears in a particular file.
current time4859 (11/15/2009 7:12:02 PM) UtfWhen I use (ctrl+shft+;) to get the current time it always displays the
seconds as 00. Is there any way to get the seconds also?
Workbook LOCKED - Up01402 (11/16/2009 9:13:01 AM) Utf091116 Workbook LOCKED - Up
hi, I have ran into a strange formula problem. a line that works follows,
the next example somehow got inserted into my sheet.
conditional formatting - 358671770 (11/16/2009 6:42:01 AM) Utfhi community
how can i use the Conditional Formatting to format 2 criteria at a same
time, an example:
if the cell value is greater than 0, it will format a shade color of gray