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
How to scale down my charts? by Dag Rune[_2_]
I want to print both datatable and chart on one single page. But it is only the datatables that are scaled down to fit the page. The result beeing a page with...
May 12th, 2010 03:02 PM
by Jon Peltier[_2_] Go to last post
2 264
How to insert an Excel landscape document into a portrait Word doc by Heidi
I have a Word document in portrait style and need to insert an Excel Spreadsheet which is in landscape. Is that possible?
May 12th, 2010 02:53 PM
by Reg Go to last post
2 305
EXCEL (IF) by Alicia-Paris
COLUMN E has a range from 1-5, COLUMN F I want to show a number depending on COLUMN E. E.g. if e1=1 then f1=12, if e2=4 then f1=57. I want the F COLUMN to...
May 12th, 2010 01:41 PM
by Reg Go to last post
7 229
version differences in excel 2007 - use of macros & range names by difinity
I have a large workbook in excel 2003 which uses an embedded lookup macro to report certain data by date. works well. I now need to run this workbook in...
May 12th, 2010 01:36 PM
by JLatham Go to last post
1 281
CONDITIONAL FORMATTING- EXCEL by Alicia-Paris[_2_]
If COLUMN Z is more than 36... then i want it to highlight the entire row. I have 70 rows, all with different numbers in that are already all working,...
May 12th, 2010 01:16 PM
by Brad Go to last post
5 240
Hyperlink to folder on Save by Felix
Hi I'm losing the link to my folder when I save my worksheet having set it up a hyperlink. I've tried switiching off 'update links on Save' in the Web...
May 12th, 2010 12:29 PM
by Jacob Skaria Go to last post
1 232
want excel 2007 to stop calculating processors by Johann Terblanche
Hi There I am running excel 2007. I have a sheet with 167000 lines in it, and have to use vlookup to match fields from other files. Once i made a change, the...
May 12th, 2010 10:04 AM
by Roger Govier[_8_] Go to last post
2 279
Link Pivot Tables on one filter by steplawn
I have several pivot tables all on one worksheet and on the same tab. I have successfully used the below vba code to get the first pivot table to update based...
May 12th, 2010 09:33 AM
by Roger Govier[_8_] Go to last post
2 335
Quick selection of a record from a drop-diwn list by Divine95
Is there a quick way of selecting a record from a drop-down list without having to scroll? I usually work with drop-downs with about 5000 records and...
May 12th, 2010 09:18 AM
by Roger Govier[_8_] Go to last post
3 274
Number of the day of the year by NDBC
I need a formula that will look at a date and tell me what number day it is in that year. eg 31/1/2007 would show as 31. 1/3/2008 is 61. It is sort of like...
May 12th, 2010 09:11 AM
by Roger Govier[_8_] Go to last post
3 293
Change rows to columns for similar records by Katherine
Hi - am trying to change rows to columns for similar records. How do I do that? e.g. Staff A Cellular No. XXXXX Staff A Office No. XXXX Staff B Cellular...
May 12th, 2010 09:07 AM
by Roger Govier[_8_] Go to last post
3 249
Pivot table - value field settings - default? by smartgal
Is there a way to set the value field to a default, like SUM versus COUNT? Having to redo this on every single value in the pivot table is irritating . .. ....
May 12th, 2010 08:48 AM
by Roger Govier[_8_] Go to last post
1 451
VBA function to define name in a worksheet by Clinton W[_2_]
I'm looking for a way to use a VB function to define a named range and alter the quantity of cells within the named range. I recorded a macro defining a...
May 12th, 2010 08:43 AM
by Per Jessen Go to last post
2 208
Vlookup by Cerealkiller via OfficeKB.com
I am using excel 2000 I am trying to use two columns to make the end result have a number in it I am not sure how to word it but I need S2 and R2 to reference...
May 12th, 2010 05:27 AM
by Cerealkiller via OfficeKB.com Go to last post
3 459
Align by Diana
In a cell, Why are texts aligned to the left and numbers aligned to the right in MS Excel spreadsheet?
May 12th, 2010 04:51 AM
by FSt1 Go to last post
2 193
Count and Reset Button Clicks by Arlen
Hello Experts. I have a Yahtzee game with 2 buttons/2 macros. One button (Roll Dice) rolls the dice (Calculate) and the second button (Next Player) clears...
May 12th, 2010 04:33 AM
by Arlen Go to last post
3 219
countif with two criteria one a column of dates? by Lise
I have two columns and am entering the following formula =COUNTIF($B$2:$B$436,"**-AU-****")+COUNTIF($A$2:$A$436,"**/**/2005") The wildcards in the B column...
May 12th, 2010 01:52 AM
by Lise Go to last post
3 254
Extract Month From A Text String by George
Good Day, I have a date that I'm pulling from a report that is in a text string format. What i need to be able to do is extract the month from the string so...
May 12th, 2010 01:18 AM
by Ron Rosenfeld Go to last post
4 237
Two date validations by Gabe
How do I create two validation rules for one cell containing a date? 1. The date (Cell A1) must be between a certain range (12/01/2009 and 12/31/2012). 2....
May 12th, 2010 01:13 AM
by Gary''s Student Go to last post
2 211
Create Range from Range by dksaluki
Excel VBA: Let's say I have a range object set to be from B2:F6, and i need to make another range object to be the last row of my original range. (New range to...
May 12th, 2010 12:35 AM
by dksaluki Go to last post
2 222
Post New Thread


Display Options
Showing threads 1041 to 1060 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 01:31 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.