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
Conditional formatting of date-cell - 2007 by UlfHJensen
I would like to conditional format cells - in colors - containing a date if date in cell is before or after TODAY(). This is not - strangely - an option in...
April 21st, 2010 01:15 PM
by Jacob Skaria Go to last post
5 209
How did I populate other cells based on infor from one cell? by fkcadl
Hi, Ive got a spreadsheet with staff information such as network username, first name, surname, department, job title, ethnicity, age etc... How do I (if...
April 21st, 2010 01:09 PM
by Dave Peterson Go to last post
2 203
Sharing a workbook in excel 2007 by Susan
I have a workbook that i have created in excel 2007 with macros. I need to allow sharing now. I understand macros can not be viewed or edited which is...
April 21st, 2010 01:09 PM
by Susan Go to last post
0 237
Mandatory/Compulsory by Md.Siddique[_2_]
Hi Sir, I need to put a formula for a cell as mandatory/compulsory it has to fill, otherwise it will not go to the next cell. It has to display (customized)...
April 21st, 2010 01:02 PM
by Dave Peterson Go to last post
2 170
find and copy it.. by reza
hi all... hoping u can help me for saving my time. i have a master data in sheet 1 with more than 1000 rows. and now in sheet 2 i want to copy data from...
April 21st, 2010 01:00 PM
by Dave Peterson Go to last post
2 253
Single Filter to change all Pivot Tables in a Workbook by Kathy L.[_2_]
Hello experts, I've reviewed PT0021 Change All Page Fields sample Excel file (for 2007) on http://www.contextures.com/excelfiles.html#Pivot and am still...
April 21st, 2010 12:58 PM
by Roger Govier[_8_] Go to last post
8 231
Help with setting a "not found" statement by Pierre
Hi. I have a form that looks for a asset on a s/sheet list. What I need is a statement that checks to see if the asset is on the list and if not, creates a...
April 21st, 2010 12:55 PM
by Dave Peterson Go to last post
3 232
using Sumproduct with named ranges by Jenny S
Hi, Hope someone can help. I have named ranges in tab 1, Column E=B is for Branch, Column F=G is for Game, & Column G=P is for points. Named ranges are...
April 21st, 2010 12:16 PM
by Jacob Skaria Go to last post
1 234
hide columns before printing by Jean-Paul De Winter
Hi, Before actually printing my sheet I want to hide column A and B. Can I do this automatically without having to hide them manually? Thanks -- Mvg.
April 21st, 2010 11:22 AM
by Jarek Kujawa[_2_] Go to last post
6 316
Seperate data by JJ
I need help please. How do I go about to seperate data in one cell ex: A1 1-------2-b0-40810 A2 2-----------1-03-0060 I typically want...
April 21st, 2010 10:01 AM
by JJ Go to last post
5 263
Simple Yes/No drop down box by Debi
Hi, I am looking to create a simple drop down box which has yes or no as the options. For the life of me i can't remember how to do it. Thanks
April 21st, 2010 10:01 AM
by Jacob Skaria Go to last post
2 230
How do I insert a file into Excel 2007 spreadsheet ? by Chris J.
The old Excel command Insert-Object does not exist anymore, instead only these Insert {Tables | Illustrations | Charts | Links | Text } I want to insert a...
April 21st, 2010 09:03 AM
by Chris J. Go to last post
0 176
Unusual Date Format by Grey Old Man[_2_]
I am writing an Excel 2002 template. Two columns of dates (date from and date to) are both imported from an external source. The date format is 'cyymmdd' so...
April 21st, 2010 08:52 AM
by David Biddulph Go to last post
1 211
Unusual Date Format by Grey Old Man[_2_]
I am writing an Excel 2002 template. I am importing two columns of dates (date from and date to) from an external source. The date format is 'cyymmdd' so...
April 21st, 2010 08:42 AM
by Grey Old Man[_2_] Go to last post
0 190
Search and Replace, or Add New Row by GEdwards
I am using Excel 2003. Worksheet1 contains columns (A) Invoice (B) Name (C) Address (D) P.O.# ... and others. I need to perform a search of column A...
April 21st, 2010 08:20 AM
by Jacob Skaria Go to last post
1 200
Visible Shapes in a frame? by Pas
Every time I exit design mode, the shapes in a frame disappear behind the frame. Is there a way to stop that from happening?
April 21st, 2010 08:13 AM
by Pas Go to last post
4 186
Calculating Sum Series by deluth
Greetings, I can't seem to find a formula to do series of sums. I would like to calculate the following series: For n = 0 to n=B1/B3 sum:...
April 21st, 2010 08:03 AM
by Joe User[_2_] Go to last post
1 229
Formula to find the last number of a column (lower cell) by yiannis5231
I have a column with numbers. I want a formula that it will be finding the lower cell that has data. For example in column A i have numbers in cells A1, A2...
April 21st, 2010 07:10 AM
by Jacob Skaria Go to last post
1 241
Excel Spreadsheets formulas don't update by GGirl
Can anyone suggest how my formula are in active suddenly. If I had 1+1+2, and change one of the numbers to 1+2, I still get 2 in the sum.
April 21st, 2010 06:49 AM
by grizzly6969 Go to last post
1 229
Excel Spreadsheets formulas don't update by GGirl
Can anyone suggest how my formula are in active suddenly. If I had 1+1+2, and change one of the numbers to 1+2, I still get 2 in the sum.
April 21st, 2010 04:39 AM
by L. Howard Kittle Go to last post
1 237
Post New Thread


Display Options
Showing threads 1981 to 2000 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 12:29 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.