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

Macro copy and paste in next blank cell [Solved]

Hi guys, I need some helping in excel macro. I have two sheets in a workbook. Sheet1 is for summary and Sheet2 is for the raw data. I need to update/insert/copy data in Sheet2 to Sheet1. Below is the sample macro code: Sub Summarize() Range("A6:AT6").Select Selection.Copy Sheets("ImprovementLog").Select Range(... Read more

link cell to another worksheet [Solved]

hi there, What i want to do is to link a worksheet to another worksheet. Like, when I type data on cell in sheet1... then, same data will automatically be on sheet2 and sheet3. Please help me save time... thank you very much! GOD bless!!!

Excel Formula output text which includes date

Hello, My problem is that I would like the cells that are included in my text to return in the format of a date. =IF([cell]="","",""&[cell]&" - "&[cell]&"") This should return, for example "9-15-2009 - 9-17-2009", instead it returns "40071.3333333333 - 40073.7083333333" Is there anything I can do to see dates? Thanks! Read more

I want to send 120 e-mail with 120 attachments [Solved]

Hello, I have excel file for salaries. In this file I have all the data for each employee (120 employees) including their e-mails as well. I want to sent for each one salary slip (in a table or row if information or attachment) showing his payment details. My questions: How can I do it in a quickly way using either VBA code or merg... Read more

VBA 2010 Open files in current folder loop [Solved]

Hello there, Think this is a relatively simple code and I've found examples but can't quite piece it all together to do what I want to do. I want to write a code that when run on an open workbook will then go to the folder of that active workbook and open the next file to run the macro again - and so on for each file in the folder. ... Read more

VBA search column for matching string [Solved]

I am trying to write a script in VBA for excel. For an entire column of data in sheet 2, for each individual cell in a column, I need to search a column in sheet 1 for a string that matches the value, and then copy paste certain cells from the same row in sheet 1 back to sheet 2. I can do the copy pasting, but I cannot figure out ho... Read more

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