|
|
How to scale down my charts? by
Dag Rune[_2_]
I want to print both datatable and chart on one single page.
But it is only the datatables that are scaled down to fit the page.
The result beeing a page with...
|
|
2 |
287 |
|
|
|
May 12th, 2010 02:53 PM
by Reg
|
2 |
327 |
|
|
EXCEL (IF) by
Alicia-Paris
COLUMN E has a range from 1-5, COLUMN F I want to show a number depending on
COLUMN E. E.g. if e1=1 then f1=12, if e2=4 then f1=57. I want the F COLUMN to...
|
May 12th, 2010 01:41 PM
by Reg
|
7 |
251 |
|
|
|
|
1 |
300 |
|
|
CONDITIONAL FORMATTING- EXCEL by
Alicia-Paris[_2_]
If COLUMN Z is more than 36... then i want it to highlight the entire row.
I have 70 rows, all with different numbers in that are already all working,...
|
May 12th, 2010 01:16 PM
by Brad
|
5 |
262 |
|
|
Hyperlink to folder on Save by
Felix
Hi
I'm losing the link to my folder when I save my worksheet having set it up a
hyperlink. I've tried switiching off 'update links on Save' in the Web...
|
|
1 |
251 |
|
|
|
|
2 |
301 |
|
|
Link Pivot Tables on one filter by
steplawn
I have several pivot tables all on one worksheet and on the same tab. I
have successfully used the below vba code to get the first pivot table
to update based...
|
|
2 |
357 |
|
|
|
|
3 |
296 |
|
|
Number of the day of the year by
NDBC
I need a formula that will look at a date and tell me what number day it is
in that year. eg 31/1/2007 would show as 31. 1/3/2008 is 61. It is sort of
like...
|
|
3 |
315 |
|
|
Change rows to columns for similar records by
Katherine
Hi - am trying to change rows to columns for similar records. How do I do that?
e.g.
Staff A Cellular No. XXXXX
Staff A Office No. XXXX
Staff B Cellular...
|
|
3 |
271 |
|
|
|
|
1 |
473 |
|
|
VBA function to define name in a worksheet by
Clinton W[_2_]
I'm looking for a way to use a VB function to define a named range and alter
the quantity of cells within the named range. I recorded a macro defining a...
|
|
2 |
229 |
|
|
Vlookup by
Cerealkiller via OfficeKB.com
I am using excel 2000 I am trying to use two columns to make the end result
have a number in it
I am not sure how to word it but I need S2 and R2 to reference...
|
|
3 |
481 |
|
|
Align by
Diana
In a cell, Why are texts aligned to the left and numbers aligned to the right
in MS Excel spreadsheet?
|
May 12th, 2010 04:51 AM
by FSt1
|
2 |
215 |
|
|
Count and Reset Button Clicks by
Arlen
Hello Experts.
I have a Yahtzee game with 2 buttons/2 macros.
One button (Roll Dice) rolls the dice (Calculate) and the second button
(Next Player) clears...
|
May 12th, 2010 04:33 AM
by Arlen
|
3 |
241 |
|
|
|
May 12th, 2010 01:52 AM
by Lise
|
3 |
276 |
|
|
Extract Month From A Text String by
George
Good Day,
I have a date that I'm pulling from a report that is in a text string
format. What i need to be able to do is extract the month from the string so...
|
|
4 |
260 |
|
|
Two date validations by
Gabe
How do I create two validation rules for one cell containing a date?
1. The date (Cell A1) must be between a certain range (12/01/2009 and
12/31/2012).
2....
|
|
2 |
233 |
|
|
Create Range from Range by
dksaluki
Excel VBA:
Let's say I have a range object set to be from B2:F6, and i need to
make another range object to be the last row of my original range.
(New range to...
|
|
2 |
244 |