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
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
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
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
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
converting lot of microsoft worksheets to separate workbook by n.venkatasubramanian
I have 300 worksheets in a workbook, now I want to convert all the 300 worksheets into a separate, separate workbook totall I should have 300 workbooks, please...
July 28th, 2004 04:31 PM
by Ron de Bruin Go to last post
1 427
Joining/appending two columns of data by Richard Edwards
I have two columns of data. For example; one with a list of people in the IT department and the other a list of people in the whole company. I am after a way...
July 28th, 2004 03:54 PM
by BrianB Go to last post
4 242
go back in pivot tables by Abel
when you go back to previously created pivot tables, it won’t let you do anything to it (change fields, go to layout) apart from allowing you to trace it...
July 28th, 2004 03:40 PM
by BrianB Go to last post
1 560
Pivot Tables from imported external data by jjj
Hi, I have a macro which refreshes 5 pivot tables, one after another. However, when a pivot tables data changes slightly, a message appears.."The refresh data...
July 28th, 2004 03:37 PM
by BrianB Go to last post
1 520
Link Excel to Access by Reggie
I am needing to populate an excel spreadsheet with data that is in an Access file. The problem is that the Access records are 779,834 and the Excel spreadsheet...
July 28th, 2004 03:25 PM
by Vaughan Go to last post
2 386
excel question by [email protected]
This is very strange - I have a worksheet with several pages. Any of the pages that I choose - results in the same problem. As soon as I click on a field or...
July 28th, 2004 02:22 PM
by Go to last post
1 175
Changing cell location with a formula by woknick
How can change the cell locations within a formula. Here is my formula =SQRT((B8-B7)^2+(C8-C7)^2) I want to be able to substitute user inputs for the...
July 28th, 2004 02:11 PM
by Vaughan Go to last post
2 334
Pivot Table Show detail to retained Pivot tables formatting by Adam
Dear Microsoft, When I have a pivot table summarising the Amount of "Spend" by each team I format the Spend field as a currency field in the data area. Now...
July 28th, 2004 01:10 PM
by Debra Dalgleish Go to last post
1 166
Continuing a list with text and numbers by Kevthewev.
I want to fill a column with image ID numbers followed by a suffix ie, "001.jpg" without the speech marks, and have Excel continue the list down the column,...
July 28th, 2004 12:53 PM
by Kevthewev. Go to last post
4 463
email by rows by DaleL
hello All: I'm looking for a macro that will go down a sheet and look for the email address and mail every thing in that row to *ONLY* that person no matter...
(Multi-page thread 1 2 3)
July 28th, 2004 10:24 AM
by Ron de Bruin Go to last post
24 593
Taskbar group close by bigt
On the taskbar when I have a stacked group of files with Word, Outlook, IE6, etc., I can right click and select "Close Group" to close all files. In Excel,...
July 28th, 2004 06:54 AM
by bigt Go to last post
0 176
Set of numbers by Antonio
Hi all Need your help, once again, if possible. 1 - On each set of numbers, how can i count the ones that are odd. 2 - Is there any way in a column, to know...
July 28th, 2004 05:55 AM
by Frank Kabel Go to last post
3 210
Echo Back the Cell Location by Davey Boy
Is there a VBA routine that will echo back the cell location based on the value in another cell ? For example, consider the following A B C ...
July 28th, 2004 05:52 AM
by Frank Kabel Go to last post
1 207
Excel 2002 on a Terminal Server 2003 by AJD
My users have an issue in Microsoft Excel 2002 while connected to a Terminal Server 2003. About 80% of the time when they copy and paste in a spreadsheet they...
July 28th, 2004 04:36 AM
by Harlan Grove Go to last post
4 535
Summing Just the Visible Cells by CARL
If the auto-filter is engaged, is there a way to quickly sum just the visible cells ? Thanks in advance.
July 28th, 2004 02:44 AM
by Bob Umlas Go to last post
6 253
XL2003 Validation Input Msg Problem by Phil
Hi... I need help with the Input message for a cell with data validation (when the Office Assistant is hidden). In XL2003 the input message normally follows...
July 28th, 2004 02:43 AM
by Debra Dalgleish Go to last post
3 768
Post New Thread


Display Options
Showing threads 137761 to 137780 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 11:47 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.