I am new to macros but have worked out how to transfer the results of a calculation to a row on another sheet. When I clear the original data to enter more...

hey guys can any one help me?(of course it is not a excel question) My drives are not openinin. if i double click on my drives an "open with" window opens. I...

I have the following: Attended Attended A B C D E F 1...

hi, I want to calculated travelling cost depending on the days of travel. I have following data. (0-7)hrs-0$, (8-13)hrs-5$, (14-23)hrs-10$, 24hr-20$. Now...

I really need to know how I can print my finished excel spread sheet on the same paper but I need one side with a clients supports and then the other side...

How can I auto activate of a macro with respect to date

I want to count how often a single value (the dash symbol) occurs in a single cell than rank it. Showing two examples, AUS-IAH/PTY-IAH/AUS is in cell A1...

Hi I run Excel 2000 I have a list of names with each one of them having a hyperlink to an email address. These all work fine. What I would like to do is...

I would like to be able to type the first few letters in a cell that uses a long drop down list and quickly go to the full name in the list without having to...

I am not sure how to get my words to go vertically on top on my spreadsheet in excel.

I need to flag duplicate names in a spread sheet sorted by Surname, Given Name (separate columns). In other words... IF (the surname and the given name in...

Hi! How to find repeated data and then merge and centre. My data is from A to M.Range from A1 to M4500 Any Function Or Macro. Thanks Hardeep

Hey, I have a column filled with text. there are about 100 cells in this column. Those cells each have the name of a single corporation within them. many of...

The 2 data sets are assumed running in A3 and in B3 down, viz.: In A3 down is: 1, 2, 3, 4 and 5 In B3 down is: 2, 3, 2, 6 and 8. In D3 is a parameter which...

I have created a report for our company that covers each day of the month - a 31 page workbook. It looks great, but I now need to protect it. I realize that...

How do I count the number of records within a date range. eg 1/1/2003,1/5/2003,1/10/2004 Using countif between 1/1/2003 and 31/12/2003 = 2

How to Split the contents of cells across multiple cells Hi , I’m trying to split address from one cell across multiple cells with no success with Data /...

I am reading a book on Excel 2003 VBA programming. It gives a short synopsis on how to set up the code for the workbook_open macro but doesn't really go into...

When I trying to sort my data in excel there is an error appearing like "the operation requires the merged cells to be identically sized" and in detailed it...