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
Extract unique data by eva cheng
I am using excel 2003 I have a file like below Rate month GBP 1.46 FEB 2000 1.47 MAR 3000 1.47 APR ...
May 7th, 2010 06:19 PM
by Ron Rosenfeld Go to last post
3 210
*****still can't post a question***** by Simon
Hi sorry for the asterisks but I am determined to find this question!!! I have posted 3 questions this week which have not appeared in any forum, let alone...
May 7th, 2010 05:41 PM
by Raveendiran RR Go to last post
3 317
can i insert a pdf file as a comment?to appear only when clicked? by dl
the same way one can enter a comment in excel and a viewer can only see that if they click on that particular cell-can i enter a pdf file the same way? if...
May 7th, 2010 05:28 PM
by Bob I Go to last post
1 231
Run Macro Automatically When Excel 2003 Opens by CBender
!!! HELP PLEASE !!!!! I have a password protected MS Excel 2003 spreadsheet with several Pivot Tables and numerous tabs collecting and displaying data...
May 7th, 2010 05:25 PM
by Dave Peterson Go to last post
2 267
Macro match function problem by Asraf
Hi all, I have a problem to create a match function macro with the following senario, whereby the lookup_array is currently at col D1 to D4, and the...
(Multi-page thread 1 2)
May 7th, 2010 05:25 PM
by Asraf Go to last post
12 431
Conversion of Nested if Formula in UDF. by Aligahk06[_2_]
Dear All, Can i convert the following formula in VBA UDF. =IF($B504="NEW INSULATION",CONCATENATE($B504,$D504,$C504,$E504,$G504),IF(AND($B504="NEW...
May 7th, 2010 05:20 PM
by Scott Gall Go to last post
2 325
Link future workbooks to a summary workbook... by Joe
I have an excel template that I use to create new workbooks. Is it possible to set-up a summary workbook that looks through a specific folder and inputs all...
May 7th, 2010 05:06 PM
by Jim Thomlinson Go to last post
1 271
Forecast with two unknown variables by Crutch
I'm hoping this is an easy question but I can't figure it out for the life of me. I've simplified my scenario down to two variables, order quantity and order...
May 7th, 2010 04:43 PM
by Crutch Go to last post
4 244
Tracking Historic Data by Ruth
Hi I have a spreadsheet which is updated once a month by several other users, on this spreadsheet i have a summary page which returns me the total number of...
May 7th, 2010 04:08 PM
by Don Guillett[_2_] Go to last post
4 219
printing an excel worksheet by lvachon
How do you print an excel worksheet without the alphabet on top and the numbers on the left hand side
May 7th, 2010 02:49 PM
by bala_vb[_13_] Go to last post
4 156
how will i delete the circular reference in my file? by myfreeacct
I don't know how it happened but there's a circular reference in the file i created and it ruins my entire file..:'(
May 7th, 2010 02:19 PM
by Dave Peterson Go to last post
2 261
Macro not running by Grey Old Man[_2_]
I have recorded a macro in an Excel 2002 template, created a Custom Menu Item, and assigned the macro name to it. When I open the template (which creates the...
May 7th, 2010 02:19 PM
by Dave Peterson Go to last post
1 218
filter non-blanks before closing by Kevin_apprentice
hello! could anyone help me with my problem? the case is, I want to auto filter the non-blanks of a column (i.e. "A3") and save it before I close the...
May 7th, 2010 02:09 PM
by Dave Peterson Go to last post
1 184
make 2003 default version by Sheahan
After I installed Excel 2003 on my machine, our IT guy also installed Excel 2007. Unfortunately 2007 now wants to be the 'default' version when I export...
May 7th, 2010 02:05 PM
by Dave Peterson Go to last post
3 209
Is there a way to force out other editors when Excel 2003 is inautomation mode? by LunaMoon
Hi all, I am using Windows scheduler to automate Excel tasks, every morning 4am... Basically, my current implementation is: 1. Auto-open Excel sheet; 2. Run...
May 7th, 2010 02:00 PM
by Dave Peterson Go to last post
3 280
How to maximize the Excel window? by Eric
Does anyone have any suggestions on how to maximize teh excel window whenever I open excel? I have set Excel application's property into maximizing window,...
May 7th, 2010 01:56 PM
by Dave Peterson Go to last post
9 246
In excel can you change words from all caps to initial caps? by O2bardy
example instead of JOHNNY WALKER I want it to be Johnny Walker.
May 7th, 2010 01:01 PM
by John Go to last post
6 273
Again: Highlight the cell/row if particular name comes.. by vinu
Hi, This was already posted but not got any attantion, So posting it agail Actually the work book will have a shift wise rostered to be given to the...
May 7th, 2010 11:00 AM
by vinu Go to last post
2 187
OLAP Pivot Table by Carissa
I have several pivot tables connected to an OLAP cube. However, the server hosting our cube has been migrated to a new location. So I need to re-direct my...
May 7th, 2010 10:42 AM
by Roger Govier[_8_] Go to last post
1 242
changing cell reference via another cell by chicolini
I have a spreadsheet with a tab (called calc) containing columns of calculations. The next tab (called D) contains a diagram which pulls numbers off of...
May 7th, 2010 10:21 AM
by Roger Govier[_8_] Go to last post
3 234
Post New Thread


Display Options
Showing threads 1201 to 1220 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:57 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.