|
|
Macros Automatically Sort by
Fran
In a spreadsheet of expiration dates and names, the sort function can be used
or a Macro can be set up to sort the dates in ascending order. Is there a
way...
|
|
3 |
101 |
|
|
Macro relative cell reference by
decimal
When I record a macro whether I use the relative reference button or not. If
I place the cursor somewhere else in the spreadsheet to perform the macro. It...
|
|
3 |
100 |
|
|
Editing Comments by
Please Help
I wondered if any one could tell me why I cant edit a comment that has been
made allready on my excel spreadsheet I can add in new ones and edit them but
any...
( 1 2)
|
|
12 |
123 |
|
|
What's Wrong: Concatenation and Function by
Walter
="Top "&$B$2&" Part Numbers by CORRS " &F2&TEXT($D$2,"mmmm d yyyy")
When I enter this in a cell I keep getting "0" as the result. It works fine
until I...
|
|
2 |
119 |
|
|
Help by
Chris
i am trying to get A1*B1*C1/1000 if D1 has "mlf" entered and totalled in E1
also i want if "RL" entered in D1 to only B1*C1 in E1
--
Chris
|
May 21st, 2009 07:28 PM
by Chris
|
7 |
99 |
|
|
hyper link to another file by
Dave
I have a hyper link in cell b4 in worksheet 1 which links to another file.
How can I link that hyperlink to cell b4 in worksheet 2 so that when I update
the...
|
May 21st, 2009 06:32 PM
by Dave
|
0 |
78 |
|
|
|
|
1 |
114 |
|
|
I Need a Tearoff Color Palette by
Jonrgrover2
I my work I have over 1 million cells to individually color. The effort of
moving my mouse back and forth between the workspace and the menus in Excel
2007...
|
|
7 |
132 |
|
|
vlookup count? by
Fluke[_2_]
Hi. I am building a report sheet that looks at other workbooks for
information and gives statistics. The other workbooks are exports from an
Oracle...
|
|
2 |
84 |
|
|
Run-time error: '1004' by
Bishop
I'm getting a 1004 runtime error for the following line of code:
CDLastRow = Workbooks("Test Tally SheetII").Worksheets("Catalyst
Dump").Range("A" &...
|
May 21st, 2009 04:28 PM
by Bishop
|
2 |
115 |
|
|
|
|
3 |
96 |
|
|
linking/updating multiple wksht comments by
Heidi
I have a workbook with multiple spreadsheets and the only thing that varies
from sheet to sheet is the "comment" column we have. I need to know how to
have...
|
|
1 |
78 |
|
|
If function with Calculation by
WallyGathor
Result I need to see in A2
If A1 1 then A3 / A1 but if A1=1 "Not required"
I have tried a few things with the IF function without success.
Thank you for...
|
|
3 |
104 |
|
|
Alloting days by
Kay
I have colum m3 with start date march 22, 2006, and colum D3:03 with month
starting from june to may. I need a formula to issue 1 day in march, 1 day
in...
|
May 21st, 2009 04:08 PM
by Kay
|
2 |
95 |
|
|
Formula help please. by
Scoober
I am trying to create a formula to calculate rental return if a property
manager is involved and charges a % of the rent.
...
|
|
3 |
87 |
|
|
|
May 21st, 2009 03:56 PM
by KS
|
4 |
98 |
|
|
|
|
9 |
91 |
|
|
Pivot Table Row Totals by
Mike
I developed a pivot table with grand totals and it will not show the "row"
grand totals. I changed my display settings within the pivot table options,
and...
|
|
3 |
105 |
|
|
Line Continuation issue by
Bishop
What am I doing wrong? Here is the line of code:
Msg = MsgBox("You have "" "" PFs loaded in the Tally Sheet. Have you
completed "" ""PFs?", vbYesNo,...
|
|
6 |
149 |
|
|
How do I keep the cell blank? by
Scoober
Hi,
I have entered this formula in cell U21
=IF(AND(S21="y",R21"",T21""),R21*(1-T21)*48,IF(OR(R21="N",),"",R21*48))
But when all the cells around the...
|
|
2 |
89 |