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
Populate table based on criteria by Kam
Hi, First of all thanks a ton for all help in the past. I need again help on some excel macro, which can Populate table from Data for selected customer...
December 8th, 2009 03:57 PM
by Kam Go to last post
1 98
choose last cell with a value in a column by jcheko
need to figure a function that identifies the last cell with a value (could be a number or a letter) in a column....I will be updating this every other day,...
December 8th, 2009 03:50 PM
by Ron Rosenfeld Go to last post
6 110
Displaying data using a variable by Maracay
Hi Guys, I have stored in a variable (TXTFNAME) the name of field’s table, the table is call BasicData and the field is call FNAME, I need to display the...
December 8th, 2009 03:41 PM
by Don Guillett Go to last post
1 128
inserting datestamps by Shane Sauter
I have a cell that changes from "In Process" to "Completed" once a series of tasks have been completed in the worksheet. Once that cell changes to...
December 8th, 2009 03:29 PM
by Niek Otten Go to last post
1 151
Colour One cell with two colors by Muffi Zainu
I want to know how to : 1. Colour One cell with two colours… the top half in one, and the bottom in another
December 8th, 2009 03:18 PM
by Jim Thomlinson Go to last post
2 90
Transpose Microsoft Query by tmacdonald
I need to transpose some data that I bring in via a microsoft query, however when I do the copy and special paste it works properly the first time, whenever...
December 8th, 2009 03:09 PM
by tmacdonald Go to last post
2 121
VB macro using in SAP by Kanagam, Nagarajan
Dears, If is possible to Excel VB macro using in SAP? I need put macro in SAP(i.e., that macro inputs put automaticaly in SAP fields and get output to...
December 8th, 2009 02:54 PM
by Bob I Go to last post
1 226
How to open Excel sheet with more than 64000 lines by mgoehring
I am using Office 2002, and have received Excel files with greater than 64000 line items. Is there a way , or an update, with Excel 2002 to open files this...
December 8th, 2009 02:51 PM
by Dave Peterson Go to last post
3 101
Set values in an Array by jlclyde
Is there a way to load an array with data from a worksheet? Here is the code I have. ActiveSheet.ListObjects("List12559").Range.AutoFilter...
December 8th, 2009 02:46 PM
by Dave Peterson Go to last post
9 136
how do i filter dependents already selected in drop down list by fras_too
I've got a three tier dependent list set up for: Division / Group / Line. (Thanks Debra Dalgliesh) If a user selects a division, group and line there are no...
December 8th, 2009 02:33 PM
by fras_too Go to last post
0 107
Character for second line in a cell by Gary Fitzgerald
What character or entity does one enter to generate a second line of text in a cell? -- Thank you, Gary
December 8th, 2009 02:20 PM
by JLatham Go to last post
2 90
Excel formula - Anyone up for a challenge? by NEHicks
I need to provide the percentage by hour per month of hospital discharges. Discharge data is kept by date then by hour of discharge. Each day could have 1...
December 8th, 2009 12:47 PM
by Minty Fresh Go to last post
6 133
adding arrows by SageOne
I have an IF function that determines if one cell is greater than another cell.....is there a way to display and up or down arrow as the result of an IF...
December 8th, 2009 12:22 PM
by Minty Fresh Go to last post
3 109
to find diffrence in time by pol[_2_]
Hi all, Please anybody can help me to write a general function that can be used in excel as well as outside excel. I have the following information opening...
December 8th, 2009 12:06 PM
by Minty Fresh Go to last post
3 94
Different date formats by David Biddulph
See your other thread. -- David Biddulph "GARY" wrote in message...
December 8th, 2009 11:49 AM
by David Biddulph Go to last post
0 103
Macro for hiding zero data rows while printing by Sandy
I want to print an Excel report where rows are accounts and columns are periods, and the data is in dollars. The report should not print out all those rows...
December 8th, 2009 11:48 AM
by Steve[_82_] Go to last post
1 90
What wrong with sumproduct function? by Eric
I would like to sum all numbers, which match following conditions, =SUMPRODUCT(($B$1816:$B$2400=$A2402),(C$1816:C$24000),(C$1816:C$2400)) press ctrl + shift...
December 8th, 2009 11:48 AM
by David Biddulph Go to last post
4 97
Dates in different formats by David Biddulph
If the dates are in A1 and B1 respectively, the formula is =DATEDIF(A1,DATE(LEFT(B1,4),1,0)+RIGHT(B1,3),"m") -- David Biddulph "GARY"...
December 8th, 2009 11:45 AM
by David Biddulph Go to last post
0 87
Macro problem by The Message
I have had someone write me a macro as below. This basically copies the top 10 numbered rows from Sheet 1 and pastes into Sheet 3. However it pastes the rows...
December 8th, 2009 11:13 AM
by The Message Go to last post
2 89
Errors in Excel 2007 Calculation by Mike Tan
Hi, I'm having problems with Excel 2007 When I total up a number of cells, the value that is shown is 0. For instance, totalling G3+j3+N3, I get 0. The...
December 8th, 2009 10:55 AM
by Mike Tan[_2_] Go to last post
4 109
Post New Thread


Display Options
Showing threads 8861 to 8880 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 12:44 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.