|
|
|
|
3 |
216 |
|
|
Binding a Graphic by
William Wolfe[_4_]
I need to copy 4 rows of text plus a graphic that resides within these four
rows. How do I bind the graphic to the cells so that I can copy and paste
the...
|
|
1 |
252 |
|
|
Typing Over Pivot Table Rows and Columns by
Dwight Specht[_2_]
Hi:
Quite by accident, I found that I can type over the value of a row or column
dimension in a pivot table (but not a value). The only way to clear the...
|
|
1 |
213 |
|
|
|
|
2 |
197 |
|
|
Excel found unreadable content by
Erika
I recently was upgraded to Excel 2007, when I try to open my spreadsheets
that have large pivot tables I get the Excel found unreadable content error I
can...
|
November 17th, 2009 08:21 PM
by Erika
|
0 |
267 |
|
|
Autofit Unmerged Cells (XP & Excel 2003) by
Gina
My workbook has 3 tabs. The 3rd tab is a combination of the first two. In
the 3rd tab, an example of the formula I'm using is "=TabOne!B3". I've
formatted...
|
November 17th, 2009 08:04 PM
by Gina
|
5 |
294 |
|
|
Search of a Formula/Function by
Nimish Shah
Dear Sir,
I am in seacrh of a formula. I want to fill up the cell of COST-TOm and
COST-Harry.
Product COST-TOM COST-Harry
Apple ??? ???
Mango ??? ...
( 1 2)
|
|
10 |
365 |
|
|
Automatic Data Changes by
StevenLWood
I have a work sheet that I use to monitor dates. I need to track up to 5
dates at a time. I would like my worksheet to update automaticaly when I
change the...
|
November 17th, 2009 07:55 PM
by CLR
|
1 |
241 |
|
|
CheckBox Ticked, ComboBoxBox visible? by
hoyos
I have the following code below only works when the userform is displayed. If
I un-check the checkbox which then hides a combobox. If then close the
userform...
|
November 17th, 2009 07:48 PM
by hoyos
|
2 |
197 |
|
|
|
|
1 |
217 |
|
|
Macro "on off" switch by
Larry Fitch
I have a very simple macro assigned to a button that unhides a sheet
Sub HR_Training()
'
' HR_Training Macro
' Unhide only the HR Training Hard Dollar Cost...
|
|
3 |
233 |
|
|
Complicated Forumla Help by
fgbdrum
We are computing some incentive plan payouts. Here's my scenario. Depending
on what percentage we hit, we get to apply a "multiplier" to our final
incentive...
|
November 17th, 2009 06:48 PM
by T. Valko
|
2 |
209 |
|
|
How do I fit to 1 page on entire workbook by
Val Mc
I have approx. 200 sheets in my workbook and I need to fit each sheet to one
page. I can do it individually ( ie. page set up or format painter) but it
takes...
|
|
2 |
237 |
|
|
conditional formating with text by
snakey
I have two columns of data (A:B), and want to highlight values in Col B in
coloured text, where the adjacent cell in Col A contains data entered in
brackets....
|
|
5 |
253 |
|
|
Excell Lookup formula question, 2 criteria by
MrsRose
I must be missing something in my formula, please help! (Letters in column
A, header row 1)
Looking for formula to say if in Cell H1, "b", and Cell H2, "7",...
|
November 17th, 2009 06:31 PM
by MrsRose
|
2 |
201 |
|
|
Fill Colour problem by
Sulli
Hi,
I've got a spreadsheet that has conditional formatting so the the fill
colour of a cell goes Red, 'Amber' or Green dependant on the outcome of
certain...
|
|
2 |
216 |
|
|
Conditional text display by
kumar kumar
I need some help doing this. Am using office 2000. I want to display a text based on two conditions.
If A1 = 1 then display B2=(1 - 50) or if A1=2 then display...
|
|
2 |
188 |
|
|
|
|
5 |
200 |
|
|
Rearrange data from columns to rows by
pikeda
Can someone help me with a way to quickly rearrange data from columns to rows
on a large amount of data.
Need to take data that looks like this....
...
|
|
2 |
215 |
|
|
calendar year versus fiscal year by
mePenny
I'm looking for a formula that picks fiscal year / calendar year from a sheet
that contains:
a - date
b - type of fuel (U or D)
c - amount (gallons)
d -...
|
November 17th, 2009 06:05 PM
by mePenny
|
4 |
256 |