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
Hypeerlinks in worksheet changed locations from server to workstat by OMICOE
I have a spreadsheet that contains hyperlinks to Word docs and pdfs of reports. The spreadsheet contains database information that can direct my users to...
April 14th, 2010 06:39 PM
by Dave Peterson Go to last post
1 183
Spreadsheet with query statistics by Jimbo
I have a query in an Excel 2007 spreadsheet and set it to automatically refresh itself. I would like to have worksheet cells display information on the last...
April 14th, 2010 06:39 PM
by Jimbo Go to last post
0 169
Updating of a locked cell by Julie12345
I have a worksheet protected because it is all formulas for calculations with other worksheets within the workbook. When I change one of the unprotected...
April 14th, 2010 06:38 PM
by Dave Peterson Go to last post
1 159
Transpose Multiple Rows to one by Demosthenes
Hello, I'm trying to change the format of my data. Ex: apple 2 ab cd orange 5 ef gh banana 4 cd ef
April 14th, 2010 06:32 PM
by Dave Peterson Go to last post
4 126
Selecting only specific rows for a Sort - additional bit of info.. by mkflirting
OR, should I define a set of date ranges to cover the dates from the day after the last meeting to the day before the next meeting, for each Group, so that I...
April 14th, 2010 06:27 PM
by Dave Peterson Go to last post
1 168
Selecting only specific rows for a Sort by mkflirting
We have meetings of 5 different Groups which monitor the incomplete actions on the database that I have set up in excel. Periodically I need to print out...
April 14th, 2010 06:27 PM
by Dave Peterson Go to last post
1 126
Time formulae - delay updating when the sheet is refreshed by Colin Hayes
Hi I use these formulae to insert the date and time in separate cells on a worksheet : A14 =TODAY() B14
April 14th, 2010 06:24 PM
by Colin Hayes Go to last post
0 124
Help with InputBox and MsgBox by Preschool Mike[_2_]
How do I fix the below code so if a user does not enter anything in the input box or clicks on the cancel button they get what I have in the MsgBox? MsgBox...
April 14th, 2010 06:23 PM
by Dave Peterson Go to last post
9 149
Vlookup function... by John Smith[_11_]
Sheet "Employee Data" holds usernames of about 1500 employees in the format "joe.bloggs" in column A and employee payroll numbers in the format 00001, 00002,...
April 14th, 2010 06:20 PM
by Niek Otten Go to last post
4 116
double use of Substitution Function by Tonso
to eliminate spaces from a data validation phrase, I can enter " =Indirect(substitute(M12," ","")" and find the named range i need create a List. But, suppose...
April 14th, 2010 05:50 PM
by Tonso Go to last post
2 144
formula needed by mothertucker
x is 80% of y and y is a portion of the total of z. How do you calculate z?
April 14th, 2010 05:15 PM
by Mike H Go to last post
3 111
directing a total to various cells dependent of its value by Debi
If i have a cell value through using a series of formula's, how can i direct this value to two seperate cells (one if the value is negative and one if its...
April 14th, 2010 05:10 PM
by Jacob Skaria Go to last post
1 163
turning text into a calculated result: by Wayne C
Hello all I have a spreat sheet that looks something like this: Cases Total cigarettes 13*10*20 2,600 13*10 130 12*10*20 2,400 with col A as...
April 14th, 2010 05:08 PM
by Jacob Skaria Go to last post
3 205
Prevent Manual Calculation Mode by Evan Weiner
Is there a way to prevent the manual calculation mode. It seems 2003 "knows" when to set it. In most cases I find it annoying when results are obviously...
April 14th, 2010 05:07 PM
by Mike H Go to last post
1 128
Why does picking an cell highlight two cells? by Jnight
In an Excel 2007 worksheet, some cells when picked with the mouse highlight the adjacent cell. The cells are not merged and data is only entered into the...
April 14th, 2010 05:05 PM
by Mike H Go to last post
1 110
Excel. How do I remove 1,000 mailed addresses from list of 2,265? by Phil C.[_2_]
I have a mailing list of 2,265 names. Someone has randomly seleceted 1,000 names from the list and mailed them. I need to mail the other 1,265. I have two...
April 14th, 2010 05:01 PM
by Jacob Skaria Go to last post
6 150
From Access to Excel by Glenn_H
Good day to all. After searching this and other forums, I am at a loss for how to transcribe the following access formula to excel. ...
April 14th, 2010 04:54 PM
by Glenn_H Go to last post
4 106
How many worksheets can you have in one workbook? by KG
How many total worksheets (tabs) can you have in one workbook? Thanks
April 14th, 2010 04:47 PM
by 3665 egrdgs Go to last post
9 372
Merged Cells by Danu
I have imported data into Excel. The left-hand column has merged cells containing a reference number. The remaining columns contain varying records...
April 14th, 2010 04:41 PM
by Danu Go to last post
0 109
Macro Help by Dan Wood
My code is as follows:- Sub SendEmail() Dim Email As String, Subj As String Dim Msg As String, URL As String Email = Range("A5") For Each c In...
April 14th, 2010 04:33 PM
by Ron de Bruin Go to last post
3 114
Post New Thread


Display Options
Showing threads 2301 to 2320 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:38 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.