I have created a 'for' loop with index j. Now I want to track the value of j when this loop is running. For this purpose I have created a textbox. The value of...

I would like each cell in a column to duplicate the contents of each cell in another column, but only when the latter (which already has contents) is...

I want to sort other worksheet in the same workbook, I try to run macro from Sheet2: ----------------------------------- Sheets("Sheet1").Select ...

I need to be able to count the number of cells in a column containing certain text words, but only if cells in the same row in 2 other columns contain...

I have two columns, one with a list of test cases (most are duplicated) and one with whether it passed or failed. In order to gauge whether the next level...

#Animals Total Pounds ...

I have a spreadsheet with the following names defined: Funtional No: 1 2 3 4 5 6 7

Worksheet 1: Column A has values Column B is text for those values Worksheet 2 Column A has same some of the same values as WSheet 1, but not in...

I have question on how to have the filtered results on one sheet be the list for data validation one another sheet. I have one worksheet that has a 10...

The small sheet tabs at the bottom of an excel worksheet are really quite small; how does one make them larger (font size)?

If the time on A1 = 12/3/07 8:00 A.M A2 = 2 (hours) On A3, what is the formula so if A1 + A2, it should show 12/3/07 10:00 A.M? If A2 = 24 (hours), A3 should...

Hi All, I'm looking for a macro to sort my data on the 'Analysis' sheet, to throw the totalled results on the 'results' sheet. I want it to find all the...

I have a list of data that includes information such as; Name, Policy Number, Original Effective Date, Status and Cancellation Date. There is other...

I've inherited a spread sheed with a calculation using ^2. I understand the rest of the calc but can't work out the funtion of ^.

Formula below is pretty basic, however the problem I'm running into is that the WB that the formula is pulling from is closed more often than not. Is there...

I have an excel spreadsheet, with over 3000 rows. I have to review and sort daily, then go back to the next blank row and start entering data. I am looking for...

I'm looking for a formula that displays the billing-month start date based on a user-entered end date. The system I will be using this calculation for...

I am constructing a Sales Order Form and I keep getting an error message that I have too many arguments in the formula. The result that I am looking for is:...

Hi, I’m creating a spreadsheet to track the activity of my department next year. One of the things I want to do is track the money made on a certain kind...

Sub NewNamedRange(NR As String) 'Nr is sending a number like 2007 Dim aw As String 'used to name range Dim aw1 As String 'used for...