Deleting rows causes #Ref!
Thu, 18 Mar 2010 15:42:01 -0700
Col A = Date field
Col B = Text
Col AB = reference data from col B
Col AB Row 15 = reference data from Row 14
Rows 2 to 14 contains formula - if(A2="",AB1,B2) -- Etc to row 14....
...
|
How do I create Microsoft Office Outlook Task in Excel 2007?
Thu, 18 Mar 2010 15:32:01 -0700
In Excel 2007, I am trying to use the button Create Microsoft Office Outlook
Task to use Outlook to remind me when a date approaches. I have the button on
my Excel 2007 ribbon, but it's grayed-out and I cannot use it to create tasks
in Outlook.
I know how to do it in Excel 2003, but cannot figure out how to ...
|
need to convert microsoft date to yyyymmdd
Thu, 18 Mar 2010 15:27:01 -0700
I have a file in which I concatenate two fields, the vendor and the date.
it shows as 40255-3042
I would like 20100318-3042
Here's my formula: =concatenate(O2,"-",B2)
Can anyone help me format the date field I am picking up in column O2? ...
|
How to create website link (Blue Clicky)
Thu, 18 Mar 2010 15:22:01 -0700
How do I create a clickable link to a website?
--
Ferret Mom ...
|
summing across worksheets conditionally and being able to copy for
Thu, 18 Mar 2010 15:15:01 -0700
I have about 50+ worksheets in a file that I need to sum. However, I only
want to sum some of the sheets if it meets a certain criteria. This
criteria is located in a separate worksheet in the file that lists each
worksheet name
in one column and in the next column it list the type of worksheet. If a
work ...
|
#Ref!
Thu, 18 Mar 2010 15:11:02 -0700
When deleting rows above my reference line, I get #Ref! in my referenceline.
How can I keep the proper reference in the reference line? Example:
Col A is a date field
Col B row 1 contains a Text "This is it." ,
row 2 contains =if(A2="",B1,"Why?"
row 3 contains =if(A3="",B2,"Because",,, an ...
|
Re: Autosize cells as data is entered
Thu, 18 Mar 2010 15:00:51 -0700
To autofit existing rows after you added the code, select a cell and F2 then
ENTER
This is same as typing in the cell.
Gord
On Thu, 18 Mar 2010 08:50:01 -0700, donna-LexusWebs
<donnaLexusWebs@discussions.microsoft.com> wrote:
>I added the VBA to an existing worksheet and although it didn't expand my ...
|
|
|
preprinted forms
Thu, 18 Mar 2010 14:44:06 -0700
What to print 4 billings per sheet for customers. ...
|
How can I get my mouse scroll wheel to work in excell?
Thu, 18 Mar 2010 14:12:01 -0700
My mouse scroll wheel feature does not work in excell but will work fine in
other microsoft programs. I do not need teh zoom feature but would like to
be able to use the button on my mouse to scroll down the pages instead of
having to use the scroll bar. ...
|
=Sheet!A1 formula alternative
Thu, 18 Mar 2010 14:07:02 -0700
I have 2 sheets.
Sheet 1 contains text data from A1:A200 but not in consecutive order (for
example):
Sheet1
A
1 textone
2 texttwo
3
4 textmisc
5
6 textother
I need Sheet2!B1:B50 to grab all the data from Sheet1!A1:A200 and list them
in the order that they were entered in Sheet1 as sho ...
|
