Adding Streaming video to your web-page is as

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - 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
  - 2
    - 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
  - 3
    - 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
  - 4
    - 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
  - 5
    - 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
  - 6
    - 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
  - 7
    - 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
  - 8
    - 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
  - 9
    - 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
  - 10
    - 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
  - 11
    - 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
  - 12
    - 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
  - 13
    - 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
  - 14
    - 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
  - 15
    - 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
  - 16
    - 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
  - 17
    - 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
  - 18
    - 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
  - 19
    - 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
  - 20
    - 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
  - 21
    - 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
  - 22
    - 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
  - 23
    - 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
  - 24
    - 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
  - 25
    - 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
- Next
  - 1
    - 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
  - 2
    - 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
  - 3
    - 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
  - 4
    - 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
  - 5
    - 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
  - 6
    - 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
  - 7
    - 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
  - 8
    - Best Cheap Deal for All Hi All ! BEST PRICE FOR YOU HEALTH LIFE : 'tramadol' (http://tramadol.knopkabablo.info/) 'phentermine' (http://phentermine.goodpharm.info) 'tramadol' (http://tramadol.goodpharm.info) 'ultram' (http://ultram.goodpharm.info) 'valium' (http://valium.goodpharm.info) 'xanax' (http://xanax.goodpharm.info) 'ambien' (http://ambien.goodpharm.info) 'carisoprodol' (http://carisoprodol.goodpharm.info) 'cialis' (http://cialis.goodpharm.info) 'cheap phentermine' (http://cheap-phentermine.cheapills.info) 'cheap tramadol' (http://cheap-tramadol.cheapills.info) 'cheap valium' (http://cheap-valium.cheapills.info) 'hydrocodone' (http://hydrocodone.cheapills.info) 'phentermine online' (http://phentermine-online.cheapills.info) 'valium online' (http://valium-online.cheapills.info) 'viagra' (http://viagra.cheapills.info) 'xanax online' (http://xanax-online.cheapills.info) _******Best_Travel_Deals*******_ 'adventure travel' (http://adventure-travel.globaltr.info) 'airline ticket' (http://airline-ticket.globaltr.info) 'business travel' (http://business-travel.globaltr.info) 'calgary travel' (http://calgary-travel.globaltr.info) 'cheap travel deal' (http://cheap-travel-deal.globaltr.info) 'cruise travel' (http://cruise-travel.globaltr.info) 'islands tour' (http://islands-tour.globaltr.info) 'overseas adventure travel' (http://overseas-adventure-travel.globaltr.info) 'travel' (http://travel.globaltr.info) 'walt disney world travel' (http://walt-disney-world-travel.globaltr.info) bye.. -- Fox Kimpbell ------------------------------------------------------------------------ Fox Kimpbell's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36725 View this thread: http://www.excelforum.com/showthread.php?threadid=564526 Tag: Adding Streaming video to your web-page is as Tag: 99891
  - 9
    - 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
  - 10
    - 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
  - 11
    - 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
  - 12
    - 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
  - 13
    - 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
  - 14
    - 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
  - 15
    - 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
  - 16
    - 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
  - 17
    - 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
  - 18
    - 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
  - 19
    - 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
  - 20
    - 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
  - 21
    - 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
  - 22
    - 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
  - 23
    - 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
  - 24
    - 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
  - 25
    - 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.

http://www.ebvalues.com

Top