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
XLSX by Ranjith Kurian[_2_]
Hi , Could you someone brefily explain me what is the use of xlsx extension in excel, in what ways this file extension is helpfull for reporting and vba...
November 13th, 2009 01:38 PM
by Mike H Go to last post
1 330
Difference between versions 11.8307.8211 and 11.8169.8172 by MarkusB
I've been hunting around Technet and MSDN and haven't found an answer to what the differences are between these two versions of Excel. Does anyone out there...
November 13th, 2009 01:12 PM
by MarkusB Go to last post
3 255
Macro if condition by puiuluipui
Hi, i need a macro to add some text if a value is found in "C" column. If in C column i write "Inv", then to add from next cell this : (name,val,date,reason)...
November 13th, 2009 01:07 PM
by puiuluipui Go to last post
5 197
Excel 2010 - choose codepage when saving as text? by Greg Lovern
For those of you using the Excel 2010 beta -- when saving as text, does it allow choosing the target codepage, as Word allows? For example, if I'm running...
November 13th, 2009 01:04 PM
by Homey[_2_] Go to last post
1 257
help in saving an excel file opened in IE by Farooq Sheri
I am using the following code in a macro to access a site via Internet Explorer. After the 3rd navigate statement a window opens asking to open or save an...
November 13th, 2009 10:55 AM
by Farooq Sheri Go to last post
0 256
How to combine hyperlink and filter into one-click by James Wang
Hi, I was asked by my boss to build up a convenience mechanism for user by clicking one cell on "Summary" sheet, and automaticaly hyperlinked to "Raw data"...
November 13th, 2009 10:28 AM
by Gary''s Student Go to last post
1 251
Too many levels in the IF function? by trexcel
I am trying to create an IF formula that I can later paste into data validation. However to keep this question simple at first, I will ask it this way. Try...
(Multi-page thread 1 2)
November 13th, 2009 09:08 AM
by David Biddulph Go to last post
10 416
Formula to return Vacation weeks by Sharon
I am having trouble with creating a formula to return # of weeks of vacation based on anniversary year and current year. The formula that I have created is...
November 13th, 2009 08:32 AM
by Ron@Buy Go to last post
1 209
Roll up Bars broken by hooploid
Seems to be a bug in Project 2007: in Format\Layout..., even after deselecting "Always roll up Gantt bars", SOME of the summary bars have rollup milestones...
November 13th, 2009 08:21 AM
by FSt1 Go to last post
1 258
Compile Error: TPUtils by Twiggy27
I have Microsoft Office Professional 2003 installed. Every time I open Excel 2003 it comes up a message in a grey box "Microsoft Visual Basic, Compile error...
November 13th, 2009 05:23 AM
by Robert Flanagan Go to last post
1 242
Sorting order of foreign languages by Jonathan
I have a problem in sorting some data based on Japanese Kanji. I tried to sort in Japanese Excel it seems sorting by Shift-JIS order with the known bugs...
November 13th, 2009 04:19 AM
by Jonathan Go to last post
0 316
Large Worksheet Conditional Formatting by Skip1962
I have a worksheet that has approximately 647 fields (some are separaters) that by the end of the month has between 56 and 62 columns. I have seriuos issues...
November 13th, 2009 03:58 AM
by Skip1962 Go to last post
0 233
How to copy task pane to clipboard? by NonTechie
I can copy the entire screen using Ctrl+PrtSc. I can copy a window using Alt+PrtSc (e.g. New Question - Windows Internet Explorer). A task pane (e.g....
November 13th, 2009 03:28 AM
by Dave Peterson Go to last post
8 360
Fix this make it an optional feature. by breschke2
I hate this feature. Its pointless i only want to select one at a time. i can click and drage myself for more than one cell if i wanted to. Great! It is...
November 13th, 2009 02:02 AM
by FSt1 Go to last post
3 417
sub routine by Jim
First of all, please excuse the re-post, but I didn't receive a workable answer to my original post. Please see below, Thanks.... We have a workbook with...
November 13th, 2009 01:15 AM
by Gord Dibben Go to last post
2 282
sum the number of rows in a spreadsheet given 2 criteria??? by Hank01061567
Hi, I have a monthly sales report and i am trying to determine how many customers we have at the end of each month for the last few years so i can attempt...
November 13th, 2009 01:11 AM
by T. Valko Go to last post
3 251
Exel 2007 click on one cell and several cells are selected by milo
When I click on one cell, two or more cells are selected. When trying to do something like add or subtract, I have to hold the mouse button down and move...
November 13th, 2009 01:07 AM
by Gord Dibben Go to last post
3 243
Ebay fee formula by spudsnruf
Hello, Ebay calculate fees on products sold by using the following : 5.25% of the initial £29.99 (£1.57) + 3% of the remaining balance of the final...
November 13th, 2009 01:03 AM
by who where Go to last post
2 287
Freeze panes grayed out by Btsult
Under view in excel the freeze panes is grayed out, how do I activate it to work with frozen columns and rows in a worksheet? I just recently loaded Windows...
November 13th, 2009 01:03 AM
by Gord Dibben Go to last post
3 288
min thats = 0 by Mike
I Have 52 work sheets each sheet = one week, on each sheet cell W265 IS ZERO & on a seperate work sheet im trying to figure out min I tried alot of different...
November 13th, 2009 12:58 AM
by Pete_UK Go to last post
6 258
Post New Thread


Display Options
Showing threads 10061 to 10080 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 09:21 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.