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
Office DevCon in Australia by Graham R Seach MVP
Hi all, For those of you who don't know, Office DevCon (http://www.officedevcon.com.au) is the largest and most popular annual community-driven conference in...
October 12th, 2009 03:43 PM
by Jacob Skaria Go to last post
1 161
Synchronize data in two LISTBOXes by cellist
Workbook A uses a form that contains a LISTBOX whose source is a named range, AccountAbbrev in Workbook B. A second named range in Workbook B,...
October 12th, 2009 03:39 PM
by cellist Go to last post
1 157
certain rows from a lot of data by ozzyed
I'm doing an assignment on executive payments and need to organise my data set. currently i have a column for executive ID's (execid), companies for which...
October 12th, 2009 02:55 PM
by Max Go to last post
1 107
Excel - changing column reference based on value of other column by Dharmesh Patel
I am having a data in one of the worksheet, say "X" in "Y", what I am trying to do is select particular column values of "X" based on some value of column...
October 12th, 2009 02:41 PM
by Dharmesh Patel[_2_] Go to last post
4 92
Pivot Table Count by Rajula Luke - This is my display name
Hi There, Dont know if this is possible by Pivot table. I have huge data like this Resource Name Proj Name Resource Utilization Resource A Proj...
October 12th, 2009 02:36 PM
by Herbert Seidenberg Go to last post
1 110
How can I customise my headers so they are all different? by atomdunjey
I am trying to make a diary and would like the header on the even pages to say Term 1 Week 1 then Term 1 Week 2 etc but because there are also odd pages it...
October 12th, 2009 02:26 PM
by Dave Peterson Go to last post
1 134
Autosort in Excel by Riley Snyder
Hi all, I have a workbook with several sheets that link to one master sheet. The master sheet (sheet 8) is the one I enter data into and it is set up to...
October 12th, 2009 02:05 PM
by Michael R Go to last post
2 147
MS Excel - changing reference column value based on another column by Dharmesh Patel[_2_]
Hi, I am trying to things following way. Value @ 'Y'!F5 = 10, 'Y'!F6 = 20 Value @ 'X'!A3 = 5(meaning trying to have number 5 corresponding to 'Y'!F5) Now, I...
October 12th, 2009 01:19 PM
by Dharmesh Patel[_2_] Go to last post
2 122
Excel - changing column reference based on value of other column by Dharmesh Patel
I am having a data in one of the worksheet, say "X" in "Y", what I am trying to do is select particular column values of "X" based on some value of column...
October 12th, 2009 01:18 PM
by Dharmesh Patel[_2_] Go to last post
2 93
Sahpe short cut key thrgh macro by Aligahk06
Dear All, I have total eight shapes in my workbook. I want to assisg a macro for each shape and short cut key for each individual shape. While pressing the...
October 12th, 2009 12:45 PM
by Aligahk06 Go to last post
0 103
Excel sheet setup, need only 2 columns with auto-tab and return by Seaghost
Hello all, I was wondering if anyone can help me with a slight issue, I'm unsure whether Excel has this functionality. What I need is a spreadsheet using...
October 12th, 2009 12:09 PM
by Jacob Skaria Go to last post
1 118
How 2 lock row and column delete/add but allow data entry? by CC Santa Monica
How would I prevent users of a spreadsheet from deleting or adding columns while still allowing data entry into all cells? Thanks! CC
October 12th, 2009 11:17 AM
by SK Go to last post
7 115
Formula needed by Lemmesee
I habe a table like this: Columns B - C are ranges between numbers. A B C 1 15 1 5 2 9 6 10 3 19 11 ...
October 12th, 2009 11:16 AM
by Ron Rosenfeld Go to last post
4 89
can you make a drop down list in a drop down list? by Sburlingham
I have a problem, i created a drop down list of jobs that could have been preformed i need to create another list for each of those jobs to be more specific...
(Multi-page thread 1 2)
October 12th, 2009 07:58 AM
by JeromeTz Go to last post
17 495
How do I open temporary internet files by mdoyer
I frequently find that I've saved a document in the temporary internet file...always have a terrible time finding the document...how do I access the temporay...
October 12th, 2009 07:41 AM
by Jaleel Go to last post
3 124
how do i change the column name "A","B","C" by Ankur Query
how can i change the column name A, B, C, D .......IV to 1,2,3,4,5 and rows name 1,2,3,4,5.........65536 to A, B, C, D?
October 12th, 2009 06:32 AM
by Gary Keramidas Go to last post
3 76
Value filter in the pivot table is disables by Venice
Hi I created a pivot table containing all the numbers. The filter can only display the top 10 features, while the rest are filter are grayed off. So I went to...
October 12th, 2009 04:19 AM
by Venice Go to last post
0 115
How do I make excel add in one column if conditions are met in ano by Jodie
For example, I want to say, if anything in column A (from rows 1-20) =1, then add whatever is in column B for that same row and put it in field G26. Then I...
October 12th, 2009 03:57 AM
by T. Valko Go to last post
3 96
excel changes the last number I type in column??? by Mike
After setting up a worksheet for a budget, I type in the credit card numbers. If the last number of the card is 3 for example, when I press enter to go on to...
October 12th, 2009 03:22 AM
by T. Valko Go to last post
5 93
Using Office 2007 - can't find saved document by srw
I am trying to find a few documents that have seemingly disappeared from my husbands computer. He last opened at least two within the last two weeks. Now we...
October 12th, 2009 02:59 AM
by Fred Smith[_4_] Go to last post
2 90
Post New Thread


Display Options
Showing threads 11861 to 11880 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 09:52 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.