|
Create comment from cell range
Does anyone know if it's possible to automatically create notes based off of
data from a range of cells?
For example Sheet1, Cell A2 would have a note that displays the data that
exists in the cells on Sheet 2, Cells B5-B7. As the data in Cells B5-B7
change, the note would automatically change as well, since it is displaying
whatever is contained in those cells at that time.
...
|
3 |
26.09.2006 18:19:02 |
|
|
Office Excel 2007 for SQL Server Analysis Services
where do i download Excel 2007 for SQL Server Analysis Services?...
|
1 |
26.09.2006 18:03:02 |
|
|
Restore window "hides" worksheet
I have three worksheets open in a full excel window. When I hit the
"restore window" button at the upper right (the one that makes them
partial windows) two of them get smaller and the other vanishes. If I
click on the right click on the excel filename down in the toolbar and
select minimize the file goes to the bottom left of the excel screen as
it should. If I then right click on the minimiz...
|
2 |
26.09.2006 17:53:01 |
|
|
adding a formula
I have a macro set up that imports a query from access and adds page breaks
where I need them. (at the end of each group) I do not want them on seperate
spreadsheets. Is there a way to set up a macro that when I run it, it will
insert a blank line at the end of each group and then put a formula to add.
My problem is: the next time I import I may have more rows of information in
one ...
|
2 |
26.09.2006 17:52:17 |
|
|
auto add page breaks
I import a report from Access into Excel that has grouped together East
Precinct, West Precinct, North Precinct and Central Precinct. Is there a way
I could have excel automatically insert a page break at the end of each
group? I want it all on the same spreadsheet, I just want East on page 1,
west on page 2 and so on. Can this be done?...
|
2 |
26.09.2006 17:50:08 |
|
|
asterisk in formulas
I Have:
=IF(AND(F41=1,OR(G41="WBF/06/0MD-AU",G41="WBF/06/0MD-CH",G41="WBF/06/0MD-DE",G41="WBF/06/0MD-HTML",G41="WBF/06/0MD-OUT",G41="WBF/06/0MD-STORE",G41="WBF/06/0MD-OUT",G41="WBF/06/0MD-WEB",G41="WBF/06/0MD-WEBI")),K41,0)
I'd like to have:
=IF(AND(F41=1,OR(G41="WBF/06/0MD*",K41,0)
Why is the aterisk not working in the formula?...
|
5 |
26.09.2006 17:47:02 |
|
|
Creating a log with info from worksheets......
Ok, so I am creating a log in one sheet that is getting the information from
cells in other worksheets. This is working fine as long as I am only
requiring it to do so when the worksheet is only addressing one issue (i.e.
issue #326....). What is happening now is that I am tracking it by numbers
(i.e. issue #326 is correlated by our issue #26) but on the worksheet I now
am putting mult...
|
1 |
26.09.2006 17:43:02 |
|
|
How do I print file properties with worksheet in excel ?
I want to print file properties when I print out a worksheet.
I can't find a setting that allows me to do this.
I can do this in word though....
|
4 |
26.09.2006 17:40:01 |
|
|
How do I embed an email in an excel file?
Hi,
I'm trying to set up an excel document so the user can drag and drop and
email from outlook into the spreadsheet as an embedded object. When I try to
drag an email now, it just copies the Subject, From, and To sections.
Thanks
Dan...
|
1 |
26.09.2006 17:35:06 |
|
|
Pivot Table and Text
Is it possible to have text as a result in a pivot table? For example, if I
have an employee and a supervisor and I want to link these to their
task/duties. Or maybe I have an employee with multiple jobs, each with a
different duty.
If there isn't an option in a Pivot Table, maybe somebody could recommend
something else. Thanks a lot.
...
|
2 |
26.09.2006 17:29:35 |
|
|
Pivot Tables
In a pivot tables, I can hide the lines but how do you make the lines fill in
for all the information especially name..
Example:
I have four lines with information for Joe Smith but it only puts his name
in the first line and I need it in all four lines...
|
1 |
26.09.2006 17:28:02 |
|
|
Ignore page breaks for hidden rows
Is there a way to ignore page breaks in hidden rows when printing? When I
hide rows that contain page breaks a blank page still prints (except for the
print titles).
I'd rather not use any vba since the security settings of the many users
often block the macros.
Any suggestions?
TK...
|
2 |
26.09.2006 17:26:15 |
|
|
SQL for Oracle
I used Microsoft Excel Query to create a query that looks up an Oracle
database and of course brings results back to the spreadsheet based off the
fields from the tables and criteria I select.
Basically I have 3 tables joined by 3 different key fields.
The criteria is where I run into problems. And I'm thinking at this point
that it may just be that Excel can't handle the criteria brea...
|
5 |
26.09.2006 17:22:44 |
|
|
Excel row's limit
i am trying to export some data into an excel spreadsheet from a voxpro
program, there should be 20,390 rows of data to be exported but excel only
allow's 16,384. is there a fix for this or a way around it?
many thanks ...
|
9 |
26.09.2006 17:05:09 |
|
|
In freezed panes how do i print rows a-d and l-k together on 1 pg?
I have a freeze pane for taking inventory. How can I print rows A-D(my
products) and rows L-N(my dates) together side by side on 1 page ??...
|
3 |
26.09.2006 17:04:02 |
|
|
How do I get my column headers to go back to alphabetical?
Somehow my column headers changed from alphabetical to numbers. How do I get
them back to the default of alphabetical?...
|
3 |
26.09.2006 16:48:02 |
|
|
How do I keep same column headings on different sheets in excel
I want to keep the same column headings when I move to a new sheet in Excel,
how do i set it up so the new sheet always has the same titles, without the
need to copy and paste each time ?...
|
4 |
26.09.2006 16:47:19 |
|
|
Variations in a sheet's Visible status
At one time, wasn't it possible to set a tab in a workbook to something
like "HopelesslyHidden"? That's pinging in my memory but I can't find
anything about it. I'm seeing hidden named ranges that refer to tabs
in this workbook, but the tabs are not Hidden or VeryHidden.
...
|
3 |
26.09.2006 16:36:52 |
|
|
Query to Return Value from Seperate Worksheet
Hi, I am guilty of not spening enough time looking through these
threads to find the answer however I need some quick help... I have a
worksheet, Worksheet1, that contains a Name column and a blank column
and a second worksheet, Worksheet2, that contains a Name column and a
Number column. I would like to query Worksheet2 with the name from
Worksheet1 and return the number next to the name on...
|
3 |
26.09.2006 16:34:03 |
|
|
Attrition rates on a graph
Hi,
I'm trying to display attrition rates on a graph.
So I need my figures set up on a spreadsheet the sheet in a particular way
for the graph to make any sense of it.
I want this automated so I want to use a Pivot Table and an external CSV
data file.
My CSV data records contain
- for each client (= Client ID)
- the first payment date and
- the most recent payment date.
- Number of D...
|
1 |
26.09.2006 16:33:02 |
|
|
Halfway to End
How do I select the bottom half of a column's cells in a macro?
...
|
9 |
26.09.2006 16:30:43 |
|
|
Phantom named ranges in a workbook?
As an exercise I ran this code on a spreadsheet I've been using for
several years, which has been updated through several Excel releases.
It shows 76 named ranges, mostly starting with "HTML_" ; I have used
this file to manipulate data copied and pasted from web pages. The
..RefersTo shows a mix of values assigned and cell references. When I
click ~Insert ~Name ~Define, however, only one nam...
|
4 |
26.09.2006 16:26:54 |
|
|
Problem with Personal.xls
Windows XP Pro SP2
Excel 2002 SP3
For some reason Personal.xls isn't opening with Excel. The file exists, and
it's located here:
C:\Documents and Settings\My User Account\Application Data\Microsoft\Excel
Any ideas why or why not?
-gk-
...
|
3 |
26.09.2006 16:25:10 |
|
|
Conditional Formula help
=OR($F$1=5,$O$1=5000)This formula works fine if both conditions are met. How
would you rewrite it to show in red if only one or both conditions are met.
Say there is only a 5 in F1 and no 5000 in O1 or 5000 in O1 and no 5 in F1. I
need it to show in red if only one condition is met. Thanks in advance!!!...
|
5 |
26.09.2006 16:23:29 |
|
|
How do I set the default to open after saving?
...
|
3 |
26.09.2006 16:17:02 |