A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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...
May 21st, 2009 11:45 PM
by Dave Peterson Go to last post
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...
May 21st, 2009 11:36 PM
by Sheeloo Go to last post
3 99
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...
(Multi-page thread 1 2)
May 21st, 2009 11:23 PM
by pbrindman Go to last post
12 122
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...
May 21st, 2009 09:53 PM
by Sheeloo Go to last post
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 Go to last post
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 Go to last post
0 76
show a customised message when a trying to edit a locked cell by Emily Ladywell[_2_]
How do I get Excel 2007 to show a customised message when I try to edit a locked cell? I would like it to say 'ha, ha - you can't change this cell' rarther...
May 21st, 2009 06:03 PM
by Dave Peterson Go to last post
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...
May 21st, 2009 04:59 PM
by Bernie Deitrick Go to last post
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...
May 21st, 2009 04:29 PM
by Fluke[_2_] Go to last post
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 Go to last post
2 113
linking two worksheets in the same workbook by nannybears
I have a main worksheet and want to create a 2nd daily worksheet. I don't need to see all the information from the main worksheet but want the main...
May 21st, 2009 04:20 PM
by Sean Timmons Go to last post
3 95
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...
May 21st, 2009 04:19 PM
by Eduardo Go to last post
1 77
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...
May 21st, 2009 04:16 PM
by Marcelo Go to last post
3 103
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 Go to last post
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. ...
May 21st, 2009 04:01 PM
by JoeU2004 Go to last post
3 87
Calculate a date based on values in other cell, worksheet by KS
I have a worksheet (Inventory) that contains colums for PartID, Category, DateMade and DateToRecyle. I also have another sheet (RetainPeriod) in the Workbook...
May 21st, 2009 03:56 PM
by KS Go to last post
4 98
Sum if and with multiple criteria by Micki
Here's my data Column A Column B Column C H B1 10 I B2 12 J ...
May 21st, 2009 03:39 PM
by David Biddulph Go to last post
9 90
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...
May 21st, 2009 03:21 PM
by Herbert Seidenberg Go to last post
3 104
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,...
May 21st, 2009 01:47 PM
by Jarek Kujawa[_2_] Go to last post
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...
May 21st, 2009 01:20 PM
by David Biddulph Go to last post
2 88
Post New Thread


Display Options
Showing threads 10841 to 10860 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.