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
Data Validation - List - Setting Range from a macro by dhstein
I have a Cell that gets a drop down list from a range. The range of data will change, so I'm trying to dynamically set up the drop down from a macro. I...
May 14th, 2009 01:11 PM
by dhstein Go to last post
5 211
overlap printing by riven
my spreadsheet size is too large to print in a single sheet of paper. the only way to print it is by overlapping sheets. please teach me how... thanks in...
May 14th, 2009 12:46 PM
by Bernard Liengme[_2_] Go to last post
1 240
Text Split by DDay
Hi, I have 4000 line of data which is first and surnames combined e.g DavidHill, MarkSmith etc etc. I need a formula to divide these by the second capital...
May 14th, 2009 12:39 PM
by Roger Govier[_3_] Go to last post
5 188
Displaying contents of differnt cells from a column in pages' head by pmdoherty
sHi there, I have a sheet displaying student results, with their course codes in one column. Everything is sorted and pagebroken by course code. What I...
May 14th, 2009 12:39 PM
by pmdoherty Go to last post
0 211
Stop and show error by alvin Kuiper
Hi If i start my excel file with macros, i just get this micosoft error you all know and it shot my file down, isn't there a way to stop my program and see...
May 14th, 2009 12:26 PM
by JLatham Go to last post
2 200
Calculate next year in different cell by duketter
Excel 2007 - I have a specific date in cell A1 for example. A1 - 3/31/2009. I then want in cell G1 the exact next year calculated so for example cell G1...
May 14th, 2009 11:40 AM
by Ron Rosenfeld Go to last post
5 556
Filtering by Paul X
Hello I'm trying to automate my regular excel journal form. I want to set up a drop down filter that can look up data from another spreadsheet. eg sheet...
May 14th, 2009 11:21 AM
by Jacob Skaria Go to last post
1 340
Worksheet duplicates by puiuluipui
Hi, i need to find duplicates in all sheets and result to be, "yes" or "no". In "C" column i have numbers, and in "D" column i need the code for...
May 14th, 2009 11:07 AM
by puiuluipui Go to last post
8 332
Reading from set Row/Column location by Ant
I am not an advanced user of this product and this question I think has a simple answer, but all my research does not find a solution. What I would like to...
May 14th, 2009 09:54 AM
by Max Go to last post
4 230
Pivot Tables & data changes by Anna
Hi - I have never used pivot tables in Excel before so hopefully what I am going to ask is possible and not too complicated for me.... :o) I am working...
May 14th, 2009 08:24 AM
by Roger Govier[_3_] Go to last post
3 222
conditional formatting by LNS
How do I apply conditonally formatting to two rows which contain text? For instance; A B 1 Australia ...
May 14th, 2009 06:51 AM
by T. Valko Go to last post
7 228
Combo Box Control Strange Behavior by Tom McCray[_2_]
Using the VBA control - 90% of the time all is well, but occassionally some of the combo boxes will automatically 'resize' when I click on them. It looks...
May 14th, 2009 06:32 AM
by HelpExcel.com[_2_] Go to last post
1 214
Case Sensitive Lookup by danpt
How do I make Range("A6") to return 97, as given in the sub. Sub CaseSensitiveLookup() Range("A1") = "a" Range("B1") = "A" Range("A2") = "97" Range("B2") =...
May 14th, 2009 06:20 AM
by danpt Go to last post
3 173
Why does excel replace my 16th number with a zero? by DebR
I am trying to type 16 numbers in a column, but no matter what the last number i type is, excel changes it to 0. I've tried formatting the cell as text and...
May 14th, 2009 05:34 AM
by Jacob Skaria Go to last post
1 161
Trying to make multiple drop down lists that excludes cell in a ra by Joe
Here is my scenario. I'm have a list of products that are in varying sizes. Now all of the sizes fall into a certain range, but not all of the products...
May 14th, 2009 04:56 AM
by Jacob Skaria Go to last post
1 164
Conditional COUNTIF by Sara
What is wrong with this formula IF(COUNTIF($AQ2:$BB2,OR("ABC","DEF")),"T","F")
May 14th, 2009 04:44 AM
by Max Go to last post
4 228
Sumif w/ relative column reference by Fellow Wanderer
I would like to use sumif, but don't have a set column for the sum range. For...
May 14th, 2009 04:26 AM
by T. Valko Go to last post
3 207
Calculating a value but omitting cells with empty data by Andrew Chalk
I want to calculate a value based on several cells in say row 4. However, I do not want to include values in any columns that do not also have a non-missing...
May 14th, 2009 01:29 AM
by Harlan Grove[_2_] Go to last post
3 176
Excel Updating Modified Date When I Don't Save File by Charles
Hi, I have converted to Office 2007 and now with some of my Excel files when I use them and don't save them the modified date changes to the time I close...
May 14th, 2009 01:27 AM
by Thomas Newcomer Go to last post
4 202
sort changes row height by Christyr
How can I keep row height from changing when I perform a sort? When I sort, I lose sight of some of my information in my cells and then have to resize my row...
May 14th, 2009 01:10 AM
by Simon Lloyd[_249_] Go to last post
1 185
Post New Thread


Display Options
Showing threads 20161 to 20180 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 03:30 AM.


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