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
protect cell formatting by David
Excel 2003 - I have a spreadsheet that has various cells with different types of formatting - ie: bold / shade / font size etc. When a user copies / pastes...
December 21st, 2009 05:56 PM
by Gord Dibben Go to last post
3 145
formula by PL
Using Excel 2003. I want all the data in a row to take a specific formula, say = X * 3. But the value of X varies for each of the cell. How do I do so...
December 21st, 2009 05:50 PM
by Gord Dibben Go to last post
3 80
Stumped by lightbulb
I want column W9 of sheet 2 to say NEW if G9 on sheet 2 appears in cells B2:B50 (exact match, not partial) on sheet 1. Help?
December 21st, 2009 04:56 PM
by Jim Thomlinson Go to last post
3 115
Convert Amercan dates to English dates by Karen Souter[_2_]
Hi Can anyone tell me how to convert a column of amercan dates to english, please? Thanks KAren
December 21st, 2009 04:54 PM
by Chip Pearson Go to last post
2 117
Uninstall Office Products by MD4589
For me to work at home at my old job I needed Office 97 Pro. Now I do not need it, but I can't uninstall it without recieving message asking me to insert...
December 21st, 2009 04:40 PM
by Chip Pearson Go to last post
1 124
Lookups? by lightbulb
I'm trying to create a formula that will lookup the what is in column G in column B of another sheet. If what is in column G is in column B of the other...
December 21st, 2009 04:35 PM
by Max Go to last post
3 100
Create Drop Down Box populated by a List by Ted_MD
Would someone please tell me if I can Create a Drop Down Box populated by a List from another Worksheet which will Select an item from the Drop Down Box...
December 21st, 2009 04:32 PM
by L. Howard Kittle Go to last post
1 127
Match, VLookup... who knows? by coconut78
OK, from Access, I have a table that is exported into an Excel Workbook. This workbook, an attendance log, is formatted as follows: Child1 TimeIn ...
December 21st, 2009 03:56 PM
by Max Go to last post
3 85
Need help with macro to copy, paste, and clear cell values by Anthony[_8_]
I have a work sheet (protected but no password) that contains some cells with formulas (locked)and some cells in which I will enter numerical values...
December 21st, 2009 03:11 PM
by Don Guillett Go to last post
8 115
2007 Excel file formats by Ryan
I have a sheet with a user defined function that will run fine in 2003 however when it is opened in 2007 the function only returns a "#NAME?" error. Is this...
December 21st, 2009 03:10 PM
by Ryan Go to last post
2 69
Macro to Open another template and use the Cell in the new sheet by jpkloske
I am creating a Quote # log that is also a sales funnel for our company. I would like to: First: use the first column cell as the quote number...and when...
December 21st, 2009 02:38 PM
by jpkloske Go to last post
0 70
Links slow in 2007 by Russell
When double clicking on a cell that is linked to another workbook, instead of opening that workbook and going directly to the requisite cell, there is a long...
December 21st, 2009 11:57 AM
by Russell Go to last post
0 115
merge from an attached word doc by גולש1
hello, i recieve an attached word doc (using outlook) which is a template with different data filled in its data fields very frequently. i would like to...
December 21st, 2009 11:07 AM
by גולש1 Go to last post
0 79
Formula by PL
Hi Perhaps I have not been very clear. Let me illustrate with a more concrete eg. In row 1, I have 1, 2, 5, 100, and other random numbers. In row 2, I want...
December 21st, 2009 10:00 AM
by Joe User[_2_] Go to last post
6 66
How to refer to tab names? by Rj
Hi all, I have around 50 tabs (worksheets) to deal with in a workbook. I have to come up with a summary in another worksheet that lists down the tab names...
December 21st, 2009 09:31 AM
by Jacob Skaria Go to last post
1 88
merge by PL
Hi I have a row of words each in separte cells, I want to merge all of them into 1 cell. thanks
December 21st, 2009 07:53 AM
by Ron@Buy Go to last post
2 84
Lookup/Index 2 Criteria, find the result with furthest date by KimC
I Hhve the formula below that finds a date in Column I, that is "for sale" and is in "Suburb" =INDEX(I:I,MATCH(1,('Banner Sold (A:A="Suburb")*(B:B="For...
December 21st, 2009 07:51 AM
by T. Valko Go to last post
3 89
How to read this date format? by Eric
Does anyone have any suggestions on how to read this date format? 12/11/2009, which format is mm/dd/yyyy, but excel 2003 cannot able to recognize it, when I...
December 21st, 2009 06:53 AM
by Jacob Skaria Go to last post
2 66
Can I save "Data Text to columns" definitions by marg
I have to convert text to columns and have to repeat the process every time the data changes. The file definitions are constant and wondered if there was any...
December 21st, 2009 06:44 AM
by L. Howard Kittle Go to last post
1 82
Is there an option to view Special (control) Characters in Excel 2 by schackbo
I constantly import files into Excel 2007 (from CSV or Access files) and oten there are carriage returns hiddin within the data. Is there an option in Word...
December 21st, 2009 02:18 AM
by Dave Peterson Go to last post
3 114
Post New Thread


Display Options
Showing threads 8201 to 8220 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 07:46 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.