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
Excel: Copying A Formula by Rebecca[_6_]
How do I copy this formula ='Daily Takings'!C29-B7-D7-E7 from a cell in one workbook to a cell in another totaly unrelated workbook without the formula...
December 31st, 2009 02:20 AM
by grizzly6969 Go to last post
3 110
Micros or paste special(link) again by [email protected]
It seems my good pals did not get me well. the student report is not to be sent thru the E-mail. What I want is something that will automatically generate a...
December 31st, 2009 02:17 AM
by Leung Go to last post
1 98
Finding a value and returning corresponding info by OssieMac
Hi Vicky, The following formula assumes. Your columns start at column A (or column 1) because the column numbers are returned by the Match function. Your low...
December 31st, 2009 02:16 AM
by OssieMac Go to last post
1 113
Can I prevent a spreadsheet from being copied? by Nest Egg George
I'm going to publish a retirement nest egg calculator to the web and want to know if I can prevent buyers from copying it, or if I can restrict them to being...
December 31st, 2009 01:30 AM
by Bill Sharpe Go to last post
2 213
Micros or paste special(link) II by [email protected]
I should have added that the earlier post was to be automatic. ie after filling the students score sheet eor the class the individual report will be filled...
December 31st, 2009 12:10 AM
by [email protected] Go to last post
1 102
Excel 2007 macro compatability by Al @ Frontier
I have created a macro in Excel 2007 that includes importing a text file. It works fine on my PC, but fails on a co-workers PC running Excel 2000. The...
December 30th, 2009 11:32 PM
by Ron de Bruin Go to last post
1 145
Send Email With Cell Conent as Part of the Subject by igbert
Hyperlink is able to send email with cell content in the Subject line. My Case =HYPERLINK("mailto:Collections_Admin?subject=Overdue Balance " & "_"&...
December 30th, 2009 11:31 PM
by Ron de Bruin Go to last post
1 232
Micros or paste special(link) by [email protected]
Please i want to devolop a simple excel spreadsheet for students report. I started by making the score sheet(with totals, position in subject and grade for 8...
December 30th, 2009 11:30 PM
by Ron de Bruin Go to last post
1 134
Conditional Formats Date Based by lau
I need to format a row in a workbook so that the cells in the range change color based on a date on another workbook. It needs to be formatted so that when a...
December 30th, 2009 11:30 PM
by KC hotmail com> Go to last post
1 102
Every cell has a page break?!?! by Garyntx
Someone at my office had a file that when opened. (Excel 2007) would show every cell with page breaks showing hidden lines around every cell. Couldn't figure...
December 30th, 2009 11:22 PM
by KC hotmail com> Go to last post
4 127
Including cells that are highlighted in a formula by Robin
I have a strange requirement maybe, but I do a budget spreadsheet on which I highlight items that have cleared my checking account. I would like to be able...
December 30th, 2009 10:23 PM
by David Biddulph Go to last post
4 150
Excel formula's by ketchumbass
I am trying to create a complex formula and not sure how to do it. Hoping that someone here can help. If a cell contains "1st" then I need that to convert...
December 30th, 2009 09:57 PM
by Harald Staff[_2_] Go to last post
1 119
VLOOKUP Help by JoeL
Please bare with me, but I've never used the vlookup function and I'm having difficulties. I have two spread sheets with file numbers in column A. I need to...
December 30th, 2009 09:56 PM
by B. R.Ramachandran Go to last post
1 128
copy cell and formating by Eric
I am copying information from on sheet to another in the same workbook. Is there a way to copy the entire format of the cell automatically? Page 1 A B ...
December 30th, 2009 08:01 PM
by David Biddulph Go to last post
3 107
Count down to Words / Text by Champ
Hello, Is there a way to have a cell that is counting down from "10" and when it hits "0" spell the word FULL and in Red? example: cell BB10 has a formula...
December 30th, 2009 07:39 PM
by Champ Go to last post
5 142
Open Last Modified File form Location by Kam
Hi, I have one folder, which has 20 files & I want macro to open last modified file in that folder. Is this can be done?? File Path:...
December 30th, 2009 06:47 PM
by Randi R Go to last post
4 183
Need Help with Alpha into Numeric expressions (not ASCII/ANSI/Etc. by Karto
Hola everyone, I am trying to convert Alpha into a Numeric response so that depending on what Letter is typed in one field, a Numeric response is returned...
December 30th, 2009 06:42 PM
by Rick Rothstein[_2_] Go to last post
7 136
Inserting cells then ranking - Can this be done? by mj_bowen[_3_]
Hi, I am trying to create a ‘to-do job’ spreadsheet that will automatically insert new ‘tasks’ according to their priority. For example, on the sheet...
December 30th, 2009 06:06 PM
by mj_bowen[_3_] Go to last post
3 203
how can I clear a formula? by ManhattanRebel
I have a column that appears to have a formula in it. It is appears to calculate figures for me automatically. How can I clear the formula out?
December 30th, 2009 05:50 PM
by Fred Smith[_4_] Go to last post
7 114
Solver by TK2301
Question 1: Is there a problem using lookup tables with solver. I'm attempting to schedule different equipment. Each piece of equipment has different...
December 30th, 2009 05:24 PM
by TK2301 Go to last post
0 85
Post New Thread


Display Options
Showing threads 7861 to 7880 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:59 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.