Excel Problem
It's for a Nested Function.
Enter this function in cell B1 and then use the fill in handle to copy
the function down through cell B7. Enter the following data in the
cells in the range A1:A7 and then write down the results in cells B1
through B7 for each set.
Set 1: A1=IL; A2=IN; A3=IN; A4=OH; A5=IN; A6=OH; A7=IN
Set 2: A1=WI; A2=KY; A3=IN; A4=IL; A5=IN; A6=IN; A7=OH
not sure how nested functions work, if someone could tell me how to do
this one i should be ok to figure it out from here. thanks
--
Angell
------------------------------------------------------------------------
Angell's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36782
View this thread: http://www.excelforum.com/showthread.php?threadid=564952 Tag: Adding Streaming video to your web-page is as Tag: 100015
Counting Cells with odd and/or even values
Lets say I have range A1:A5 containing values 1,2,3,4,5 respectively. I
would like to count how many of these cells are odd and place that value
in A6. The same for even numbers as well (in A7).
Any help would be appreciated.
--
yungexec
------------------------------------------------------------------------
yungexec's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=22593
View this thread: http://www.excelforum.com/showthread.php?threadid=564950 Tag: Adding Streaming video to your web-page is as Tag: 100014
Ardus Petus: Ran in to a problem with the formula Please Help
=VLOOKUP(TEXT(F5,0),Jobs!A:B,2,0)
The formula you gave me above worked great until I added a few more
rows of data to the Jobs worksheet.
Any entry that was added past the original entrys will not lookup.
Did I loose the formula referance?
should I rename the worksheet?
What do I need to do to get this to work again?
It works down to row 50 but after that nothing is returned I check to
make sure all cells were formated the same and I also tried sorting the
list ascending didn't help.
I will need it to search at least 100 rows
Thanks
Charles
--
mrdata
------------------------------------------------------------------------
mrdata's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17899
View this thread: http://www.excelforum.com/showthread.php?threadid=564937 Tag: Adding Streaming video to your web-page is as Tag: 100011
Filtering one column based on multiple arguements
I want to filter my spread sheet with a macro based on the information
in one column, the catch is that I'd like to hide anything that is one
of 5 different entries. From my initial testing I concluded that Excel
might not support more than 2 arguements per column in a filter. This
is a problem as I have thousands of entries with about 15 different
codes, but 5 of the codes are different ways of saying that something
didn't happen (each for a different reason which is important,
otherwise I could just use find/replace to code them all the same) I
want to view only the rows containing entries that did happen using a
filter, but the only way I have to do this is to write a macro that
checks each entry in the column to determine if it was one of these
codes and then hides them, stepping through a loop as it goes.
Here is what I've written for that piece:
Sub Operational()
Dim ColOTP As Integer
ColOTP = 7
For i = 2 To Worksheets("Data").UsedRange.Rows.Count
With Worksheets("Data").Cells(i, ColOTP)
If .Value = "Cancelled" Or _
.Value = "Weather" Or _
.Value = "Mechanical" Or _
.Value = "None" Or _
.Value = "Not Initialized" Then
Worksheets("Data").Rows(i).EntireRow.Hidden = True
End If
End With
Next i
End Sub
While this is functional as itself, it is not functional if I apply
this and then try to filter based on a quality of something in a
different column, doing so unhides all the entries that were hidden via
the above macro that meet the quality of the filter. Tag: Adding Streaming video to your web-page is as Tag: 100010
How to change the color of default letters in the labels?
My friend asked me how to change the color of the default letters, such
as the color of the labels (sheet 1, sheet 2) at the bottom of
spreadsheet? The default is black. He wants to change it to any other
color. Thanks. Tag: Adding Streaming video to your web-page is as Tag: 100005
pdf file conversion probs in 2007beta
When i convert an excel page into a pdf i get corrupted scripts etc ie italic
changes completely. Does anyone else have the same problem? Is it because it
is a beta version? Is there a cure? When using excel 2003 i have no problems.
Ta Tag: Adding Streaming video to your web-page is as Tag: 100002
Excel Not Seeing User-Defined Functions
Does anyone know why Excel sometimes does not see
user-defined functions, and instead fills the cell with
"#NAME?"?
(I have run across this problem before, but I do not
remember what smack-in-the-head Excel requires.) Tag: Adding Streaming video to your web-page is as Tag: 100000
excel file will not open
Someone gave my a floppy disk with an excel file on it and it will not
open.
He told me that the computer that he was working on it froze-up and he
rebooted the pc and known it won't open. Try repaired it through excel
but had known success with it.
Does anyone known of any repair program that will fix it
thanks
Bri Tag: Adding Streaming video to your web-page is as Tag: 99997
columns and tabs in excel
can I get the first two columns to be the same regardless of which tabs
I click on? E.g. the first two tabs are for what will remain constant.
Clicking on the tabs at the bottom will change what columns appear to
the right of the first two columns. Tx Tag: Adding Streaming video to your web-page is as Tag: 99995
find matches in a column
I am using excel to add users to AD, I need to have a function that will
look through my username column and find matches and highlight them, can
anyone advise?
Regards
Mark Tag: Adding Streaming video to your web-page is as Tag: 99990
Basic Excel help for beinnger
Is there anyway to automatically update a spreadsheet when my client
updates a different spreadsheet (within the same workbook) and on the
same network.
I need to have a COUNT function to add up the total number of comments.
But these comments are long strings and the count function doesnt work.
Anyone have any suggestions. I figure I could use a macro but I have no
idea how to use them. So any guidance would be greatly appreciated.
Thanks.
Paul
--
pscoln1
------------------------------------------------------------------------
pscoln1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36702
View this thread: http://www.excelforum.com/showthread.php?threadid=564812 Tag: Adding Streaming video to your web-page is as Tag: 99985
Create a pivot from CSV or access
I have a CSV file and I wish to create a Pivot out of this.I am
converting it in to access and then planning to create a pivot from
access.I am converting it in to acces so that no of rows do not do not
become a limitation in excel .
Some body with any idea or VBA code to automate this? Tag: Adding Streaming video to your web-page is as Tag: 99982
Numbers Organized As Data
HI,
When I download financial numbers from a database to an excel
spreadsheet, the numbers are automatically organized like if they are
data
ex. 1.28000000 into 128.000.000.
I would like to have them as numbers no data.
What do I have to do in order the permanently fix the problem?
Thank you.
air
--
campione
------------------------------------------------------------------------
campione's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36758
View this thread: http://www.excelforum.com/showthread.php?threadid=564773 Tag: Adding Streaming video to your web-page is as Tag: 99975
Removing rows based on prescence in another sheet
Hello,
I have a large sheet using columns A-E and I need to remove certain
rows from it. I need to remove any row where cells A and D of that row
occur together in columns A and D of another sheet in the same row as
each other.
I hope that makes sense and someone can suggest a way that I can do
this...
--
ianwitt
------------------------------------------------------------------------
ianwitt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36697
View this thread: http://www.excelforum.com/showthread.php?threadid=564755 Tag: Adding Streaming video to your web-page is as Tag: 99971
Inserting a Drop down Menu
Very simple questions so I'll keep it short.
How do I insert a drop down menu into Excel?
Thanks for any help.
--
matt_the_brum
------------------------------------------------------------------------
matt_the_brum's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5751
View this thread: http://www.excelforum.com/showthread.php?threadid=564747 Tag: Adding Streaming video to your web-page is as Tag: 99969
formatting
i am creating a spreadsheet with a lot of cell references for billing of
insurance purposes. Basically, what i want to know is this:
I have formatted cells to be referenced to another worksheet in the
workbook, and right now, if there is no value for the date, it shows
1/0/1900, but if there is a date, then it shows the correct date. I
want to know if there is a way to make an IF statement for formatting
so that if there is a date it shows it, and if not, it shows a dash or
0 or nothing at all. please let me know:cool:
--
pioneermusic55
------------------------------------------------------------------------
pioneermusic55's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36756
View this thread: http://www.excelforum.com/showthread.php?threadid=564728 Tag: Adding Streaming video to your web-page is as Tag: 99962
how to auto copy excel cells to outlook email
hi,
great site. not sure if this is the right place to post this:
here's what i'm trying to do:
i have to send daily emails to a list of people.
the info on the email is in an excel doc (eg cells A1 to e5)
i manually copy-paste the cells on my daily emails. (not as attachment
just ctrl C crtl V)
is there a way to automate this process?
i.e. a form to get the info from the excel sheet and display it on th
email template?
hope someone can help,
thanks
--
asdfasd
-----------------------------------------------------------------------
asdfasdf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3675
View this thread: http://www.excelforum.com/showthread.php?threadid=56470 Tag: Adding Streaming video to your web-page is as Tag: 99959
Excel can't find file
I had an Excel file on my desktop, but when I moved it (cut and paste,
copy and paste, or move with mouse) I get the following error (No Code)
when I try to open the file.
-'C:\file location.xls' could not be found. Please check the spelling
of the
file name and verify that the file location is correct.
If you are trying to open the file from the list of most recently used
files on the File menu, make sure that the file has not been renamed,
moved, or deleted.-
I have tried the following with no success.
1) Sometimes one of these works:
Tools|Options|General|Ignore other applications (uncheck it)
2) Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver
The /unregserver & /regserver stuff resets the windows registry to
excel's
factory defaults.
3) The XLStart by default is on your PC. If you don?t show any path
in the At Startup box (or in Alternate Startup Folder in prior
versions), then somehow you?ve placed files in your XLStart folder that
don?t belong there. Do a search on your hard drive, and find XLStart,
and move the files back out of there.
4)The At Startup folder line is empty in my Options/General section
I've also made sure the Ignore other applications box is
UNCHECKED. (It was to begin.)
I've also done a Repair/Reinstall with my Office 2003 Disk.
Any Help??!!??
--
deaconswin
------------------------------------------------------------------------
deaconswin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36750
View this thread: http://www.excelforum.com/showthread.php?threadid=564696 Tag: Adding Streaming video to your web-page is as Tag: 99958
Conditional formating
Need help figuring out a formula please.
If "date entered" in cell exceedes todays date by 4 days, then format
the cell background "Red".
Thanks so much for any help you can give.
--
Unplugged
------------------------------------------------------------------------
Unplugged's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36751
View this thread: http://www.excelforum.com/showthread.php?threadid=564685 Tag: Adding Streaming video to your web-page is as Tag: 99951
Workbook linking
Is there any way of linking individual worksheets in a workbook to
separate workbooks so that they will automatically update? Just cutting
and pasting messes up the formatting and loses the charts.
Thanks
--
sanders
------------------------------------------------------------------------
sanders's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36745
View this thread: http://www.excelforum.com/showthread.php?threadid=564678 Tag: Adding Streaming video to your web-page is as Tag: 99949
writing values in to excel
Hi,
I have got a script which gets all the groups associated with a
particular user.
im able to refer the user name from the excel.
How can i write groups names (multiple values) in to excel.
*************code************************
Set Wshshell = wscript.createobject("Wscript.Shell")
Set WshNetwork = WScript.CreateObject("WScript.Network")
Set oGroupDict = CreateObject("Scripting.Dictionary")
'set fso = createobject("scripting.filesystemobject")
Set excelapp = CreateObject ("excel.application")
Set openexcel =excelapp.workbooks.open ("mypath\groups1.xls")
k=2
While openexcel.worksheets(1).range("A"&k).value <> ""
strusername= openexcel.Worksheets(1).Range("A"&k)
wscript.echo strusername
PopulateGroups(strUserName)
k=k+1
Wend
'---------------Function to populate the user's domain membership
-------------'
' The group name is passed as an arguement '
'------------------------------------------------------------------------------'
Function PopulateGroups(userName)
Dim sAdsPath, oUser, oGroup
If IsEmpty(DomainGroupsForUser) Then
Set DomainGroupsForUser = CreateObject("Scripting.Dictionary")
DomainGroupsForUser.CompareMode = vbTextCompare
sAdsPath = WshNetwork.UserDomain & "/" & userName
Set oUser = GetObject("WinNT://" & sAdsPath & ",user")
For Each oGroup In oUser.Groups
DomainGroupsForUser.Add oGroup.Name, "-"
wscript.echo oGroup.Name
Next
Set oUser = Nothing
End If
End Function
'---------------Function to check if the user is a member of the
group---------'
' The group name is passed as an arguement '
'------------------------------------------------------------------------------'
Function IsMember(sGroup)
isMember = CBool(DomainGroupsForUser.Exists(sGroup))
End Function Tag: Adding Streaming video to your web-page is as Tag: 99944
Replacing a comma ( ,) with a new row
Hellol everyone, I have being working ont this spread sheet for a long
time because my work requires that I incert a number in a single cell
in a new row. But some of the cells containt hundreds of numbers
separated with a comma and this makes my life hell.
I would like to know if there is any way I can automatically replace
the comma with a new row.
If anybody can help me out please email me at spiderweb14@gmail.com.
Thank you very much.
--
spiderweb
------------------------------------------------------------------------
spiderweb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36746
View this thread: http://www.excelforum.com/showthread.php?threadid=564657 Tag: Adding Streaming video to your web-page is as Tag: 99943
MS Query. Can you use parameters with LIKE and % wildcards?
Please help!
I have (what I thought was) a very simple single table query, but I am
struggling with it in MS Query. I can do it using stored procedures
and ADO, but that would probably be overkill for such a small query and
I will only resort to that if somebody confirms that is impossible to
achieve using MS Query
My problem is that the parameter that the users will enter (location
code) is a substring of item code in the table. There can be more than
1 item code with the same location code embedded in it and this is what
the report seeks to identify. However the location code substring will
have varying start points and lengths so I don't think I can use
substring in this context.
I can get results for a single location code by using LIKE
eg dxobv1 LIKE '%GBWA10%',
but am struggling with the syntax of replacing GBWA10 with an input
parameter.
Something like dxobv1 LIKE '%[Please input location code]%'
Can anybody confirm whether or not this is possible to do using
MSQuery, and if so, could they confirm the syntax for me to use.
including the parameter prompt.
Many thanks in advance! Tag: Adding Streaming video to your web-page is as Tag: 99941
Message Box On One Sheet Only
I have a large spreadsheet with multiple worksheets in it.
When one specific worksheet is selected (it does the calculations used on
the other pages) I would like a pop-up text box to appear warning the user
not to print it.
Is there a relatively easy way to do this given that I can't write VB
(though I can follow it in the VB editor)? I have been able to create a
pop-up that appears on every page by putting an Auto_Open Msgbox in the
ThisWorkbook module, but can't figure out how to get it to work on only one
worksheet - is this a syntax probem or can't it be done?.
Another option would be to completely hide the tab, but when I do this, the
macros that refer to the page from other worksheets fail to function
correctly. Is there a way around this?
Any help/suggestions/sample code gratefully received. Tag: Adding Streaming video to your web-page is as Tag: 99940
Transposing problem - please help if you can
Hello, I have been puzzling over this for some time now and am sure a
seasoned excel person will have a solution.
-----------------------------------------------------------------
First let me explain the spreadsheet.
-----------------------------------------------------------------
It is a list of customers, and purchases that each customer has made.
every purchase has a unique row.
for example: -
CUSTOMER ITEM
customer a someitem
customer a someitem2
customer a someitem3
customer b someitem4
-------------------------------------------
What I want to end up with
-------------------------------------------
customer a someitem someitem2 someitem3
customer b someitem4
etc ...
the problem is that the number of purchases varies between customers,
some have fifteen or so whilst some have three so i'm having trouble
figuring out a way of automating it.
I've simplified the example but in reality there are about 10 columns
which belong to each purchase, and these are what I need to append to
the end of the customer row.
I hope someone can help because there are over 4 thousand rows - so to
do this manually is going to take me a week of sundays
Thanks,
Gary. Tag: Adding Streaming video to your web-page is as Tag: 99937
Help on Lookup
I have a spreadsheet that contains two worksheets (a & b).
In worksheet b (which is hidden) all of the data is kept for a test
that is run each day. (user form is used for data entry). from this
data, a total is calculated (nothing serious, just =sum function).
The data is entered in columns and the total is calculated at the
bottom of every other column (i.e every day data is entered into two
columns, C&D, with the total being calculated at the foot of column D
and so on).
On Worksheet (a) I want to create a summary of the days data -
including the total result. Can I make a cell show the latest total
without having to manually tell the cell in WS (a) where to find the
data every day?
i.e. can I make a cell lookpup data in the last unavailable cell across
a row? Tag: Adding Streaming video to your web-page is as Tag: 99933
Worksheets to workbook
Hi
I have a excel workbook containing 20 different worksheets. Is there a
quick way to make each worksheet a separate workbook?
--
Patsy Rogge Tag: Adding Streaming video to your web-page is as Tag: 99932
absolute formula in Excel
Hello all
we need to use absolute formula in most cells, the way that we know is that
use the normal formula and then add $ sign before cell ref.
It is a nightmare to correct all cells manually. is there any way to make it
fix?
Thanks Tag: Adding Streaming video to your web-page is as Tag: 99920
Converting Dates between Gregorian to Afghani Calendar
Hello,
I need your help in creating a calendar that converts the dates fro
Gregorian Calendar to Afghani Calendar. Afghani Calendar is sola
calendar which mean it has 365 days. It is not Lunar Calendar. So yea
2006 = 1385 afghani calendar. So this mean that G= A + 621 and A= G
621.
The problem I have is converting the months and days. The new year fo
Afghani Calendar is march 20 or 21 (depends on which day is the firs
day of spring). So the new year 1/1/2006 is 3/20/1385.
I would like to create a excel file that does this conversion and a
well show the month and days graphically. :rolleyes
--
kjaa
-----------------------------------------------------------------------
kjaan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3673
View this thread: http://www.excelforum.com/showthread.php?threadid=56457 Tag: Adding Streaming video to your web-page is as Tag: 99918
About procedures in microsoft support
Hi.
Is it possible someway to save (or print) all the answers of a newsgroup of
Microsoft support (for example EXCEL team), without going question by
question?
Thank you. Tag: Adding Streaming video to your web-page is as Tag: 99914
Averaging compound numbers, e.g. Blood Pressur
How does one average blood pressure readings? Please give an actual
example, such as 152/65. Tag: Adding Streaming video to your web-page is as Tag: 99894
Sumproduct
I heard that sumproduct is very useful. Can I know the functions of it.
Thank you Tag: Adding Streaming video to your web-page is as Tag: 99893
Show parentheses in Accounting Format
I have Excel 2002 (XP) and want to display negative numbers in parentheses in
ACCOUNTING FORMAT instead of with a minus sign. I know this is possible as a
standard feature (I have done it before on a previous machine) and I think
there was a KB patch for this flaw. Anyone know of where I might find the
fix? Tag: Adding Streaming video to your web-page is as Tag: 99879
Automatically create hyperlinks
My workbook contains about 50 worksheets. I want to allow the user to
select which worksheet they want to look at from the first worksheet in
the file. However, I really don't want to create 50 seperate hyperlinks
by hand! Is there any way to automate this process?
Furthermore, can I create a drop down menu with the worksheet names
which are hyperlinks?
Thank you.
--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36709
View this thread: http://www.excelforum.com/showthread.php?threadid=564431 Tag: Adding Streaming video to your web-page is as Tag: 99870
How to sort with fractional
Hi, I am just wonder how to sort the colum with all the fraction on top
or bottom ...ie..
54.375
377
21.75
87
to be like this..
377
87
21.75
54.375
--
TaGY2K
------------------------------------------------------------------------
TaGY2K's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1861
View this thread: http://www.excelforum.com/showthread.php?threadid=564424 Tag: Adding Streaming video to your web-page is as Tag: 99868
Sort Order is Mixed-Up
I use an Excel 2003 worksheet for storing the results of my medical lab
results.
One of the columns is labled "Component" and contains the names of the
tests.
I have formatted the cells in this column as text.
I also have a column for the dates of the tests.
When I try to sort by Component, the rows don't end up in alphabetical
order.
Rows 2-13 are sorted alphabetically from CORTISOL to SODIUM
And then it starts over and rows 14-70 are sorted alphabetically
ADDITIONAL FINDINGS to VITD-25 OH
I'd be grateful for some ideas on how to troubleshoot and solve this
problem. Tag: Adding Streaming video to your web-page is as Tag: 99858
Not dropping down after enter: what did she do??
My daughter was poking around in Excel, "working" through John
Walkenbach's "Excel Bible", including all the little fun stuff (like
rewriting my menu names backwards!). Now when I type in a cell and
press "Enter", it doesn't drop down to the next cell. She doesn't
remember all the things she played with, and I can't find the setting
that was changed. Can someone help me here?
Ed Tag: Adding Streaming video to your web-page is as Tag: 99855
Hyperlink to a chart worksheet
I have a "table of contents" worksheet. It lists a number of other
worksheets in the spreadsheet and provides hyperlinks to those sheets.
However, I can't find a way to provide a hyperlink to a chart worksheet. The
chart worksheet is not listed in the bookmarks, and there doesn't seem to be
a way to name a range in a chart that I can point the hyperlink to.
Can anyone suggest a solution please? Tag: Adding Streaming video to your web-page is as Tag: 99853
Placing filtered rows into spreadsheet
Question: Once you've applied a filter to a spreadsheet, is there an easy way
to save the filtered results into another workbook (so that the hidden rows
are deleted in the new sheet)? I basically need to create a new file, and I
don't want to jump through the hoops of linking to Access if I don't need to.
Thanks,
Eric Tag: Adding Streaming video to your web-page is as Tag: 99852
Question about Paste Special
Hi, I have a problem sometimes with the paste special options when goin
from one excel workbook to another. For example, sometimes when I cop
data from one workbook and then paste special into another, I get th
options that include: All, formulas, values, formats, has the option t
transpose the data and paste link among other options. And the
sometimes I try and paste data to another workbook and I end up th
paste special options: Bitmap Image Object, picture, bitmap, and I als
lose the ability to paste link. Well you can do it, but it puts it i
as an object.
What I want is the first paste special option I described. Is there
setting to change? The data is nothing special I'm usually copyin
over, just normal excel entries.
Thanks in advance
+-------------------------------------------------------------------
|Filename: Paste_2a.gif
|Download: http://www.excelforum.com/attachment.php?postid=5084
+-------------------------------------------------------------------
--
Mike100
-----------------------------------------------------------------------
Mike1000's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3670
View this thread: http://www.excelforum.com/showthread.php?threadid=56437 Tag: Adding Streaming video to your web-page is as Tag: 99851
Workbook import
In Workbook 1, I am running a macro that uses this code to select a
file and copy A:Z on the main worksheet:
Dim myBk As Workbook
Set myBk = Workbooks.Open(Application.GetOpenFilename _
(, , "Select the file"))
Sheets("Main").Select
Range("A:Z").Copy
Next, I want it to switch back to Workbook 1, insert a new worksheet,
paste the data, and name the worksheet "rawdata".
Any suggestions for me? I basically have a workbook I'm starting from,
I want to open a dialog box to allow the user to select another excel
file (filenames can be different so I want user to select), and then
import a specific worksheet from that workbook into my starting
workbook.
Any help would be greatly appreciated, Thanks!
Dan Tag: Adding Streaming video to your web-page is as Tag: 99843
Is thre a way to use a multi-area selection in SLOPE() formula
I want to use a multi-range selection as arguments for known_x and known_y
in the SLOPE() function. If i am on, say, the known_y argument, and select
a range, and then press CTL and select another non-contiguous range, Excel
simply produced two ranges separated by commas, and this means that the
second selection is treated by Excel as the second argument ot the slope
function, i.e. the known_x argument, and not as a multi-area seleciton for
the frist argument to the function, the known_y argument.
Is it possible in some way to accomplish this?
Thanks,
tom Tag: Adding Streaming video to your web-page is as Tag: 99842
new line in mail in notes from VB
Hi, I have set up a bit of VB code send automated mail from Excel.....
however i dont know how to start a new line in the mail.... everything
I enter goes on the same line.
Does anyone know how i can put tables into my automated mail, or even
just copy a range of cell and have them inserted?
any help would be greatly appreciated, thanks. Tag: Adding Streaming video to your web-page is as Tag: 99837
New Workbook Defaults to Personal.xls
Hi,
Whenever I start a new instance of Microsoft Excel, the default
filename is Personal.xls, instead of Book1 (or whatever...)
Since I have some procedures built into my Personal Macro Workbook, can
I change the default name of a new Excel workbook?
Any help you can lend would be appreciated.
Henry Tag: Adding Streaming video to your web-page is as Tag: 99836
Excel default number format problem
I have a user with an incorrect default cell format in Excel. His
default number of decimal places for a cell with numbers is set to 4
instead of 2. I have no idea how he caused this and I have no idea how
to correct it. In case I'm being ambiguous, here is the procedure:
Open a new Excel workbook, choose any cell and go to Format. In the
Format Cell dialog box go to the Number tab and choose the Number
category. The Decimal Places box will be set to 2 by default but in
this user's Excel it is set to 4. How do I get it back to the default
of 2?
http://www.imagedump.com/index.cgi?pick=get&tp=439712
http://i110.photobucket.com/albums/n111/nosaj19/gthompsonexcel.jpg Tag: Adding Streaming video to your web-page is as Tag: 99835
HOVER over a cell
is it possible to have a cell pop up or become 3D when the mouse hover
over it?
--
just1creation
------------------------------------------------------------------------
just1creation's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35468
View this thread: http://www.excelforum.com/showthread.php?threadid=564307 Tag: Adding Streaming video to your web-page is as Tag: 99834
Eliminate 0 values from pivot table
I have a stock detail sheet where I have a line for all stock
transactions. Basically they are organized as SKU (stock codes), LOT
(lot number) and UNITS (+/- incoming/outgoing). This sheet is summarized
in a pivot table.
The problem now is than when a certain SKU/LOT is used up, for instance
as +10 UNITS and 2 lines showing a usage of a total of -10 UNITS, I do
not want this SKU/LOT to occur in the pivot table.
Therefore I have considered to add a column that for each line shows for
instance an "E" for all lines where the stock as SKU/LOT is empty. Then
I could omit these rows from the pivot table to avoid these to be
displayed as "0" lines.
But can't figure out how to do this :-( Tried a sumproduct, byt this did
not succeed.
Hope for some help. Thanks!
Mogens Tag: Adding Streaming video to your web-page is as Tag: 99833
Selecting cells containing spcific character(s)
Hello,
I need to know how to get Excel to select all cells within a specific
column that contain a specific character. In this instance, I need to
select all the cells which contain a comma...
And even better would be if I could get Excel to not just select all
the cells in a specific column containing a comma, but each of the rows
in which those cells reside.
I hope this makes sense and someone can help me.
Thanks.
--
ianwitt
------------------------------------------------------------------------
ianwitt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36697
View this thread: http://www.excelforum.com/showthread.php?threadid=564300 Tag: Adding Streaming video to your web-page is as Tag: 99831
problem
Hi
I have a problem in excel when i try to import data from MSSql with
Import
external data: I must use the same condition in two places in the same
query..something like that:
select col2 from d where col1=? union select col3 from d where id not
in
(select col2 from d where col1=?)
this query works perfectly in MSSql, but when I try to do this in my
".dqy"
file the excel tell me I have an error in my sql...
pls help me Tag: Adding Streaming video to your web-page is as Tag: 99828
Adding Streaming video to your web-page is as
simple as a few clicks of the mouse with this
amazing tool.