Help with Vlookup Function
Fri, 26 Feb 2010 21:19:09 -0800 (PST)
Hey there.
I'm working with two sheets on a file. On the first sheet is a list of
students and the schools that they attend, with the student in column
A and the school in B. There are 200 rows. In sheet2, there is a list
of the schools and a countif for the number of students at each.
There are six student ...
|
summarize open issues
Fri, 26 Feb 2010 20:28:01 -0800
i have 3 different open issues lists on 3 tabs of a workbook that i want to
summarize the priority items onto one list on another tab. i want to tick off
items in priority order by a,b,c etc. and collect them in sorted priority
order all on one tab. does anyone have any ideas how i can do this? i
appreciate ...
|
sorting protected sheet not working
Fri, 26 Feb 2010 23:12:16 -0500
I'm getting the impression from my tests and reading various forums that
this is not possible even though the protection dialog box has an option to
allow sorting.
I'm creating a spreadsheet on the fly from MS Access vba based on some SQL
data. This is distributed to another company so they can fill in some ...
|
Excel page no. display OFF
Fri, 26 Feb 2010 19:00:47 -0800
>When I view my worksheet in the "Page Break Preview", I can see the Page Number shown on the worksheet as watermark. ...Is there any way I can get rid of it ...?
>>In short...no
That is a real, real pain. This splatch on my page consistently hides my texts & figures. It has been the single most infuriating, n ...
|
Excel Page display
Fri, 26 Feb 2010 18:46:34 -0800
> When I view my worksheet in the "Page Break Preview", I can see the Page Number shown on the worksheet as watermark. .. Is there any way I can get rid of it ...?
>>In short...no
That is a pain. A real, real pain. Why don't you just emblazon the page with a huge "Microsoft" logo?
Sorry but for years of usi ...
|
Add and subract Time
Fri, 26 Feb 2010 15:12:02 -0500
I found a time card worksheet on-line and I don't understand the formula.
It works but even when I evaluate the formula I don't understand why.
D E F G
Start Wrk Start Lun End Lun End Wrk
8:00 AM 11:00 AM 1:00 PM 5:00 PM
The row with the times is 8.
the form ...
|
Can't Run Macros; Blocked By Security
Fri, 26 Feb 2010 10:27:40 -0800 (PST)
My hard drive crashed, and I had to re-install Office 2007. I open
Excel, and try to open .xlsm workbook I'd created previously. when it
opens, I have under the ribbon:
Security Warning Macros have been disabled.
So I click the Options button, and I get:
"Security Alert This file contains encrypted macros ...
|
|
|
How to make a 'comment' transparent
Fri, 26 Feb 2010 10:16:04 -0800
Any way to format 'comment' transparency (default = opaque) ?
--
Thanks again for your help.
akm (XPpro,SP-2,IE-7,Office2003)
...
|
Excel 2007 Macro shortcut key doesn't work but menu selection does
Fri, 26 Feb 2010 09:49:01 -0800
I have a very short set of Macro's one of my users has recorded. All of them
worked at first but now one of them will not function via the shortcut key.
It will function if you select and run it by using alt-f8, clicking on it
then run. Out of curiosity I reinstalled office, same problem. Then I even
gave hi ...
|
A single location for all my Macros
Fri, 26 Feb 2010 07:15:58 -0800 (PST)
Good morning,
I'm wondering if there is a way to get all of the macros that I have
scattered across a bunch of files in a single locations, like
Personal.xls? Some macros are used very infrequently and if I had
them all in one location, I wouldn't have to spend the day looking for
them.
Related to this, i ...
|
