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 : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Replies Reverse Sort Order Views
Number of entries in drop down box by theslaz
I have a drop down box in my spreadsheet that I use for listing the builders that I work with/for. It appears that the max. number of entries is 12. Can I...
(Multi-page thread 1 2)
February 16th, 2009 08:10 PM
by Gord Dibben Go to last post
17 599
Merging Colums by Spatzz
Hi i have a sheet with data in the following format Column1 Column2 Column3 etc Y Y ...
(Multi-page thread 1 2)
May 20th, 2007 02:01 AM
by Spatzz Go to last post
17 192
Validating times by Jack Isaacs
Hello All This really follows on from my previous post. I have a worksheet that will be used for simple data entry of name, address, etc etc. - 1 column per...
(Multi-page thread 1 2)
October 6th, 2007 10:09 AM
by MartinW Go to last post
17 220
Upgrade to 2007 by PA
We have been using Office 2002 for 4 years, with approxiately 6000 users, have a large selection of macros used by many of our users. The question we are...
(Multi-page thread 1 2)
June 6th, 2007 06:50 AM
by Stan Brown Go to last post
17 248
August 27th, 2008 09:58 PM
by Gord Dibben Go to last post
16 548
projecting sales for month by Karen Smith
i know formula but can't get it to work; I have to take the sales for the day multiply it by the accounting day and then divide it by total number of days but...
(Multi-page thread 1 2)
November 14th, 2006 12:34 AM
by Dave Peterson Go to last post
16 317
Sort macro with descending by [email protected]
Hi... I'm trying to put in a macro that will sort the data in column G... what I have now is: Sub SortMe() Cells.Sort Key1:=Range("G1"), Header:=xlYes End...
(Multi-page thread 1 2)
August 16th, 2007 09:03 PM
by Gord Dibben Go to last post
16 199
LIST out all the data according to the "Criteria" by wilchong via OfficeKB.com
There are 3 data sets are assumed running in A6, in B6 and in C6 down, viz.: In A6 down is data of "date": 1-Jan-07, 1-Jul-07, 1-Nov-07, 1-Apr-08 and...
(Multi-page thread 1 2)
May 9th, 2008 02:02 AM
by Max Go to last post
16 293
Help with macro by Theslaz
I have a workbook with 5 pages ( I apologize if those are not the right terms ) 1 for "Reference tables" 1 for "Invoice data Entry" 1 for "Job Pending &...
(Multi-page thread 1 2)
November 30th, 2008 03:47 PM
by Simon Lloyd[_42_] Go to last post
16 268
Find a specific posting by Jerry
How do I find a posting that I posted so I can see the replies
(Multi-page thread 1 2)
September 26th, 2006 01:54 AM
by Max Go to last post
16 159
copy with format by horst
I have a sheet with various formattings (background and text colored, large and small texts, borders etc.). When I copy and paste it into another sheet I get...
(Multi-page thread 1 2)
September 25th, 2006 09:43 PM
by Gord Dibben Go to last post
16 147
Strange border format. by Rodney
In my sheet, I have a bunch of cells that have dotted borders, I cannot change this under format. When I add a column alongside, that part of the column offers...
(Multi-page thread 1 2)
May 10th, 2005 07:55 AM
by Alan Go to last post
16 365
help with formula by Scudo
In cell I8 I put a 1 or 2 If I put 1 then I want cell M7 tp show £150 If I put 2 then i want cell M7 to show £125 and cell M8 to show £125 As a variation if...
(Multi-page thread 1 2)
July 6th, 2005 10:46 PM
by Don Guillett Go to last post
16 214
Newbie question Pulling data from one sheet to another based on by Tony Canevaro
Okay, Forgive me ahead of time, I really don't know much about Excel. I can work with templates and create simple formulas but alot of what I read here comes...
(Multi-page thread 1 2)
October 25th, 2005 02:10 PM
by Anne Troy Go to last post
16 374
Friday by Winston
Hi How do I calculate the following problem If today does not equal friday then go back to last friday. Can anyone HELP? Regards
(Multi-page thread 1 2)
October 30th, 2005 01:12 PM
by Roger Govier Go to last post
16 251
how to calculate a month without the full date? by Jared
This might be a stupid question. i have a cell (A1), with a month's name: "April" How do i use a formula so cell B1 will show "May" and when i change A1 to...
(Multi-page thread 1 2)
August 29th, 2006 05:19 PM
by Epinn Go to last post
16 247
Averages by Zygy
Is there a formula by which when I have say e.g. four entries in a column on lines 31,32,33 & 34 I can obtain a average of these entries in line 35? If there...
(Multi-page thread 1 2)
June 19th, 2006 10:01 PM
by CLR Go to last post
16 173
A cell appears "######". What's this? by marlen_athens
I write down a type, for example "55,000", which is by default a general type. From the menu Format, Cells, Number , I try to make it as an accounting...
(Multi-page thread 1 2)
September 12th, 2006 05:21 PM
by Dave Peterson Go to last post
16 318
Formula? by omocron
First, let me apologise for my lack of Excel knowlege. I have tried to teach myself to create this formula on my Excel 2002, however....I give. I humbly...
(Multi-page thread 1 2)
February 18th, 2010 04:57 AM
by JLatham Go to last post
16 509
help on a macro by gls858
I recorded macro that imports a text file and adds headers to the columns. When I run the macro it opens a new workbook and inserts the text file. Is is...
(Multi-page thread 1 2)
March 18th, 2005 11:56 PM
by gls858 Go to last post
15 302
Post New Thread


Display Options
Showing threads 61 to 80 of 13737
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 05:09 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.