Hi,
I found this source code which creates a macro to store data from an excel
目前分類:title (3013)
- Dec 18 Mon 2006 20:34
Excel to Access
- Dec 18 Mon 2006 20:34
I LOVE THIS JOB !!!
I LOVE THIS JOB !!!
- Dec 18 Mon 2006 20:34
Generate Report
I have one sheet called master list which is basically a customer list of:
- Dec 18 Mon 2006 20:34
IS THERE A AUTO TEMPLATE FOR INVOICES
Is there a template available that would fill in invoice numbers autmatically
when opened with a new number?
- Dec 18 Mon 2006 20:34
How can I determine cell color?
I am color blind (to same extent). Sometimes I need to determine what is cell
(or font) color in an existing worksheet. I would like to be able to
- Dec 18 Mon 2006 20:34
Save As from chart sheet
I am using Excel 2K/Windows 2K. I have imported a CSV file and created charts
on chart sheets. The file is in the CSV format and a chart sheet is active,
- Dec 18 Mon 2006 20:34
value function
May I know what is wrong over here?
- Dec 18 Mon 2006 20:34
how do i make a sound in XL whenever certain numbers are reach?
- Dec 18 Mon 2006 20:34
Convert serial numbers to dates
I exported data from an application and the date column is formatted as
serial numbers, i.e.: 37935.5140046296
- Dec 18 Mon 2006 20:34
% calculations
I am looking to compare actuals to budgeted amounts.
The actuals are real $. The amount budgeted was $0.00. I need the
- Dec 18 Mon 2006 20:34
combining multiple sheets
How can I create a consolidated a list of data from multiple worksheets, that
eliminates duplicate entries and gives reference back to the source
- Dec 18 Mon 2006 20:34
continuing a series in a different location
is it possible to continue an ascending series from one section of a
worksheet to another part. ie. the columns aren't together. numbers like
- Dec 18 Mon 2006 20:34
Autosave
Is there a way to get an excel macro/spreadsheet to automatically save
itself into the XLstart folder of a user who opens it in an email? Or
- Dec 18 Mon 2006 20:34
Default # of worksheets
I am trying to set the default # of worksheets for a workbook
- Dec 18 Mon 2006 20:34
Launching Excel by clicking Excel file
I recently lost the ability to launch WinXP 2003 Excel successfully by
clicking on a file. Actually, Excel opens but no file appears - grey
- Dec 18 Mon 2006 20:34
Chart labels disappear
After adding 34 data series to an x-y chart I save the file. After closing
and opening the file most data labels no longer appeared. If I went to each
- Dec 18 Mon 2006 20:34
zero values
How can I show leading zeroes in zip codes in an Excel spreadsheet? I have
clicked the Tools-Options-View-Show Zeroes but the leading zeroes do not
- Dec 18 Mon 2006 20:34
compile error message on a new excel workbook opening
- Dec 18 Mon 2006 20:34
Car loan payment calculations
- Dec 18 Mon 2006 20:34
Text Colour In Linked Cell
Is there any way to carry the formatting of a cell to a linked cell,
particularly the font colour so that if the font colour is changed in