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
sumif problem by saziz
Hi Guys, I am using SUMIF(B1,"0") to find out negative values in column A1. Now how can I say if the value in column A1is 1 bring that value to column...
July 28th, 2004 05:00 PM
by saziz Go to last post
7 265
excel spreadsheet by [email protected]
I have a 2 sheet excel spread sheet that I put together with varing column widths. On the top 1/4 of the first sheet (of the 2 part spread sheet) I need to...
July 28th, 2004 05:02 PM
by [email protected] Go to last post
0 183
Copying from one workbook to another, without taking the name of the 1st workbook with it. by AlfD
Hi! If you are copying a whole sheet from one workbook to another, use the copy sheet dialogue box. (EditMove or copy sheet..) Remember to check Create a...
July 28th, 2004 05:04 PM
by Ron de Bruin Go to last post
1 252
Protection by BenJAMMIN
I have setup a workbook and selected certain cells to be protected. After creating a password protection for the workbook I saved it and turned it loose to the...
July 28th, 2004 05:05 PM
by Jim Rech Go to last post
1 184
Newsgroup Search -- Working? by LarryP
I've tried the Search feature a few times to find a particular sender or title, but get no results. Ditto over in the Access newsgroups. ???????
July 28th, 2004 07:04 PM
by Debra Dalgleish Go to last post
8 285
Consolidating buttons by David P.
I have a ridiculous amount of buttons that initiate macros on my worksheets. Is there a drop down menu option to consolidate or group certain buttons to make...
July 28th, 2004 07:07 PM
by Michael Malinsky Go to last post
1 204
SUMIF help- 'criteria' doesn't allow formulas? by JAnderson
The SUMIF Function, as I understand it, works as SUMIF(range,"criteria",) where the range and the sum range are actual cells. My question refers to the...
July 28th, 2004 07:22 PM
by Michael Malinsky Go to last post
4 514
[URGENT] Line Graph by jamesjustinaaron
I want to create a line graph using three pieces of data. I know how to create a series of line graphs together, no problem. What I want to do is have one line...
July 28th, 2004 07:24 PM
by Frank Kabel Go to last post
1 776
Save single worksheet as new workbook by GorillaBoze
I have a workbook containing multiple worksheets. I would like a macro that would save a single worksheet as a new file. Also, can I have the new file be...
July 28th, 2004 08:24 PM
by Ron de Bruin Go to last post
6 528
Set default values marco by RJ
I have a model where there are several user defined entries. The ones I can't seem to get to work are resetting a value from a drop-down menu. When recording...
July 28th, 2004 09:24 PM
by Rollin_Again Go to last post
2 269
Making field values appear in every cell by Eric Stephens
I have a question: is it possible to make the field values appear in every cell, instead of just the first row for that particular level? For example, instead...
July 28th, 2004 09:51 PM
by J Brydle Go to last post
1 299
sumproduct question by mark1
I have three columns. They go like this: 100 1 2 200 0 2 100 1 0 200 0 2 100 1 2 200 0 0 I've always been under the impression that a + sign
July 28th, 2004 10:14 PM
by Bob Phillips Go to last post
5 208
Setting range in a column where data ends by saziz
Hi Guys, I have two problems I trying to solve. 1) Column A & B has data (may be 500 rows) a formula is written in Column C and I like to fill it down until...
July 28th, 2004 10:20 PM
by saziz Go to last post
7 413
Autofilter help- doesn't allow formulas in its criteria? by JAnderson
Yes, this is almost identical to my earlier post about "SUMIF" not allowing formulas. Everyone was so immensely helpful, I cannot help but ask another...
July 28th, 2004 10:30 PM
by JAnderson Go to last post
7 387
worksheets and workbooks by Jason
If I have a large sheet with over 4000 rows and a number of columns including customer name, date, invoice number etc. I’d like to create duplicates of the...
July 28th, 2004 10:38 PM
by Frank Kabel Go to last post
1 428
Can't update 1 out of 4 links in a workbook??? by Bokazoit
I have 4 different workbooks named: DS, COOP, fri1, fri2. Each Workbook contains several worksheets. The first sheet in each workbook is the total for DS,...
July 28th, 2004 11:41 PM
by Dave Peterson Go to last post
2 428
Another Hyperlink Question by RogerT
Hi - I have a long list of names. Each of these names contains a non-displayed hyperlink (one hyperlink per cell). I want to copy only the hyperlinks to...
July 28th, 2004 11:43 PM
by Dave Peterson Go to last post
4 318
Subtotals by J. Mack
I get the following error message when I try to subtotal my list in Excel 2003. I have been using other versions of Excel for many year, and have never had...
July 28th, 2004 11:45 PM
by Dave Peterson Go to last post
5 336
Excel Templates by StrangerMike
Hello, this is my first post to this forum. I am brand new to Excel. I have experience with VB, .net, Access but I never used excel (other than importing...
July 29th, 2004 12:45 AM
by Dana DeLouis Go to last post
8 423
file format not valid by bill
I moved a spreadsheet from one file to another and when I try to open, I get 'file format not valid'
July 29th, 2004 01:37 AM
by hgrove Go to last post
1 187
Post New Thread


Display Options
Showing threads 2001 to 2020 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 06:17 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.