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
Inserted row has no formulas by Lee Bowman
When you insert a row to a sheet with formulas (that proceed down a column, e.g. a 'running total' for example), the formula doesn't appear in the inserted...
November 8th, 2003 05:58 PM
by Lee Bowman Go to last post
0 1,283
Extracting Data from a Database, but skipping rows by jppe
I wanted to do it in MSAccess, but it is not installed on every PC because they have no lincences, so I had to do it in Excel. I kinda found a way to do it,...
June 11th, 2004 08:55 PM
by Frank Kabel Go to last post
1 1,437
Printing the top of a table on every sheet. by mjasin
Ok, I must be missing something here but I just can't figure it out. In effect, I have a big table with the first 3 rows being all semi complex column...
June 11th, 2004 09:02 PM
by mjasin Go to last post
2 1,338
Enter "0" is number is negative by S Girl
I have a row that is calculating figures and some of numbers are positve and some are negative. How do I tell it to enter a zero, if the calculation returns a...
June 11th, 2004 09:35 PM
by Frank Kabel Go to last post
2 1,394
Company office moves by Frank Kabel
Hi no solution but try searching Google for dedicated applications for this. This is not a simple question as there're probably several valid solutions and...
June 11th, 2004 10:25 PM
by Frank Kabel Go to last post
4 931
Filter and display rows on another worksheet by JML
Thanks Frank, Is there a way to automate the "Advanced Filter" to work like a function? I want to be able to enter the criteria in a cell and have the filter...
June 11th, 2004 10:33 PM
by Alan Beban Go to last post
3 1,301
Auto Expanding Merged Cells by Frank Kabel
Hi this is one of several merge cell drawbacks. No real workaround available. Try avoiding merged cells! -- Regards Frank Kabel Frankfurt, Germany
June 11th, 2004 10:38 PM
by Gord Dibben Go to last post
2 1,124
Unreadable Comment Boxes by Gordon
Thank you, changing the resolution to 32 worked great. -- Gordon "David McRitchie" wrote: Hi Gordon,
June 11th, 2004 10:52 PM
by Gordon Go to last post
0 1,328
Copying Interest formula to 214 cells. by BradP
I am doing a project for work and need to copy a interest formula to the next 214 months (Ipmt function). Ii am receiving an error when I try to fill the...
June 11th, 2004 11:14 PM
by Norman Harker Go to last post
4 1,069
Timesheet Formula Problem by Bridie
:confused: I have a number of timesheets for various departments up and running correctly. However, I am trying to change one to calculate hours over a 24 hour...
June 11th, 2004 11:41 PM
by Frank Kabel Go to last post
1 895
Dashed Line Divider by Jay
Ethan wrote: Hi, I have a Workbook that is displaying one dashed line column divider and one dashed line row divider on all worksheets. What do these...
June 12th, 2004 12:16 AM
by Go to last post
1 1,006
excel sheet creation?? by tico31pl
Frank, Thanks for replying... we use a report generating tool (access)that gets talks to the database - but the custom reports don't have all...
June 12th, 2004 12:16 AM
by tico31pl Go to last post
2 985
Lost Links by cincode5
Hello everyone, I experienced a problem that caused me to have to rename a copied version of a spreadsheet to its original name. Upon doing so, I seem to...
June 12th, 2004 01:02 AM
by Dave Peterson Go to last post
1 913
re; Worksheet_SelectionChange goes cold by Rob
Hi Bob, I thought someone might suggest this but I feel the whole workbook will need to be evaluated as it's turned into a rather complicated nightmare. The...
June 12th, 2004 01:43 AM
by Rob Go to last post
1 1,118
Macro Help - Jumping Sheets by NICK
Hi All I have a workbook which contains 200 sheets. What I need to do is to insert a "cover" sheet and then create a macro pick up 5 cells from each...
June 12th, 2004 05:52 AM
by Frank Kabel Go to last post
2 1,018
repeating rows at the bottom of every page by Art
With Excel 97, is there a way to have rows repeat at the "bottom" of every page? This would be more information than would typically be in a footer. I know in...
June 12th, 2004 05:53 AM
by Frank Kabel Go to last post
1 1,161
Complicated by Continental Translations
In a sheet named "Confirmed" I have a spreadsheet which contains the following:- Column F (a list of languages) Column G (a list of languages) Column H (a fee...
June 12th, 2004 05:59 AM
by Frank Kabel Go to last post
2 978
Macro Help - Jumping Sheets! by NICK
Hi All I have a workbook which contains 200 sheets. What I need to do is to insert a "cover" sheet and then create a macro to pick up the same five cells...
June 12th, 2004 06:15 AM
by Frank Kabel Go to last post
1 1,007
Changing the order of a name in various cells by happydude
I have a column with over 400 rows of names that most contain names reading last name first then a comma then a persons first name. Such as Sullivan, Mike. ...
June 12th, 2004 06:47 AM
by Arvi Laanemets Go to last post
1 911
Subtotals - Word? by ianripping
Thanks this is great. --- Message posted from http://www.ExcelForum.com/
June 12th, 2004 09:40 AM
by ianripping Go to last post
0 888
Post New Thread


Display Options
Showing threads 1 to 20 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:59 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.