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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Pagesetup.Orientation need VBA routine to "Best Guess" Orientation by [email protected]
2003/2007 What parameters/settings with PageSetup could provide assist with calculating PageOrientation to be placed in a macro to "best guess" it? i.e. ...
November 10th, 2009 06:53 PM
by Craig Weirich Go to last post
3 175
Date Picker & Slow Open by Canon
Excel 2007 When I installed Office 2007 on my new computer, a file with a Date Picker will not work properly. I can install a new date picker and it will...
November 10th, 2009 06:51 PM
by Canon Go to last post
2 150
Adding an "X" or Check to a cell by clicking on the mouse by KAZ
Good morning, I am attempting to create a spreadsheet within Excel 2003. I have partially completed it and would like to have it so that when I click on the...
November 10th, 2009 06:50 PM
by Dave Peterson Go to last post
4 105
Multiple text search in a cell by Doug
I am attempting to search data in a cell that has multiple options of text (different countries). The problem is, I might have El Salvador but also have a...
November 10th, 2009 06:50 PM
by David Biddulph Go to last post
4 139
Complex match by Vic
Current formula puts "Yes" into cell M. I need to fix this formula so when there is a match, I need to put the value of cell K from Sheet2 into cell G of...
November 10th, 2009 05:53 PM
by Vic Go to last post
1 112
Center across selection frustrations by Brad
Example Type in "miles" in cell a1 Center across selection a1:B1 Copy a1:B1 to c1 Delete c1 The center across selection changes for (a1:B1 - now is A1:D1) ...
November 10th, 2009 05:52 PM
by Brad Go to last post
3 141
Finding data amongst empty cells by James
Hi all I have a column with 1,000 rows but only 10 of the rows contain any data and they are spread out across the 1,000. On a seperate sheet I want to list...
November 10th, 2009 05:35 PM
by Luke M Go to last post
6 134
Complex Match by Vic
I have 2 sheets. I need to compare F92 of Sheet-1 with Sheet-2 range from F21:F9300. If there is a match then I need to see corresponding value in cell I of...
November 10th, 2009 05:31 PM
by Vic Go to last post
4 142
Date to text/number Conversion by CM4@FL[_2_]
Using today's date for example: =today() = 11/10/2009 Is it possible to convert the date to text shown as 11-10-2009? Without typing it in as...
November 10th, 2009 05:21 PM
by Jacob Skaria Go to last post
3 115
Help please! by Love Carl Sagan
Does anyone have the macro to select the first cell of the last row? thanks, Carla -- There''s no end to learning!
November 10th, 2009 04:44 PM
by JLatham Go to last post
3 102
Pivot Table Calculated Field - Sum/count by Jeff Metcalf
I have a pivot table that returns data from a SQL View. The pivot table counts the total number of incedents, and sums a SLA met field. The SQL table returns...
November 10th, 2009 04:31 PM
by AFSSkier Go to last post
1 144
Cascade Drop-Down Lists? by tommcbrny
Hi all, not sure if this is possible, but can you create a cascading set of drop down lists based on a single source of data? For instance, the data...
November 10th, 2009 04:28 PM
by JLatham Go to last post
1 164
Sorting Column A & Include date in the Entire Row by sgreene1
I'm a fairly new user to Excel 2003. I have data in Columns A-D, with Column A as the "main" column to be sorted alphabetically. But when I sort, I need the...
November 10th, 2009 04:18 PM
by Dave Peterson Go to last post
2 125
Data analysis by sachi
I cannot find the "data analysis' icon in the 'data' icon on my excel sheets. Where can I find it as I need to do regression on my datas.
November 10th, 2009 03:33 PM
by David Biddulph Go to last post
3 151
Experienced Users Chime in on Recommended books for EXCEL 2007 by John C.
I am pretty familiar with EXCEL, but I want to know the tricks of using formulas, VBA, etc. What books can all of you recommend that are helpful in this...
November 10th, 2009 03:12 PM
by John Go to last post
2 237
get cell to automatically change colour depending on text in adja. by wilko
get cell to automatically change colour depending on text in adjacent cell, can anyone help?
November 10th, 2009 02:55 PM
by Chaitanya_Sagar Go to last post
2 175
Constant Data to be used for different possibilities by Cbdavis
If I have C7 as the constant but E7 or H7 or J7(depending on the imput) needs to be multiplied by it- how can I make the answer appear in D7? Example: C7 is...
November 10th, 2009 02:47 PM
by David Biddulph Go to last post
3 128
need to display 123,000 instead of 123000 using mail merge by ronw55
What do I have to do when using mail merge to get a large number to display in a word document letter with a comma?
November 10th, 2009 02:21 PM
by Luke M Go to last post
2 135
cell opens the linked tab/destination by SK
Hi, Coudl anyone please help me to be able to click the cell which then opens its destination which is on a different tab. I am aware i may use Hyperlink but...
November 10th, 2009 02:17 PM
by Dave Peterson Go to last post
2 137
How to create a master sheet of several (12 maybe more) worksheets by Saad
HI How do i create a master sheet of several (12 maybe more) worksheets that are in the same work book and in a manner that if i make changes in the...
November 10th, 2009 01:54 PM
by Eduardo Go to last post
1 145
Post New Thread


Display Options
Showing threads 10241 to 10260 of 139764
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:01 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.