Archive for the 'excel' Category

I’ve a very long column (2000 cells). I need to make it several columns each one consist of 24 rows. So, the data in cells A25:A48 move to B1:B24, and those in A49:A72 move to C1:C24 & so on Can any one help in that with a macro or a script?? thx

Let’s say I have a workbook with two sheets. First sheet contains hyperlinks to cell ranges in the second sheet. The whole idea is, when a user clicks the hyperlink in the first sheet, he gets taken to the second sheet where the cell or cell range is selected and what I’m trying to do [...]

I would like to have a column determine the rank from 1 to 5 of a value from another colum. Here would be the ranges and transmuation table: 95% and up = 1 93-94% = 2 90-92% = 3 88-89% = 4 87% below = 5 Would appreciate your help. Thanks!

I say homosexuality is NOT a choice. Firstly, I myself am gay. I have never been attracted to the opposite sex and I don’t recall ever having a choice. I’ve grown up in an average, loving family and have excelled academically, socially and culturally. So there seem to be no environmental factors that have made [...]

I will try and explain this best I can.. say for example cells A1:A10 all have different values a1 = 100, a2 = 200, a3 = 300 etc. b1 i have a number that changes based on cells from another page that is fine. c1 I would like to have whatever number is in ‘b1′ [...]

Is there a way to have a Macro make a copy of a “Sheet”? For example, I have a sheet called “Sheet1″ that needs to be copied and have the entire/same data placed into “Sheet2″

Is there any way you can make it so a Excel Macro will export a “Sheet” into a comma-delimited .txt file? It might be too far-fetched — but I am just curious and interested.

in excel 07 if i have a formula that refers to the row index and the column index how do i copy it to all the squares in the table and not just one row/column at a time?

Need something to do prefer a project on the computer like in word, excel.

e.g. I want to fill a column automatically in excel with 12/12/2010 3:40PM 12/12/2010 3:45PM 12/12/2010 3:50PM and so on First date and time should be the current date and time (returned by now() function). Other values of the column should be derived from the first now() function by adding 5 minutes. So in the [...]