目前分類:title (3013)
- Oct 22 Sun 2006 20:10
Search and replace chunks of html code
- Oct 22 Sun 2006 20:10
custom menu
a custom menu (operated with some macro) always appears when I open the
workbook although I deleted it (or changed its name) before already. How can
- Oct 22 Sun 2006 20:10
emailing excel files
sent an order by email and the attachment(excel file) arrived diferent to
that sent. any clues?
- Oct 22 Sun 2006 20:10
Create my own formula?
I am using the nested functions below
- Oct 22 Sun 2006 20:10
Auto Calendars in VBA
Need to create a monthly schedule for work.To enter the dates (Numbers) into
every other cell this is what I have so far
- Oct 22 Sun 2006 20:10
When I select from drop down menu I would like the next column to populate a specific cost.
I am creating a form. I have a drop down menu for quot;equipmentquot; and if I
select a specific piece of equipment from the drop down menu I would
- Oct 22 Sun 2006 20:10
Negative figures to appear in brackets
In excel, how can I get negative figures to appear in brackets
ie (7,500)
- Oct 22 Sun 2006 20:10
Drop down box in a cell
- Oct 22 Sun 2006 20:10
titling columns
is there a way to give titles to the upper portion of the spreadsheets (that
are listed A, B, C, etc.)? also, the same for the left side (1, 2, 3, etc.)?
- Oct 22 Sun 2006 20:10
Feature to flag unpopulated required fields in Excel?
Is there a feature in excel that will either:
- Oct 22 Sun 2006 20:10
partial lookup/match
i have 2 worksheets. the 1st contains a table of companies with their
industry codes (4digits) and the 2nd sheet contains tables with industry
- Oct 22 Sun 2006 20:10
Perpetual calander
Does anybody know how I could convert the Employee Absence Schedule in the
templates section into a perpetual calendar with the same information? This
- Oct 22 Sun 2006 20:10
This has kept me up typing for hours...
I have the formula:
- Oct 22 Sun 2006 20:10
NON-TEXT VALUES IN CELLS
I'm creating a timesheet for technicians in my service department. I have a
team-based system where technicians split the total hours their team does by
- Oct 22 Sun 2006 20:10
Determining error associated with polynomial trend lines.
I have a plot that requires a polynomial trend line to the fourth power that
has error associated with the y-axis values only. From this point on, I'm
- Oct 22 Sun 2006 20:10
Subtracting Hours
Can anyone provide a formula to take a time value in one column (A1) and
subtract 2 hours to show central time (B1) and subtract 3 hours to show
- Oct 22 Sun 2006 20:10
Not Displaying Zero Values
Hello, I have a pie chart being created based on the value of a series of
rows. Since some of the cells within these rows are zero, I would like the
- Oct 22 Sun 2006 20:10
Shortcut in copying a formula that links 2 workbooks
I have 2 workbooks. The first workbook lists the quantity of parts produced
in each of 3 shifts per day (3 cells per day). The second workbook has one
- Oct 22 Sun 2006 20:10
Retrieve data from all of the worksheet within the file
- Oct 22 Sun 2006 20:10
CSV export help
I have a General format column. One of the cells is 359 characters in length. When I export the column using..