|
|
Problem with Linked Cells by
Dave Peterson
Use a few helper cells in the original workbook and split the text up there.
Then retrieve the values from those helper cells and concatenate them in...
|
|
1 |
491 |
|
|
Portion of sheet with different column widths by
Laurence Lombard
I have a sheet containing two tables of data, but they require different
column spacing.
I could use a formula similar to the one below (assuming the data is...
|
|
2 |
462 |
|
|
Disappearing formulae by
Schol-R-LEA
I recently was asked to help someone with a problem in
which, on certain sheets of a large Excel 2000
spreadsheet, every formulas had been inexplicably...
|
|
1 |
363 |
|
|
Excel Toolbars in Word by
ianripping
I have created my own customised toolbar for word. I want to get rid of
the menu which has: File, View, Tools, etc. I know this can be done in
excel but can it...
|
|
1 |
356 |
|
|
Subtotals - Word? by
ianripping
Thanks this is great.
---
Message posted from http://www.ExcelForum.com/
|
|
0 |
952 |
|
|
|
|
1 |
972 |
|
|
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...
|
|
1 |
1,065 |
|
|
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...
|
|
2 |
1,046 |
|
|
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...
|
|
1 |
1,230 |
|
|
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...
|
|
2 |
1,093 |
|
|
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
|
1 |
1,202 |
|
|
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...
|
|
1 |
980 |
|
|
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...
|
|
2 |
1,055 |
|
|
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
|
1 |
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...
|
|
1 |
965 |
|
|
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...
|
|
4 |
1,128 |
|
|
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
|
0 |
1,408 |
|
|
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
|
|
2 |
1,189 |
|
|
|
|
3 |
1,379 |
|
|
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...
|
|
4 |
1,002 |