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
Common range name for 2 sheets by David
Excel2000 I've been scouring the archives for what I want and all posts seem to advise against it, but I want it!!! I have a workbook where each sheet has a...
January 24th, 2006 04:26 PM
by Dave Peterson Go to last post
6 130
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? by Raven
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? I am completely new to macro programming. After...
January 24th, 2006 04:28 PM
by Dave Peterson Go to last post
1 189
Removing characters from a cell (keeping only the numbers) by Monk
Hi.., Is there a formula to enable me to copy just the numbers of a cell which also contains letters/characters (example Cell A1: FT’’/@12345’ ) All I...
January 24th, 2006 04:32 PM
by Ron Coderre Go to last post
9 215
Shared Workbook Protection by Mike
I need to share a workbook with several people. The workbook will contain one worksheet where the user will be able to enter certain information....
January 24th, 2006 04:38 PM
by Dave Peterson Go to last post
1 83
Paste special formulas? by mturner
I've used the paste special formulas option after copying a column. However it is still pasting the values aswell. Anybody have any ideas why this is...
January 24th, 2006 04:39 PM
by Anne Troy Go to last post
1 174
Want to paste ASCII, not "formatted" by KHashmi316
If I paste text *directly* into a cell, Excel formats the text to look like the original. If I paste the text into the formula bar, the text in the cell is...
January 24th, 2006 04:39 PM
by Arvi Laanemets Go to last post
5 125
2 users open same file and both can edit/change the file by RANDY
If one user open a file, how can I prevent the other user from open the file for editing. In the past Excel/Word normally display a read-only message when a...
January 24th, 2006 05:06 PM
by Anne Troy Go to last post
1 113
Linking Cells with Hidden Data by mellowe
Hi All Just a query here.....is it possible to have a cell expand with more data or linked to more data that can be accessed by clicking on that Cell: e.g...
January 24th, 2006 05:06 PM
by mellowe Go to last post
2 70
nested formulas by Ctrl-Alt-Del
I am trying to get a previously built worksheet to properly run some formulas. We have three product types, designated "C", "P", and "M". The worksheet has a...
January 24th, 2006 05:17 PM
by Ctrl-Alt-Del Go to last post
3 90
Forumla to recognize text by Woody13
I'm trying to use a basic IF THEN statement but I need the IF function to recognize whether there is text in a cell or if its blank. =IF(cellA2 has text,...
January 24th, 2006 05:17 PM
by Max Go to last post
2 101
Drop Down Box & Macro by A.S.
Hello, I want to create a macro so that when I select a country from a drop down box, then hidden data for the country appears. For example, I select Argentina...
January 24th, 2006 05:21 PM
by Dave Peterson Go to last post
3 93
need sum to show instead of formula in cell by Linda
I am trying to sum a column of numbers. Unfortunately the formula shows up instead of the actual sum. Please help!
January 24th, 2006 05:24 PM
by bigwheel Go to last post
2 81
Automating Linear Interpolation by smurray444
Hi there - thanks for looking, I have a large dataset with various columns of data for global climate (meteorological) stations, however the dataset is not...
January 24th, 2006 05:25 PM
by smurray444 Go to last post
0 79
If Statement - Help Needed by Portuga
A1 B1 C1 D1 A2 B2 C2 D2 A3 B3 C3 D3 How can I do the following in A1, A2,...
January 24th, 2006 05:26 PM
by Ron Coderre Go to last post
4 96
#VALUE error with XIRR by bdyer30
The XIRR function returns #VALUE with the following data (no guess). Excel help says that #VALUE is returned when dates are not valid, but when I use more...
January 24th, 2006 05:29 PM
by Ron Rosenfeld Go to last post
7 108
January 24th, 2006 05:39 PM
by Texasuser Go to last post
2 99
Printing certain criteria by [email protected]
I am interested in learning how to use criteria to print only certain sheets as well. Here is my scenario: I have approximately 500 sheets and each sheet...
January 24th, 2006 05:52 PM
by Ron de Bruin Go to last post
1 108
Activecell, not for cell,but for range? by mturner
Is there a way of referring to an active selection of cells in vba, like you can activecell for an individual...
January 24th, 2006 05:55 PM
by Jim Rech Go to last post
1 67
highlighter by jlm@yell-o-glow
Does anyone know of a tool that highlights the row, column, or both that you are currently in?
January 24th, 2006 06:24 PM
by ufo_pilot Go to last post
1 79
How do I change the output value of a drop down box? by DALLIN
I want to create a drop down box that displays a rebar size. upon selection of the size, in the output cell designated, I would like it to display the area of...
January 24th, 2006 06:31 PM
by ufo_pilot Go to last post
1 100
Post New Thread


Display Options
Showing threads 30001 to 30020 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:48 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.