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
whats the wuickest way to autofill down.....? by sokevin
But say for example i want to auto fill colum B. Column A has data from A2 to A100 B2 = A2*10 B3= A3*10
June 16th, 2004 04:03 AM
by Biff Go to last post
1 162
SUM IF multiple criteria by kennis
I have figured out how to do SUMIF (A1:A8, "9", B1:B8) in order to calculate all the B values corresponding to anything greater than 9 in the A column. I am...
June 16th, 2004 04:26 AM
by Bob Cresto Go to last post
5 208
Copying a column from several similar sheets into one sheet by Lost
I have several worksheets in one workbook and I want to merge/copy one column from each worksheet (the same column) (Like this, just imagine more columns with...
June 16th, 2004 04:57 AM
by Vasant Nanavati Go to last post
1 252
Launching Excel opens multiple workbooks by Herb
This is particularly apparent when you double click an icon to open an existing workbook. Example: I have a workbook named "Original Carrier List.xls" When it...
June 16th, 2004 05:35 AM
by Go to last post
2 362
How can I find the last populated cell in a column by mladew
I need to automatically read the last populated cell in a given column. Example:Cell R4 will pick up & display the last item in column B. There are a list...
June 16th, 2004 05:41 AM
by Biff Go to last post
3 261
Font size changes in Excel 2003 charts when re-opened by Lucie Harris
For certain charts that I create within Excel 2003 (usually bar charts), I use a font size of 8 (eg for data labels, axis labels, and scale). If I close the...
June 16th, 2004 05:52 AM
by Lucie Harris Go to last post
0 532
copy header/footer btwn sheets by DebbieG
Gord, What a great tip! This saved me a great amount of time and no errors. Thanks, Debbie "Gord Dibben" gorddibbATshawDOTca wrote in...
June 16th, 2004 06:01 AM
by DebbieG Go to last post
0 495
Linked workbooks by AndyW
Hi, I have a report template that I have just developed which is populated from 5 other spreadsheets that are emailed to me. I save these to a folder and the...
June 16th, 2004 07:18 AM
by Go to last post
3 251
Excel Crashing by Tony McGee
Hello all Apologies all, I originally sent this to the VB newsgroup by mistake. I am using Windows 2000 with Microsoft Office 2000 Professional. The...
June 16th, 2004 08:11 AM
by m Go to last post
1 147
SUM error - displays a Date instead of SUM calculation by Phoebe H
In all my rows and columns where i've put a SUM calculation for that row or column (ie as a Total), it shows a date (eg "Jan - 2003") instead of the sum of...
June 16th, 2004 08:49 AM
by Phoebe H Go to last post
2 154
Autofilter number of records by Thore
Working with Excel 2000. Hi all, normally when I apply an autofilter it shows in the bottom left corner something like "2 out of 334 records found". However,...
June 16th, 2004 08:58 AM
by Frank Kabel Go to last post
1 288
searching for text strings within a range of cells by My_Posts
Hi I wish to search for Text within a range of cells. The searched text may or may not have an exact match. e.g. - I'm looking for all instances of Harris...
June 16th, 2004 09:55 AM
by Frank Kabel Go to last post
1 438
supressing the message box by Anu
I have an excel macro which has some msgboxs with relevant messages according to some business rules. I want to display these conditionaly only when the...
June 16th, 2004 10:16 AM
by BrianB Go to last post
1 145
Entering date in a cell so that it falls in specific way when sorted? by Jones
I have an entry that I know falls in February 2004 but that we don't have an exact date for as that information has been lost (ahem, _not_ may I say by me ...
June 16th, 2004 10:30 AM
by Jones Go to last post
3 345
format change on paste by glenn mckinlay
I am pasting data from an Access query into an excel template and getting inexplicable cell format changes. I preset the format on all cells in a column to...
June 16th, 2004 10:31 AM
by BrianB Go to last post
1 410
check box for hiding columns by Berend Botje
The script can be made shorter: Private Sub CheckBox1_Click() if checkbox1.value = true then Range("A4:A10").EntireRow.Hidden =...
June 16th, 2004 10:42 AM
by Berend Botje Go to last post
1 219
xls file in Excel97 will not open by WimvV
I have a strange problem in our network. A client can't open a specific xls-file. When he opens an other xls file Excel97 works perfect. When he logs-in on an...
June 16th, 2004 10:45 AM
by BrianB Go to last post
1 320
Counting non blank cells by jack evans
I want to count all the cells in a range that have text in them - I do not want to include any blank cells OR where a formula has returned an empty string....
June 16th, 2004 10:56 AM
by Berend Botje Go to last post
5 463
export into excel from access error by Panos
Hi, I've got an access application which produces a report, then the report outputs into excel. The excel application opens automatically when you run the...
June 16th, 2004 10:57 AM
by BrianB Go to last post
1 491
Copying formulae results by stevie_ray
Hi, I am currently creating a stock control spreadsheet for work. I need to copy a column of formula results to a seperate column (the result only not the...
June 16th, 2004 11:38 AM
by Paul B Go to last post
2 208
Post New Thread


Display Options
Showing threads 221 to 240 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 03:19 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.