Functions
in [Excel]
|
excel - horizont line above font X hi, i need consul, how make horizont line above/whereupon font X or V, i need for my work. THX ... 21 Apr 2010 20:53
Open multiple spreadsheets and pull data I'm writing an update routine that keeps 2 EXCEL 2010 spreadsheets in-sync. I'm using this code to open the first spreadsheet and read data into variable: Workbooks.Open ("\\server\share\Spreadsheet1.xlsx") set rgePROGRESS = Worksheets("xxxx").Range("A2:C341") (code works fine) Then I read local (or try to ... 20 Apr 2010 18:34
How to hide infromation in Excel? I am trying to hide information in Excel. I hid the row I wanted to hide. I can see hidden row when copy and paste information in new excel file. Is there a way to hide information? ... 21 Apr 2010 07:24
Total a column (or row0 by highlighting cells Isn't there a way to total a column of numbers without using the AutoSum function. I seem to remember that I could just highlight a series of cells and the total would be shown in the fx box. I can count the number of rows by just highlighting them. Can't I do the same thing to total by simply highlighting a gr... 20 Apr 2010 16:32
pulling a list of hyperlinks from a worksheet I have a worksheet with over 800 cells. Each cell displays a churches website url. I need to display the actual hyperlink http://www.whatever.com not the Link name. example First Baptist Church Nashville. I need the hyperlink http://fbcnashville.org. displayed in the next cell. ... 20 Apr 2010 16:32
Saving & Removing VB Code from WB Try this for the activeworkbook copy in in a standard module Chnage this line to the folder where you want the file TempFilePath = "C:\Users\Ron Desktop\Test\" Dim wb2 As Workbook Sub TestDeleteVBA() 'Working in 2000-2010 Dim wb1 As Workbook Dim TempFilePath As String Dim TempFileName As St... 24 Apr 2010 07:13
Charting the Sum of Two, or More, Series of Data I know there must be a relatively simple solution to my challenge, short of creating a new series od data which is the sum of desired series. Let's say that I have the following 02/13/2010 02/20/2010 02/27/2010 ... 0-30 $7,072,987 $5,990,448 $8,978,002 31-60 177,472 160,460 142,547 61-90 ... 22 Apr 2010 12:26
Count If.....help I am trying to sum the amount of time two words "high" and "very high" appear in a col....I can get this to work for one word but when i try and nest the statement it doest work - Why and how to i solve it. =COUNTIF('(R2) Risks Log'!L9:L99,"Very High",CountIF(Risks Log'!L9:L99,"High")) thanks. ... 21 Apr 2010 04:18
Automatic update to SUM formula cell references. I have a spreadsheet that has many SUM formulas that change on a monthly basis. Instead of manually changing each formula every month I want to create a reference to pull the row number from one cell so that updates each SUM formula. For example, change SUM($C$5:$C$8) to SUM($C$5:$C$9), where changing the 8 t... 21 Apr 2010 08:26 |