目前分類: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
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
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?
- 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
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
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
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
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.
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
first 1024 characters within a cell. It's a wicked bug and sort of
- Sep 29 Fri 2006 20:09
YTD average
- Sep 29 Fri 2006 20:09
copy formulaes w/o filename
- Sep 29 Fri 2006 20:09
Multiple Excel versions.
- 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.
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
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
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
- Sep 29 Fri 2006 20:09
2 questions from a beginner