Search results for query: *

I have not been able to get any answer regarding the following question for which I've been searching for answer for a while: Is there any way to create pure VBScript for automating PPES and IWR publishing to a specific Upfront folder without using ANY CognoScript? Any help, no matter how...

I have a sheet with descriptive text in column G. I would like to be able to search for a specific word in all possible rows with a wildcard; for example anything with the word 'travel*' in it. If the text containing 'travel*' is found in column G, I would like the entire cell highlighted and...

I'm totally new to VB.NET. I'd like to know if there is any quick way to build a very simple GUI interface to be able to control a Windows batch file. For example, I have the following batch file command: xcopy c:\Report_Target\report.ppx e:\Report_Destination\ In my case, since the paths or...

I have the following table: 1 ABC Company

I have a simple in-cell drop down which reads a bunch of company names from an Excel table stored within a hidden sheet in the same workbook. Lately, the table has grown tremendously and has become quite cumbersome for users to manual scroll and search through the company names. I haven't a...

Here is my situation: I have the following standard directory structure in Windows 2003 Server- ParentFolder1\SubDirectory1\cubes ParentFolder1\SubDirectory1\reports ParentFolder1\SubDirectory1\models ParentFolder2\SubDirectory2\cubes ParentFolder2\SubDirectory2\reports...

Hi, I`m using Excel 2002. Is there a quick or automatic solution to force the same row/column height/width within all sheets (or certain sheets of my choice for that matter)? Why? I have several worksheets with the same layout. I would like users to see a uniform spreadsheet when they...

Does anyone know of an availability of an Excel template, sheet, or macro with Gantt chart like functionality similar to MS Project? Any input would be greatly appreciated. Regards, Shawn

I'd like to be able to enter a number of minutes into a cell, but if I enter anything more than 60 minutes, I would like it to recognize this and enter the appropriate format in hours & minutes. For example: If entering 75 minutes, the cell should automatically display 1h 15min. Also, if I...

I would like to be able to enter a date in cell A1 and, as a result, I would then like the next 6 cells (B1 thru G1) to be automatically filled with the appropriate dates for that week. For example, the user enters Jan. 9, 2005 (which is a Sunday) in cell A1; cells B1 thru G1 should...

Is there any formula that exists in Excel that counts all data including any other info, and blanks? For example: COUNT would count the cells with data COUNTA would count cells with any other info I actually need a formual that would count all info in cells including empty cells in a specific...

This is probably a pretty trivial question, but is there a formula that counts the number of rows in a column ranged regardless of whether there's data present? - COUNT just gives me the number of rows with actualt data - COUNTA gives me the number of rows containing any info Is there a COUNT...

Hi, I have two columns: Column C is Status Column D is Priority Possible values for status is Open, Closed or Pendging Possible values for Priority is Low, Medium, or High I need to create a row total that counts all items with BOTH an Open status AND High priority. How do I create a...

Hi, I have about 4300 queries in an Access 2000 DB. I'm using a 3rd party tool to read in the queries. However, my 3rd party tool complains whenever it finds blanks in any query names. I was wondering if there is there any way to automatically search for all blanks in all query names in an...

Hi, I posted this question in the VBA forum, but I feel I need a non-vba answer to my question: Is there a way, using the hyperlink function, to jump to the top of another sheet? What I need is to be able to jump from the current sheet to the destination sheet at the same column location in...

Hi, Is there a way, using the hyperlink function, to jump to the top of another sheet? What I need is to be able to jump from the current sheet to the TOP of the destination sheet at the same column location in the destination sheet. In other words, is there some type of parameter in the...

Is there any way to insert an image in the background in Excel that is not necessarily transparent and that is non-tiled? Ideally, it should be static and behind all text. So far, no one has been able to help me. Thanks very much, Shawn

How do I programmatically determine (or convert) the address of a specific cell in Excel into R1C1 notation including the current sheet? For example, I need to find the address of the active cell in the active sheet in the following format: Assumption: active cell is B2 in sheet ABC Result...

Is there any way to set the print area to be dynamic? Is there a way to detect the last row and/or column so that the print area can be automatically adjusted accordingly? Thanks, Shawn

I was wondering what the differences, benefits, disadvantages of using a VLOOKUP versus the INDEX & MATCH functions in Excel? Thanks, Shawn