Registration date
January 28, 2010
Last seen
February 12, 2016

Auto Filter depending on Cell Value [Solved/Closed]

Hello, I have data in a table, lets say the table is (A7:M200) and the Headings in this table is (A7:M7). Column 1 (A8:A200) is the accounts numbers. I already selected the Row 7 (the headings in this table) then I made Auto filtering. Now my request is when I write in Cell (E1) any account number to filter that table (A8:M200) ac... Read more

Single Quote - Excel 2007 [Solved]

Hi, Does anyone know what the single quotation mark ' means when entered at the beginning of a cell? I notice that the quotation mark does not actually appear in the cell. In other words, it appears in the formula bar when entered but disappears from the cell once you press enter. I want to to get rid of that. I need a single q... Read more

Cannot change the date format in Excel 2007 [Solved/Closed]

Hello, I have tried everything mentioned in this forum and they still do not work. I have a sheet with the date appearing dd/mm/yyyy, I have tried Format Cells-Date-Type (mm/dd/yy) but it still stays in the format dd/mm/yyyy. I even went to Custom-Type(m/d/yyy) still nothing changes. Any help please? Configuration: Window... Read more

Excel Macro to group by column & sum value [Solved]

Hi there, I need to write a macro for following example. Item Qty Length A 1 100 A 1 100 B 2 200 B 1 100 B 5 100 C 4 200 C 2 100 C 1 200 C 3 100 Basically I want to group by Column A (i.e. Item) and Column C (i.e. length) and also wants to add total of quantity for each change in lengths for an item. In this case... Read more

Convert Date into English Words in Excel [Solved]

Hello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April 2010 or Twenty Two April Two Thousand Ten. Thanks

how to align all common list in excel? [Solved]

i have 4 columns. the first two (A & B) columns are list of cheques i issued. then the other two (C & D) columns are list of cheques encashed from Bank. that looks like this: A ---------- B ---------- C ---------- D ISSUED----Amount----En-cashed----amount 001 ------ 112.00 ------ 001 ------ 112.00 002 -... Read more

if date in cell is greater than date in cell [Solved]

Hello, I am a beginner with formulas in Excel. I am working with dates formatted dd/mm/yyyy. I need a formula that will return a value of yes or no, if the date in cell A1 is before or after the date in cell B1. Can someone help. Thanks, MelConfiguration: Windows XP / Internet Explorer 6.0 Read more

Date wrong after converted in Excel

Hello, I have data pulled from database to CSV file which can be opened with Excel. The date in the spreadsheet shows as "201003" in text format, and then "4/28/2450" after I change data format to "Date" category. "4/28" might be correct, and "2450" definitely is wrong. But I don't have access into the database to see the actual year. ... Read more

Arrow keys scrolling in Excel [Solved/Closed]

Hello, I'm working in Excel and my arrow keys are moving the entire spreadsheet and are not moving cell by cell up, down, right or left. I do not have a scroll lock key on my Logitech Cordless keyboard. I cannot figure out what I've done to change the movement of the arrows. Anyone know what I can do to get it to work again? ... Read more


Unlock your SCROLL LOCK key. Its turned on.

Answer Excel

How to save output of ping command in a text file? [Solved/Closed]

Hello, i want to save the output of either dos prompt or either c program output in a fixed file.that output I will be use in future. Configuration: Windows XP / Firefox 3.0.19

Hide/Unhide an Autoshape or Picture in Excel [Solved]

Hi All, Could anyone tell me the method to Hide/Unhide an Autoshape or Picture in Excel Spreadsheet? I know it is possible through Macro Codes, any other usual ways like hiding Columns, Rows or Sheets? With regards, PramodKumar

Autofilter tp leave out #N/A in macro [Solved]

Hello, I have a project id in column C , which iam checking from another source data which is there in a differenr tab .So ihave a vlookup fprmulae in the column X to check if the project is present in the other source .For this column X I have applied autofilter .Now what should be the criteria in the macro , for the autofilter to fi... Read more

Inserting/Copy rows, Transpose vba HELP [Solved]

Hello, I have searched through many posts and it appeard everyone is very helpful. My skills in vba are ok but i lack the knowledge to solve my problem... I have data as follows that i need to transform into singular rows depeding on Col 35 to 45. It looks as follows. I did not include the data because it too long. Please let me know... Read more

Create new worksheet & copy the based on date [Solved]

Hello, Can any one help me to copy the excel sheet data from one sheet to another sheet? -> I have one excel sheet (name: Test.xls, sheet name: SHEET1) Sn Code Type next calib 5 BPR CORR 7-Apr-12 4 BPR CORR 7-Apr-12 73 BPR CORR 7-Apr-12 9 BRG CORR 8-Apr-12 10 BRG CORR 8-Apr-12 11 BRG CORR 8-Apr-12 17 BRG CO... Read more

Entering current time in specific cells [Solved]

Hi, I am using a workbook where I record the time that I give each of my students an exam. I am using a tablet and I would like to be able to touch (or click) a specific cell to enter the current time. I found some code on this site that allows me to enter the time by clicking, but I don't know how to write it so that it will only apply ... Read more

Excel Macro: Rename all Worksheets [Solved]

So, I'm trying to figure out a way to rename all the worksheets in a workbook. the first worksheet would be "1" (without the quotation marks) and continue up for each worksheet, so the second worksheet would be 2, the third worksheet 3, etc. any help will be much appreciated. thanks

Copy Paste Data in Same column for multiple time [Solved/Closed]

Hello, i need following manipulation.... Data Before Column "A" 123456 123456 123456 123456 123456 ( After )Column "A" (After copy paste same data 5 times 10 times or whatever)....e.g. here 3 times 123456 123456 123456 123456 123456 123456 123456 123456 123456 123456 123456 123456 123456 123456 123456 ... Read more

change cell color based on input in a range of cells [Solved]

Hello everyone, I have formatted a cell based on a specific text entered in one cell. Example, A1 will turn green if I write "yes" on B2, using conditional formatting. But I want to use a range of cells, say B2:J2. If "yes' appear in any one of these cells, A1 will turn green. Any help would be appreciated. Thanks!!! Configuration:... Read more