|
entering cell text from a macro
What is the format for entering text in a cell from a macro?
...
|
2 |
25.08.2006 17:51:12 |
|
|
Inserting a date field
How can I insert a date field into an excel cell. I can do it in Word quite
easily but for some reason Excel presents more a a challange.
...
|
5 |
26.08.2006 13:43:24 |
|
|
Freezing both horizontally and vertically
I can freeze a pane horizonally and also vertically, but not both of
them. I once have seen it on an excell sheet, so it should be possible.
Bart
Excell 2003
...
|
4 |
26.08.2006 13:08:12 |
|
|
Need a method to convert varying french words to english within a cell
I have a spreadsheet with descriptive terms in French. I would like a
search and replace method that can replace multiple the target words
within a cell, when that cell contains additional words and names that
are not to be altered.
How do I do this with substitute and a vlookup from a table of target
words and english equivalents or is there a VBA macro that will do
this?
Thank you f...
|
5 |
26.08.2006 10:00:08 |
|
|
Text file to Google Base
Google requires that files bulk-oploaded to Google Base are formatted as
either .txt or .xml. I have tried the first but so far with no success.
One issue that might tease me is that Google require the file to be in
Latin1 or UTF-8 coding. But how do I achieve this? As far as I can see
this is not controllable when choosing a "Save as" "Text (tab delimited)
(*.txt)" and in XP's regional set...
|
1 |
26.08.2006 09:50:18 |
|
|
Converting characters to text strings
To easily generate texts, I would like to translate text codes into text
strings.
If A translates into "Text A", B into "Text B" etc, then I would like
these texts entered into a column to be shown like this:
A "Text A"
ABC "Text A, Text B, Text C"
BC "Text B, Text C"
The triggy issue for me is that I do not know how many characters there
are in each string to be translated. It c...
|
5 |
26.08.2006 09:27:49 |
|
|
search for value based on conditions of other cells in the same row?
I've been searching to see if I can figure out how to write an Excel
formula that looks at another workbook and searches a table for a
cell's value based on conditions of other cells in the same row.
I'm afraid what I want might be too complicated though.
Here's what I want to do as an example using the table below. Can I
write a formula that searches another workbook table and if the QUEU...
|
7 |
26.08.2006 01:33:07 |
|
|
pivot tables ...
Hi
I'm trying to use the third option in the Pivot table assistant.
I'm using a French version of XL and I'm not sure of the exact wording in
English.
It's in the section entitled Where is the data, and it's the third option
down, and it's something like "Spreadsheet zones with labels".
How does that thing work ?
On Sheet1, I have this
Customer part date Price
ABC 1234...
|
2 |
25.08.2006 18:45:02 |
|
|
Conditional Formatting command translated into VB
I have a worksheet were I need to color a row based on two criteria -
(1) if the value in cell E6 is "No" and cell C6 is blank, I would like
to color the entire row green. I need to do this for an entire
worksheet and I would like to do this in VB. Is this possible?
Any help would be greatly appreciated,
Jaggy
...
|
3 |
25.08.2006 16:41:23 |
|
|
Excel Help Please
I was just wondering whether or not you can change the size of the
columns part way down the page without changing the ones at the top?
Do you have any ideas?
Also, I am hoping to be able to validate the numbers that can be
entered into certain cells from allowing decimals between 2.5 and 10,
to actually specifying each number, which wouldn't allow 2.7 from being
entered. Unfortunately w...
|
3 |
25.08.2006 16:41:01 |
|
|
Filtering with marcos
I am trying towrite a short bit of code to filter using what a user put in
cell.
ie user puts "01" in cell A3
then the data below is filtered to show only results matching 01.
I know i could use an autofilter but coding would be better for the users.
Any body help!
i am sure this is am easy one for someone...
|
3 |
25.08.2006 16:37:01 |
|
|
Date formatting...
Hi,
Wonder if anyone can answer this for me as it's driving me crazy!
I have a spreadsheet I've inherited. The dates appear in cells as Nov 11,
Dec 05, Apr 08 etc. Each date is left aligned as if text. The apostrophe
doesn't appear before them when you click in the cell (i.e. not 'Nov 11).
When I go to format cells it tells me the formatting is general. There are
no macros in th...
|
7 |
25.08.2006 15:21:25 |
|
|
HELP!!! Not sure how to phrase this into a question ..
I'm working on a huge excel spreadsheet that has numbers in columns that must
be added. However, because this spreadsheet is constantly sorted by various
variables, I'm unable to use the Sum() function to add these - and thus have
resorted to looking at the taskbar to find the total and entering it in
manually. So for example I'll have a column of: 4, 5, 9... and rather than
using th...
|
6 |
25.08.2006 14:51:34 |
|
|
Saving XLS File as CSV
I have an xls file with worksheet made up of 3 columns of data. I save
it in Excel 2003 as csv file. When I open the csv file, the columns
are lumped into one column.
When I do the same thing in Excel 2000, 3 column appear and this is the
desired result.
How do I make 3 columns appear in excel 2003?
Thanks in advance
...
|
2 |
25.08.2006 14:44:27 |
|
|
formula in excel
I have some dates in a column like
1/01/2006
10/01/2006
I want just the month and year to be there but I cant just format the cell
because I need to extract to a pivot table and it still picks up the day
I tried to combine the formulas for MONTH and YEAR but no luck
Any ideas
...
|
5 |
25.08.2006 14:38:58 |
|
|
combining worksheets
I receive monthly sales reports in Excel 2002, SP3.
Column A lists customers, B is City, C is State, and so on, thru Column J.
Each transaction is reported in a separate row,so in a given report, the
same customer may have several rows, often identical ones (if they purchase
the same quantity of the same part number at the same price).
I wish to create a "Year-to-Date" workbook or wor...
|
3 |
25.08.2006 14:33:31 |
|
|
How can i transfer date from iSeries in MS-Excel 2003 with SP2?
Hi,
How can we tranfer data from IBM iSeries in MS-Excel 2003 with SP2? But I am
having option of transfering data from iSeries in MS-Excel 2003 with SP1 in
Menu (Data). Could anyone guide me.......
Best Regards,
-Sumit C
...
|
3 |
25.08.2006 14:29:18 |
|
|
find all formulas that a given cell is in
Hi NG members,
I've dredged up some old work and I can't remember where and how a
given cell is used in my spreadsheet formulas. Is there a way to find
all instances where say cell F32 is part of a formula in another cell?
Any help on this would be greatly appreciated.
Mike
...
|
5 |
25.08.2006 11:47:24 |
|
|
VBA speed question.
I want to know that A() and B() which faster...
dim arr(99) as long
dim arrB(9) as long
sub A()
arr(arrB()) = arr(arrB()) + 1
end sub
sub B()
dim X as long
X = arrB()
arr(X) = arr(X) + 1
end sub
...
|
1 |
25.08.2006 11:21:02 |
|
|
Calculation Log
Hi,
I have programmed a valuation model in an Excel Worksheet with VBA. A
full calculation round takes about six minutes.
I am quite sure it can be cut down by 4 minutes at least by more
efficient programming, but I wonder whether it is possible to get a
dump of the caluclations that Excel does (And the time taken)? In that
case I could easily identify the unnecessary calculations.
Ho...
|
3 |
25.08.2006 08:47:01 |
|
|
Since I'm in heare.
I have a SS that I'd like to have the first x rows (in my case 3) printed on
each page. Not a Page Header (as I already have one).
I've already got the Print Area Set, Orientation etc.
How would I do this?
Thanks.
...
|
4 |
24.08.2006 23:53:34 |
|
|
How to convert to absolute value?
Hello!
How do I convert numbers to absolute value?
Thanks
...
|
4 |
24.08.2006 23:14:55 |
|
|
Calculation Question.
Hi all. I have two columns as follows:
Time In: (format is Date/Time)
Time Out: (format is Date/Time)
I have a third column that I simply want to have a calculated total of:
Time Out - Time In
And display as a number value.
When I do so with this example:
Col1 Col2
10:30 AM - 3:45 PM
I get: 0.22 as a result.
Can anyone help (I've tried On Line Help), but just can...
|
3 |
24.08.2006 22:44:15 |
|
|
Linking within a workbook
I have a 45 sheet workbook where I want 44 of them to summarize to Sheet 1.
I use "paste special, link" for row #1 of each sheet to transfer to the
summary. However, when I come in the next week and add a row above #1, the
link adjusts to row #2. Is there a way for the summary to always pick up row
1, even though I add a row?...
|
10 |
24.08.2006 22:35:01 |
|
|
copy custom header from one worksheet to another in same workbook
Could you please let me know simply how to copy and paste the custom header
from one workshheet of a workbook on to one or two additional worksheets of
the same workbook which do not have that header
Thank you very much
Aamir
...
|
4 |
24.08.2006 21:57:00 |