Registration date
April 11, 2009
Last seen
June 21, 2011
Contributions
261
Gender
Male
Location
Thiruvananthapuram, INDIA
Signature
A wise man once said, 'I complained that I had no shoes until I met a man who had no feet.' I am interested in financial Modelling and custom excel development with excel macros.

Arrow keys not working in Excel [Solved/Closed]

Hello, I am using Excel 2000. I am tring to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. I was always able to move up, down, right or left using the arrow keys but this problem just started out of the blue. DaisyE Read more

Comparing columns and returning value [Solved/Closed]

Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A B C D 1 1 Z Forumula: return value 1 2 Y 1 3 X 1 4 W 2 5 V 2 6 ... Read more

Copying data from one Excel sheet to another. [Solved/Closed]

Hello, Newbie here. Okay, I have an Excel workbook that houses a form on the first sheet. What I'm trying to do is to automatically copy the data entered into the rows that are housing the inputted data into a separate sheet that will be used as a database. The database will maintain all of the various entries that have been made ... Read more

My computer only opens on safe mode

Hello, i dont know how but my computer has a virus and it isnt opening on anything but safe mode i dont know what to do can anybody help me a diagnostic a anti virus anything

Comparing columns and returning value [Solved/Closed]

Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A B C D 1 1 Z Forumula: return value 1 2 Y 1 3 X 1 4 W 2 5 V 2 6 ... Read more

Automation of running excel macros [Solved]

Hello, I have a macro in excel which needs to be run twice a day and I dont even want to open the excel sheet. How can I make this process automatic? If I can convert the macro to Exe file, maybe I can put it to my task manager. Please advice. Many thanks Ped Read more

Outputting numbers 1 to 100 in rows of 10

Hello, Could someone give me help with Excel: how to output the numbers 1 to 100 (10 rows with 10 columns) using a For loop. so far i have the following For x = 1 To 10 Cells(1, x) = x Next x For x = 1 To 10 Cells(2, x) = x + 10 Next x etc.... This works but ... Read more

Extract identical cells of 2 columns (excel)

Hello helpers!, Got a list of words in column A Got a list of words in column B I am looking for a formula that will produce in column C a list of the words that appear on both columns. Thank you for your help!

how to calculate a alphabet [Solved]

Hello, for my workers I am mainaning attandance sheet and every month I have to send it to my head office. for their presents iam putting P and for absents A. my query is ,can we calculate a particular alphabet in one coplete row. for example: P is mentioned 25 times in 30 days ,can wetake the values of P. please give me a formula if... Read more

paste data into alternate blank cells

Hello, in using Microsoft Excel 2007, I'd like to paste data from one column into a another column that has some data in it along with some blanks - but the trick is that the data being pasted from the first column into the second column can only fill in blanks in the second column! It should not overwrite any other data in that 2nd co... Read more

Copying data from one Excel sheet to another. [Solved/Closed]

Hello, Newbie here. Okay, I have an Excel workbook that houses a form on the first sheet. What I'm trying to do is to automatically copy the data entered into the rows that are housing the inputted data into a separate sheet that will be used as a database. The database will maintain all of the various entries that have been made ... Read more

Copy to next blank line

I'm new to macro - so don't laugh... I'm trying to copy Cells A1 and B1 from 400 worksheets to a single worksheet (Merge). The following macro code copies and pastes the cells but overwrites each time the macro is run. How can I tell the system to paste in the next blank row? Sub Macro5() ' ' Macro5 Macro ' Range("A1:B... Read more

Open excel file into worksheet of open workbk [Solved]

Hello, MS Excel 2000, VBA I'd like to be able to open a file directly into a new worksheet of an open workbook, thus adding the new sheet in the process in a VBA macro. I can open the file (which happens to be an html file, with that extension) fine into a new workbook, using the code: Workbooks.Open Filename:="xxxxx.html" ... Read more

Automation of running excel macros [Solved]

Hello, I have a macro in excel which needs to be run twice a day and I dont even want to open the excel sheet. How can I make this process automatic? If I can convert the macro to Exe file, maybe I can put it to my task manager. Please advice. Many thanks Ped Read more

How to make a cell change colour

Hello, i am trying to make a money sheet on excel to sort out my money. i already have the basice sheet made and i have a sum in the box i want to use. i want to keep the same sum in the cell but i also want to add another to make the cell change colour to green if the amount is above 0 and red if the number turns into a negative belo... Read more

Calculate the sum of rows using macro [Solved/Closed]

Hello, I need some help with the folowing problem. I have a table with changing length of rows and columns. I need to calculate the sums of the rows and columns and write it in the next blank cell. I managed to write a working macro for the columns but I have a problem with the rows. Could you please help? Here are the two codes... Su... Read more

return days only if between two dates -Excel

Hello, I have a start date and an end date that span many years. I need to calculate prorated information about the rest of the row based on the number in each year. Example: Start Date, End Date, Days for 2009, Days for 2010, Days in 2011 05/04/2007, 09/08/2010, ... Read more

Conditionally deleting rows in excel 2007 [Solved]

Hello, I'm hoping someone here might be able to help me with this. I have a spreadsheet where column A is a project name then columns B, C and D are financial data for the specific project. What I would like to do is delete the entire row for the project only if columns B, C and D ALL contain Zero's. I can set up a filter and filt... Read more