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 : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
linking excel docs by GENO
I have linked 3 excel docs which have about 90% similar formatting and formulas. in these docs i have a list of questions which differ slightly and I would...
November 5th, 2009 08:16 AM
by Franz Verga Go to last post
1 147
making a cell resize itself to accommodate data by yawnmoth
I have an Excel spreadsheet with a cell that I'd like to make, by default, the size of two ordinary cells. I can insert a new row underneath it and then merge...
November 5th, 2009 01:25 AM
by Gord Dibben Go to last post
1 113
Allow comments to be added to protected worksheet? - Excel 2007 by sue@solotel
I have created a worsksheet with selected areas locked and then protected it. My users want to be able to add comments where necessary but are not able to. I...
November 5th, 2009 01:21 AM
by Gord Dibben Go to last post
1 166
Sort 2 columns similtaneoously by Doug Mc
I have two columns that I would like to keep together. Street and house number. Is there someway to make the street the primary sort and carry the house...
November 5th, 2009 12:37 AM
by Doug Mc Go to last post
2 125
explanation of codes in Visual Basic when creating User form by Rachel
Hi, I am trying to create a user form in Visual Basic however I'm trying to teach myself by reading/watching tutorials. (www.contectures.o.ca, etc) A lot of...
November 5th, 2009 12:19 AM
by Rachel Go to last post
2 186
ROUNDDOWN by Dan Hoffman
I'm trying to get two numbers to ROUNDDOWN. I can get the 1st number to ROUNDDOWN but I can't get the second number to ROUNDDOWN. I want to enter 3119 into...
November 4th, 2009 10:08 PM
by teylyn Go to last post
3 153
Find and IF statement by Atif
Hi: I am using following formula to search a string and display in target cell, if first IF condition returns TRUE it displays BCOT, if not #value! error....
November 4th, 2009 05:40 PM
by Atif Go to last post
6 202
format a buried data series by Robert H
I have one data series that is buried in the floor of a chart. I want to select the data series and assign it to the secondary axis. I used to be able to...
November 4th, 2009 02:56 PM
by Robert H Go to last post
1 147
using percentages by GENO
I am using percentages to calculate a score of 1 - 5 which updates a dashboard. I have an average of multiple scores adding up to 100% or less. I would like...
November 4th, 2009 02:18 PM
by Luke M Go to last post
1 136
86 Hosting Web www.ivys.es by tesddalws
Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web...
November 4th, 2009 12:58 PM
by tesddalws Go to last post
0 148
Copying Macro Needed by John Calder
Hi I run Excel 2K I need a macro that copies the contents of cell E7 to cell AG5 then the next time I run the maco it copies the contents from cell E7 to...
November 4th, 2009 06:19 AM
by FSt1 Go to last post
2 143
Saving as text(tab delimited) file by Pam
I need to save a worksheet as a text(tab-delimited), but it cannot have the ..txt at the end(e.g., remedy.1996). I know this can be done, because I have...
November 4th, 2009 02:30 AM
by Dave Peterson Go to last post
1 132
Can I calculate quartiles in an Excel 2007 pivot table? by Graeme Williams
When I build a pivot table, I can use the sum, average, minimum or maximum of the data values. Can I use quartiles as well?
November 4th, 2009 02:15 AM
by John Calder Go to last post
2 189
automatically put date and time on the cells when saving ? by Vivek
Hi i'm having to update the date and time on the changes on all the cells when i change them and i do a lot of them all the time, change tracking gives me...
November 4th, 2009 01:50 AM
by pshepard[_2_] Go to last post
1 172
Creating a hyperlink by Louise
I'm trying to insert a hperlink to a SmartArt. Is that feasible? Also, is there a way to change a color background of a page? When I click background, i'm...
November 4th, 2009 01:22 AM
by pshepard[_2_] Go to last post
3 140
Formatting in Excel 2007 by Jennifer[_2_]
I just got Excel 2007. I'm exporting from an SSRS report to Excel. One of the fields being exported is an identifying number. It is coming accross as...
November 3rd, 2009 09:02 PM
by Bernard Liengme[_2_] Go to last post
1 109
Make a postage calculator by Littlefeather
I want to create a form for a web page. When customers place a 4 digit number in a box - the adjoing box will give them a response based on their...
November 3rd, 2009 07:54 PM
by Luke M Go to last post
1 109
fitting in graphic to footer in excel by Marija
I am trying to create footer, that involves large text. I know, that i should create graphic picture to do so. Not really show how to create this graphic...
November 3rd, 2009 06:43 PM
by Gord Dibben Go to last post
3 120
conditional IF-THEN by RedBeard
Greetings, I have a column with different weekdays in different sheets. What I want to do is this: Whenever a user fills in Saturday or Sunday, I want the...
November 3rd, 2009 04:26 PM
by Bernard Liengme[_2_] Go to last post
5 153
Duplicate entires in multiple tabs by Breezy
I need something to show me if I enter a duplicate field in a tab in a worksheet. For example; I enter a list of invoice numbers on a tab "10.27.09" in col...
November 3rd, 2009 04:08 PM
by JLatham Go to last post
1 139
Post New Thread


Display Options
Showing threads 841 to 860 of 13737
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:54 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.