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
Data-Filter on Multiple Entries in Cell by XLML
Hi, I am new to the board and using XL2002. There are instances when I enter more than 1 entry in a cell. For instance, cell A2 can have the 12 months of...
June 24th, 2004 01:38 PM
by XLML Go to last post
2 169
Excel Edit - Copying problem! by ttask
Looking for an idea of how to copy parts of a spreadsheet, ignoring hidden cells. I just want to paste exactly what I see! Thanks in advance! --- Message...
June 24th, 2004 01:04 PM
by Andy B Go to last post
1 160
current time on excel by pikapika13
Right now I am using =Now() to display the current time. However, this isn't perfect bc it only gives the time when there was last activity on the workbook. ...
June 24th, 2004 01:00 PM
by Stephen Bye Go to last post
3 398
displaying comments by tjtjjtjt
Is there a way to make Excel display a comment when a cell is selected (as opposed to moving the cursor over the cell)? And, is it possible to make the comment...
June 24th, 2004 12:20 PM
by tjtjjtjt Go to last post
9 292
To make the macros know about added rows by Lana
Hi Subj. I have the subtotal of a few columns. How do I make this subtotal update if new rows have been added? ThankS a lot. --- Message posted from...
June 24th, 2004 11:54 AM
by Lana Go to last post
4 181
Last Day of a Week based on NOW() by beeawwb
Good evening all, Just a quick question. How would I work out what all the days in a week are, based upon the current date. So, have 7 cells, which would...
June 24th, 2004 10:34 AM
by beeawwb Go to last post
2 139
Vlookup and IF function problem by yuste
Hi, I would like to do a kind of double Vlookup. I have 2 different worksheets with following information: Worksheet1 is the master file with all modells: 3...
June 24th, 2004 07:43 AM
by yuste Go to last post
4 298
Recovering old versions of saved files by Spyder
Is it possible to recover an old version of an Excel file after saving it without changing the file name? Autorecover is on. Thanks for any help!
June 24th, 2004 04:43 AM
by Harlan Grove Go to last post
3 158
Filtered Rows using Mode Function? by QTE
Hi Excel Forum, I am using numeric "filtered" data and I need to find the most frequent / re-occurring values (1st, 2nd, 3rd, 4th, 5th etc.) from the...
June 24th, 2004 03:35 AM
by QTE Go to last post
4 349
Importing address from Excel to Word by NeWcS
I have a list of addresses(see attched file) and I want to insert them into a word document. Can this be done? Thank you. -Jay Attachment filename:...
June 24th, 2004 03:09 AM
by NeWcS Go to last post
3 341
find question by Steve Goodrich
how do i find information in a workbook? i've tried selecting all the sheets but only seems to finf results in the first sheet i need to seach the whole...
June 24th, 2004 02:46 AM
by Dave Peterson Go to last post
1 144
Populating a ListBox by ToddG
I'm sure this is probably pretty simple, but how do I populate a ListBox with only the populated cells in a worksheet? For example: Column A Column B ...
June 24th, 2004 02:39 AM
by Dave Peterson Go to last post
1 229
Worksheet Problem - Need all sheets to populate one by starky5
I have a excel doc that has 4 tabs(sheets) named AIX, HPUX, Windows, Other. Each sheet is a listing of all our servers of each type and the relevant info on...
June 24th, 2004 02:25 AM
by Dave Peterson Go to last post
1 154
require cell entry by kmcgee
I have set data validation to require either a 0 or 1 be entered in the range 'g5:h4740'. Is there anyway to require the data be entered and not allow someone...
June 24th, 2004 02:06 AM
by Dave Peterson Go to last post
2 235
Excel 2000 - Missing row heading, but have column heading by Peter
If you use the Tools-Options-View-Rows and Columns, you can either show or not show the A B C etc. across the columns and the 1 2 3 in front of the rows. ...
June 24th, 2004 02:02 AM
by Dave Peterson Go to last post
1 307
Excel version compatibility problem? by sue1201
6 people are sharing a single Excel spreadsheet over the network. Until recently this was not giving any problems at all. Some of them use XP Pro computers...
June 24th, 2004 01:59 AM
by Dave Peterson Go to last post
1 487
Text formatting in cells by [email protected]
I am designing a form in Excel 2000. Occasionally, in a cell I am getting what appears to be a blank line immediately above the first line of text. I have...
June 24th, 2004 01:56 AM
by Earl Kiosterud Go to last post
2 156
different workbook by andy
I have the following macro: Sub Temps() Dim myRange As Range Dim mySheet As Worksheet Set mySht = Worksheets("Temp...
June 24th, 2004 01:35 AM
by Dave Peterson Go to last post
1 138
Excel protecting formatting by Rob
Hi All How can I prevent cell formats from being removed or being overwritten when data is cut or pasted from another cell. I do not wish to rely on users...
June 24th, 2004 01:20 AM
by Dave Peterson Go to last post
1 199
hyperlink greyed out by Yosef
Excel XP windows XP I have a document with many sheets and an index page. The index page refers to the various sheets with hyperlinks. I just added a new...
June 24th, 2004 01:02 AM
by Dave Peterson Go to last post
1 236
Post New Thread


Display Options
Showing threads 138961 to 138980 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 05:23 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.