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 to word macro by dwake
So I created a macro that opens a word file and pastes into excel. The problem I'm having is closing the word document after it has been used. Here is my...
December 2nd, 2009 07:48 PM
by Susan Go to last post
1 100
Landscape selected but printout persists in portrait. How to fix? by R.Lamkin
Occasionally, I have had a spreadsheet I created in landscape layout revert somehow to portrait. It still indicates that it is in landscape in the page...
December 2nd, 2009 07:45 PM
by Susan Go to last post
1 101
Max Number of Users by Jason D. Miller[_2_]
Is there a way to limit the maximum number of users for a shared workbook?
December 2nd, 2009 07:36 PM
by Jason D. Miller[_2_] Go to last post
0 84
HOW TO FORMAT THE HOME KEY WITHOUT USING CTRL by Shelley
In the previous version of Excel that I was using when you used the home key it brought you to the beginning of the worksheet. In 2007 you have to use the...
December 2nd, 2009 07:20 PM
by Gord Dibben Go to last post
3 129
Formula problem by a
I have updated data and the formula result changes to 0. The table is set to automatic calculation, I have tried F9 and changing the format to general. ...
December 2nd, 2009 07:20 PM
by Gary''s Student Go to last post
1 118
Insert a border into a header or footer in Excel 2007 by ktyn
Is there a way to insert a border into a header/footer in Excel 2007?
December 2nd, 2009 06:59 PM
by ktyn Go to last post
0 162
Closing file with macro by dwake
I would like to automatically close a file without saving using a macro. Any suggestions?
December 2nd, 2009 06:49 PM
by Gord Dibben Go to last post
3 90
display cell content based on date criteria by hsg
My worksheet contains several columns of data, first column being DATE. each day new information is filled in column B to K, but in Column A, all the...
December 2nd, 2009 06:37 PM
by David Biddulph Go to last post
2 94
Help w/ Formula! by alh06
This is what I am trying to find: Of the people in column 'A' who identified as a "2", what percentage also identified as a "5" in column 'B'? -- I have...
December 2nd, 2009 06:34 PM
by alh06 Go to last post
6 94
find the upper case letters within a cell by april
i have a cell that is a journal reference. here is an example US POSTMASTER --1025093-1-July Intl Renewal- Perm. the upper case letters refer to the...
December 2nd, 2009 06:13 PM
by Jacob Skaria Go to last post
3 104
Calcution with two conditon by Rao Ratan Singh
Sir, I am going to a creat sheet for invoice. I want a formula that can calculate taxes with two different rates based on item name. means - when it found in...
December 2nd, 2009 05:58 PM
by T. Valko Go to last post
7 129
Adding up relevant cells by James
Hi all I have a list of months and % attributed to those months for a number of countries in a spreadsheet (see below) elsewhere I have a sheet with a list...
December 2nd, 2009 05:49 PM
by James Go to last post
2 89
Coloured Cells by The Message
I have a set of data in sheet 1 and I need to transfer to sheet 2. I have used VLOOKUP to transfer 10 selected rows of data from sheet 1 which displays in...
December 2nd, 2009 05:44 PM
by The Message Go to last post
8 98
#VALUE! when using defined name by WAMTC
HELP!!! Problem: receive #VALUE! Using a defined NAME range In workbook MonthlyBudget09Mstr.xlsx are sheets 1209Sch and 1209 1209Sch contains all monthly...
December 2nd, 2009 05:42 PM
by T. Valko Go to last post
3 85
How to define a charts range based on the value of a cell by chris
Hi is this possible? I want to create a graph and have it automatically ajust its range based on a value of a cell. I have 2 columns of data which are...
December 2nd, 2009 05:34 PM
by chris Go to last post
1 82
Can't add trendline in Excel 2007 by Lionel
I have created a simple two line chart and I'm trying to add a trendline to both, however, under layout tab, the trendline box is greyed out (under analysis)...
December 2nd, 2009 05:30 PM
by Lionel Go to last post
2 130
Consolidate multiple entries by Karthik
Hi All, I've a query data which has multiple entries in Column A and B and different info in Columns C-H. I'm trying to consolidate this data, but couldn't...
December 2nd, 2009 05:26 PM
by Daryl S[_2_] Go to last post
1 72
Duplicate "Drag" feature by Randaylb
I am currently working within a very large spreadsheet which incorporates the following formula: =CONCATENATE("",'Sheet 1'!BC5,"") This populates data into...
December 2nd, 2009 05:17 PM
by Randaylb Go to last post
2 98
date conditional formatting by lolan7
Thank you Frank for your brilliance. Thank you tjtjjtjt for the question. Exactly what I needed to know. lolan7 "tjtjjtjt" wrote: Thanks, Frank. I'd found...
December 2nd, 2009 05:14 PM
by lolan7 Go to last post
0 85
How do I count number of days from a range of dates & some repite. by Juan Roubaud
I am using excel 2007 and I need to get the count of days from a range of dates where some dates are repited; one diferent date is equal to one day. I will...
December 2nd, 2009 05:13 PM
by Pete_UK Go to last post
2 92
Post New Thread


Display Options
Showing threads 9181 to 9200 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:06 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.