Hi every body
I have this
目前分類:title (3013)
- Sep 29 Fri 2006 20:09
sumproduct
- Sep 29 Fri 2006 20:09
Can I match the beginning of text in an Excel cell?
I am trying to match the beginning of a text string in a cell, so that I can
replace a character only at the beginning and not anywhere else. I have done
- Sep 29 Fri 2006 20:09
emailing a worksheet from a workbook
- Sep 29 Fri 2006 20:09
How can i update the same excel file from three system?
I got three system- one at home, another at my friend home and the third one
with another friend. We got to update the same Excel file everyday. Is there
- Sep 29 Fri 2006 20:09
Where's the plain old database functionality?
Hi all,
Probably an outdated question but I'm keen on doing some simple
- Sep 29 Fri 2006 20:09
reverse vlookup
vlookup is great for pulling info out of my excell db into a nice report. Now
I'd like to let the user type updated info into a neighboring report cell and
- Sep 29 Fri 2006 20:09
importing data
I open a spreadsheet from a template every week and save the file with a
sequential number for the week. When I open the new file #2, I require some
- Sep 29 Fri 2006 20:09
Blank Cells
- Sep 29 Fri 2006 20:09
2 strange items in Excel (reclac and Add-in)
2 things keep happening to my excel.
1 - recalculation keeps getting set to manual - no matter how many times I
- Sep 29 Fri 2006 20:09
set the number of characters in a cell
How can I format a cell so that ONLY ten numbers can be entered; no less than
ten, and no more than ten can be entered. Also, some of these ten digit
- Sep 29 Fri 2006 20:09
Cell Reference in Function
I have give names to various lists - lets say it is
quot;Locationquot; =Sheet1!$A$2:$A$108.
- Sep 29 Fri 2006 20:09
Anyone notice excel search within cell limited to first 1024 chars
I started noticing that the search within Excel only searches within the
first 1024 characters within a cell. It's a wicked bug and sort of
- Sep 29 Fri 2006 20:09
YTD average
A column of monthly totals
Jan 400
- Sep 29 Fri 2006 20:09
copy formulaes w/o filename
- Sep 29 Fri 2006 20:09
Multiple Excel versions.
Hi,
- Sep 29 Fri 2006 20:09
changing cell values with text and currency
Hi, I need to add some cells together but they have both text and currency.
example quot;$30.00 USDquot; is there anyway to add them with both text and currency.
- Sep 29 Fri 2006 20:09
ADO Transfer from Excel to Access
Ok I've figured out some code to transfer data to Access but I can't figure
out how to make this loop for different records. As you can see in my code it
- Sep 29 Fri 2006 20:09
Typing in a text box control
When I create a text box control on a spreadsheet (Excel 2000), the only way
to type text in it is to right click and select Edit. Is there any way to
- Sep 29 Fri 2006 20:09
Two Macros under One command button
Hi
Is it possible to link two macros under one Command Buttion, if Yes how?.
- Sep 29 Fri 2006 20:09
2 questions from a beginner