|
|
|
|
0 |
194 |
|
|
Import data row->column by
Pierluigi
Hi NG,
I didn't find the answer on line so here I am.
I need to import a file like:
|
|
2 |
191 |
|
|
Can't expand named range by
Hi Frank,
I've got an access application which produces a report,
then the report outputs into excel. The excel application
opens automatically when you run...
|
|
2 |
554 |
|
|
exporting files.... by
troubled bar
is there a way whereby i can export into another sheet but the same file of the excel?
|
July 6th, 2004 11:04 AM
by JulieD
|
1 |
150 |
|
|
hours and minutes calculation by
charlie
does anyone know how to make a spread sheet formulae to
calculate hours and minutes, which reports in jours and
minutes?
|
|
1 |
167 |
|
|
Struggling with MS Query... by
Alex
I am learning about MS Query from a book. I am falling at
the first hurdle...
I have an Excel file on my desktop that I want to be able
to query. It contains...
|
|
5 |
1,707 |
|
|
Spreadsheet query by
Michael Dedman
I have devised a list of items in a Microsoft Excel
spreadsheet. Against each item (in a different cell) is an amount which
represtents the items value.
I...
|
July 6th, 2004 11:53 AM
by papou
|
1 |
195 |
|
|
How to open Lotus123 files by
RB
I recently installed Office 2003 and cannot open Lotus
123 files (Millenium Edition). I get the error
message "Cannot open Lotus 123 file". Does anyone...
|
|
1 |
381 |
|
|
Assign Unique Number by
vecia
Does anyone know how to assign a unique number to a record entered into
a spreadsheet?
I have an excel database with a form (made with template wizard...
|
|
4 |
220 |
|
|
print macro to solve limit on page breaks by
Jim Palmer
I have encountered the limit on the number of page breaks that excel
allows, and I'd like to write a macro to work around this.
My data is as follow:
Part...
|
|
8 |
237 |
|
|
Moving data by
gary
Column "A" contains JUNDREDS of unique part-numbers. For
example:
001
002
003
123
234
345
456
|
July 6th, 2004 02:01 PM
by gary
|
6 |
670 |
|
|
How can I use minutes and seconds by
guilbj2
I'm trying to create a spreadsheet (Excel97) to calculate average handle
time for a call center. Each entry will be in minutes and seconds. No
matter what...
|
|
3 |
530 |
|
|
Pivot Table Summary by
arunsharm82
Hi,
I want to be able to summarise some data that I have in a Pivot Table I
created.
The data from the Pivot Tables is contained in many tabs in my
workbook....
|
|
2 |
249 |
|
|
how to use "barcode" in excel 2000?? by
gg
Dear all,
i would like to set up an inventory system for recording
the stuff. previously, i have a long table of data in
excel. i need to do some...
|
|
3 |
382 |
|
|
Selecting a Value from a Range of Values by
breenmck
I want to select a value from a range of 20 Values depending upon the relationship between two cells outside that range.
Lets say the Range of Values I want...
|
|
1 |
351 |
|
|
OptionButton Help by
BryC
I'm trying to change the OptionButton group names to the name of the 'Current Sheet' name automatically. Is there protocol to assigning a name without having...
|
|
5 |
199 |
|
|
Rank column with changing # of rows by
Amy
Is there a formula that will Rank even when rows are added and deleted? Currently I am using =RANK(C8,C8:C43) but when I add or delete rows it throws...
|
|
1 |
151 |
|
|
|
|
6 |
395 |
|
|
Dropdowns by
Janice
I am using Office 2000 on a windows 2000 machine.
Can you tell me how to create a dropdown with choices
for a cell.
I want to put choices such as water,...
|
|
4 |
244 |
|
|
"Comments" Default Font by
tim
I'm going to try this again. This is not a huge problem,
just a point of irritation.
I would like to change the default font when
using "Insert Comment". If...
|
|
1 |
229 |