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
Pivot Table Help Please! by Clint
I created a pivot table from a list of data in excell 2003, and when I add a new record(row) of data to the list it will not let me refresh the data in the...
December 11th, 2008 05:25 PM
by Clint Go to last post
1 88
Please Help! by Brian
cell a1 has the name Jones in it. in b1 I would like to have the following formula: =a1 (plus add the following) !b28 so that the name jones is returned in...
December 11th, 2008 05:25 PM
by Max Go to last post
7 103
Error message "Margins do not fit page size" in Excel? by lester5
In Excel 2007 I sometimes get an error message when setting up my page layout that "Margins do not fit the page size." I have the same basic data on...
December 11th, 2008 05:16 PM
by Sheeloo[_3_] Go to last post
3 109
Button availability by Jeff Parrott
I have several macros in a workbook and I want to assign them to buttons to make it easier for new people to use the workbook. However I commonly am required...
December 11th, 2008 05:13 PM
by Jeff Parrott Go to last post
3 88
using filter to make a merged cell correspond adjacent cells by komo2kay
i am trying to make a text/value in a merged cell correspond to several individual adjacent cells when filter is used in excel. Thank you very much.
December 11th, 2008 05:11 PM
by komo2kay Go to last post
0 308
time elapsed by tomas
I need a formula that will calculate the amount of time (in hours) that it takes us to respond to a request, but i need hours of operations and not include...
December 11th, 2008 05:00 PM
by tomas Go to last post
0 103
Why paste between workshhets yields values only by CGCPA
Excel 2007 - When coping an area of cells which contain formulas from one spreadsheet to another the target spreadsheet results shows only values of the...
December 11th, 2008 04:36 PM
by Sheeloo[_3_] Go to last post
6 115
Read Only by Carol
I have a workbook and when opened comes up as read-only. If I save with another name, it does the same thing. Acting like the file is running in the...
December 11th, 2008 04:34 PM
by Minnie Go to last post
1 82
Pivot report and Filter boxes by Bony Pony[_2_]
Hi again, In 2003, if you created a pivot report or graph from a dataset, you had the option to drive the selections from the chart itself or the underlying...
December 11th, 2008 04:26 PM
by Bony Pony[_2_] Go to last post
1 94
Sum/Frequency Formula by SiH23
In Column B I have listed various product codes, these codes are a mixture of both alpha and numerical characters, some are duplicated several times in the...
December 11th, 2008 04:23 PM
by SiH23 Go to last post
6 80
slow to open Excel 2007 and Word 2007 (MIS stumped) by JoAnn
Hello, I have been having this problem, when I asked our MIS department for help, it has them stumped also (at least I take their silence to mean that they...
December 11th, 2008 04:07 PM
by JoAnn Go to last post
0 106
Compare two sheets by CC
Hi I'm looking for a code to automate some work. compare two sheets Sheet1 "New data" and sheet2 "old data" and copy the entire row to sheet3 when...
December 11th, 2008 04:01 PM
by CC Go to last post
0 76
Extract Cell Comments/Notes to data by MSpaven75
I have a spreadsheet with Yes/No's a field values and all the meaningful data as cell comments, I know there is a way to get these notes as cell contents but...
December 11th, 2008 03:58 PM
by MSpaven75 Go to last post
7 167
Copying and Pasting by Minnie
I'm trying to copy cells of text from one workbook to another. I select the cells containing the text, copy and then go to my new workbook and paste. All ok...
(Multi-page thread 1 2)
December 11th, 2008 03:53 PM
by stew Go to last post
10 126
Formula to determine Fiscal Year by sa2960
I have the customers start date in Column A, i.e. 4/1/2007. In Column B I would like to determine what fiscal year they started in. For example: If their...
December 11th, 2008 03:51 PM
by Max Go to last post
3 147
Combining Data on two worksheets by Gemi
I have a workbook that contains two worksheets: Bookings and Sales. If the data in columns Bookings A and B match the data in columns Sales A and B I want...
December 11th, 2008 03:14 PM
by Gemi Go to last post
2 112
Add cells in pivot by tommcbrny
Hello, I would like to create a pivot table based on a web query where the output of an estimate field is: 1 week 2 days 2 days 1 day, 4 hours
December 11th, 2008 03:12 PM
by tommcbrny Go to last post
0 98
duplicates by Pammy
I have a workbook with 10 sheets, on the 11th sheet I would like to create a formula that would look on these 10 sheets and find the duplicates and bring...
December 11th, 2008 02:52 PM
by Bernard Liengme Go to last post
1 81
How do I automatically enter a date to a row when I create it by Katrena
I am inputing data onto excell and need to know when I inputted a row. Is there a way I can do this without doing manually? Please be specific as I dont know...
December 11th, 2008 02:45 PM
by Warren Easton Go to last post
1 110
I need a formula by Vercingetorix.XIII[_2_]
I have 2 columns L and N that have payment dates in them, I need a formula that will scan those 2 columsn because the payments are made in 2 equal payments...
December 11th, 2008 02:36 PM
by Luke M Go to last post
1 88
Post New Thread


Display Options
Showing threads 29841 to 29860 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:32 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.