Excel Forum

Ask a question
Results 5651 - 5700 of about 9,840
  • Replace charecter string with leading character Closed

    Hello, I'm working on an extremely large catalog project where I'm basically taking one column of text and breaking it up into several different c...

    davidplowman | Latest reply: rizvisa1 May 4, 2013
    4 replies
  • creating an If function using dates Solved/Closed

    Hello I am trying to formulate an if function, should the date in the cell be less than six months old from today's date the font is red, should the ...

    dawnski333 | Latest reply: Kevin@Radstock May 3, 2013
    4 replies
  • extract data from other spreadsheets in the same document Closed

    Hello, I have about 100 sheets with different names in my excel document. I am trying to extract two numbers for each sheet into a summary sheet....

    luigi206 | Latest reply: luigi206 May 2, 2013
    2 replies
  • copy data from one sheet to another sheet in excel Closed

    Hello i am having data in sheet one against date in column A1 and i want to paste date in sheet 2 against same date after this i want to change d...

    gagandeepc | Latest reply: gagandeepc May 2, 2013
    0 replies
  • Sum numbers in a column by corresponding number Closed

    Hi there My question basically boils down to payment / invoice match. In one column I have amounts (paid or invoice - often one payment will inclu...

    denman | Latest reply: sgmpatnaik Apr 30, 2013
    3 replies
  • Unable to copy selected cells after apply autofilter function Solved/Closed

    Dear All, I am using excel 2007. In my dataset, I have following: Column A - Set of locations and Column B: Number of times location appears. When...

    venus1060 | Latest reply: stonehendriks Apr 30, 2013
    4 replies
  • Spellnumber for Excel

    Hello, Good day to all. I have this problem about supplying automatic spell number in writing checks. Actually, I already have seen so many ways ...

    dhaf | Latest reply: sgmpatnaik Apr 30, 2013
    1 reply
  • Num Convert to text in Excel 2007 Solved/Closed

    R/Sir, As per your instruction i have done how to num convert into words.But i have face a problem when i have writeen above 99999, than num co...

    Rupendra Singh | Latest reply: sgmpatnaik Apr 30, 2013
    1 reply
  • Warn the User of empty cell and indicate the location based on v Closed

    Hello, I am new to VBA. I have a problem which I believe is very simple, but I am failing foolishly. I have to generate a MsgBox warning the user t...

    shalom1506 | Latest reply: Zohaib R Apr 30, 2013
    3 replies
  • Calculate average $/HR by pulling data from two workbooks Closed

    Hi, I have been researching trying to figure out how to do some data manipulation with VBA, I have been going nuts trying and failing at making this w...

    chouston | Latest reply: sgmpatnaik Apr 29, 2013
    1 reply
  • Search for text in multiple tabs and copy result Closed

    Hi. Help needed please. I have a 2010 workbook which tracks income and expenditure, by month, for a small voluntary organisation. I want to be able...

    DavidJones_1946 | Latest reply: venkat1926 Apr 29, 2013
    4 replies
  • Need help sending automated email in excel Closed

    Hello, I need help. I am a rookie to excel and I would like excel to send an email everytime there is a change made to the drop down cell of my ex...

    GilbertDew | Latest reply: sgmpatnaik Apr 29, 2013
    1 reply
  • how to add day automatically after giving the date Closed

    Hello, Please tell me the formula that i want that days are automatic displayed when enter any specifica date. For example if i write in excel...

    maaiz | Latest reply: sgmpatnaik Apr 29, 2013
    6 replies
  • How to insert result of =SUMIF on next free row Closed

    I want to create an =sumif query on a new tab, which looks at all 12 tabs in an annual accounts workbook, either month by month or all 12 months at on...

    DavidJones_1946 | Latest reply: DavidJones_1946 Apr 28, 2013
    0 replies
  • Create new sheet,rename and allow duplicates numbering them sequ Closed

    I have a workbook with 3 worksheets. 1) MENU 2) Arrears Report 3) NEW ACC and a button on the menu sheet with the following macro below The pro...

    MRafik | Latest reply: rizvisa1 Apr 27, 2013
    3 replies
  • Sum a range of values only if it has certain value Closed

    Hi, I need a formula to sum the values in a column but only for the cells in the next column that have a specific value. In my case I have range o...

    Suranjith | Latest reply: Zohaib R Apr 26, 2013
    3 replies
  • looking for formula. Closed

    hi looking for a formula to combine two worksheets in one both have 3 columns. if i copy the both worksheet in one than i have 6 columns like this. ...

    ahamaz | Latest reply: Zohaib R Apr 23, 2013
    1 reply
  • while pasting the Un protected Cells became Protected an locked Closed

    Hello, I made A excel work book called (Customer Daily balance) to be used by my Employees(users), this sheet is calculating the recent balance o...

    SALWA ATALLAH | Latest reply: TrowaD Apr 23, 2013
    2 replies
  • Data Validation w/ Sum in Excel Closed

    Hello All, I just found out about the drop down menu (Data Validation) feature, but I have a question in regard to it. I am trying to create a l...

    EthosAri | Latest reply: sgmpatnaik Apr 23, 2013
    2 replies
  • Date format Closed

    In Excel sheet i can't change date format. I tried to change usual. But nothing is happened. One format showing Standard. Please give the Solution.

    Karthick P | Latest reply: TrowaD Apr 22, 2013
    1 reply
  • Help on..Calculating number of weeks between week numbers.. Closed

    Hello everyone, I would like some help please.. :) I would like to calculate the weeks between week numbers. i.e Start Date: 04/03/2013 Week 10...

    A-Bomb | Latest reply: TrowaD Apr 22, 2013
    8 replies
  • VBA Code 2 import many cells not in range from many workbooks Solved/Closed

    Hello, I have used some of your codes for importing data ranges from several workbooks. I am using Excel 2010. I have around 2,000 workbooks ...

    samirelsabagh | Latest reply: samirelsabagh Apr 21, 2013
    4 replies
  • Change date format Closed

    Hello, I want change date formula to "sep 10 2013" in 10-9-2013 plz give me detail Configuration: Windows XP / Internet Explorer 8.0

    Dipak Sonwane | Latest reply: rizvisa1 Apr 20, 2013
    3 replies
  • Excel Macro to insert the same 120 rows between 1000 unique rows Closed

    Hello, I'm creating a product catalog database in Excel. I have 1000 unique product lines (rows). Each of those 1000 products is offered in 120 col...

    TheAssistant | Latest reply: rizvisa1 Apr 20, 2013
    6 replies
  • how can I change date figure into english words Closed

    Hello, i want to change a date written in figure in excel sheet in words. eg 6-4-2013 into Sixth april Two thousand thirteen please help me

    skg1981 | Latest reply: Ambucias Apr 19, 2013
    3 replies
  • Formula Help Solved/Closed

    Hello, I think this is a simple question just not for me :) I have a simple business spreadsheet showing total project cost in Column (C.) C, T...

    sjefferys | Latest reply: Zohaib R Apr 18, 2013
    3 replies
  • Macro for fill color alternative rows Closed

    Hello, I want a macro for fill color alternative rows in excel selected table (only visible rows), anyone can you please help me.

    jk | Latest reply: nick316igr Apr 18, 2013
    8 replies
  • Formula not working Solved/Closed

    Hello, Q16 to Q20 cells contains values from 0 to 10 (it came from LOOKUP Function). I need to get a result in D24 from the cells Q16 to Q20 as ,"...

    jinoob | Latest reply: Zohaib R Apr 18, 2013
    13 replies
  • import from multiple workbook to single SHEET Solved/Closed

    Hi, Thank for all your wonderfull help all these days, to cut short, I am looking for a VBAcode, which can import data from multiple Workbook file...

    Nitin | Latest reply: samirelsabagh Apr 17, 2013
    5 replies
  • Compare 2 sheets Closed

    Hi, I have two excel sheets that i need to compare. The problem is that the column headers of sheet 1 doesn't match with the column headers of shee...

    Swati Nayak | Latest reply: Zohaib R Apr 17, 2013
    6 replies
  • Macro to delete a certain worksheet... Closed

    Hello, I was previously helped out with the following macro: https://ccm.net/forum/affich-689536-generate-excel-workbooks-based-on-excel-list ...

    m_albges | Latest reply: rizvisa1 Apr 17, 2013
    1 reply
  • How to get the last digit of a value of a cell to other in VBA ? Closed

    Hello, I am trying with vba excel that how to get the last digit of a value in one cell to other.suppose I am trying to the get last digit of 9928...

    HARIKA | Latest reply: Zohaib R Apr 17, 2013
    1 reply
  • Comparing two columns of names in Excel Solved/Closed

    Hello, I have one excel sheet. column A has a list of names formated as follows: Last name, First name Column B has a much longer list o nam...

    STEMPEKA | Latest reply: JeffS79 Apr 16, 2013
    8 replies
  • Need help with Excel Formula Closed

    I am having trouble figuring out a formula when figuring angles. I will write what I need (very simply) so you understand what I am trying to do. ...

    OHAndyIO | Latest reply: TrowaD Apr 16, 2013
    1 reply
  • Get excel 2010 to send auto e-mail Closed

    Hello, I have a spreadsheet that i track my vendors certificate of insuranse expiration dates on. i am wanting excel to send me an automatic e-mai...

    eturner66 | Latest reply: TrowaD Apr 16, 2013
    1 reply
  • What is the shortcut key to drag down in excel to create series Closed

    What is the shortcut key to drag down in excel to create series of numbers from 1 to 10.

    Anil Maharana | Latest reply: TrowaD Apr 16, 2013
    2 replies
  • Issue with V-lookup and possibly pasting data from the web? Closed

    Hi, I'm hoping someone can help me. Using windows 2010, I'm using data from 500 alphanumeric codes that I copied-and-pasted from the net into a pr...

    davidplowman | Latest reply: TrowaD Apr 16, 2013
    4 replies
  • Spreadsheet data Solved/Closed

    Hi everybody. I am trying to develop a large data input spreadsheet which will have circa 20 operators data input on a daily basis. (approx 150 ent...

    ankharm | Latest reply: TrowaD Apr 16, 2013
    9 replies
  • finding values from 2 worksheets where item matches Closed

    Hi, I have just start my new role where I am stuck some where I have got 1 Order form where SUPLIER NAME|SUPPLIER CODE |SUPLIER ITEM CODE|REF N...

    Sam99p | Latest reply: TrowaD Apr 15, 2013
    1 reply
  • Attendance sheet Solved/Closed

    Hi, i want to make attendance sheet in Microsoft Excel 2007 with alphabetical words like P for Present, A for Absent, L for Late, H for Holiday wit...

    sanjay001 | Latest reply: rizvisa1 Apr 14, 2013
    1 reply
  • excel vba to open other screen Solved/Closed

    Hello, We are working on dual screens. I am writing a macro program in VBA. I need to open an existing excel file/workbook in a new excel application...

    Tibor | Latest reply: holycow Apr 13, 2013
    5 replies
  • How do I get excel file ( no formula) from another one ( with fo Solved/Closed

    Hello, I have a big excel file with lots of formula and link. now can I export these data only( no link or formula) to another excel file? Thank yo...

    ziyun | Latest reply: Zohaib R Apr 12, 2013
    18 replies
  • Exclude "0" values from string: =H2&";"&I2&&quot Closed

    Hello, I'm using the following string in excel. =H2&";"&I2&";"&J2&";"&K2&";"&L2&";"&M2&";"&N2&";"&O2&";"&P2&";"&Q2 It will concatenate serveral ...

    Pluggie | Latest reply: aquarelle Apr 12, 2013
    1 reply
  • How to check two fields in excel and act by that? Solved/Closed

    Hello, Can anybody help? I would need very simple macro to check two cells. A1 will be name A2 A3 will be second namew A4 Does A2=A4 ...

    akaldojad | Latest reply: akaldojad Apr 12, 2013
    3 replies
  • using IF for data validation Closed

    Would like to seek your assistance. I trying to make a condition using data validation. this is the scenario: for column C8 (this is the dropdown l...

    Wowexcel | Latest reply: Zohaib R Apr 12, 2013
    1 reply
  • Conditional formatting in Excel 2003(more than 3) Closed

    Hello all, Excel 2003 novice here trying to teach myself. I am trying to make some fields turn a certain colour depending on the number of...

    plangey | Latest reply: plangey Apr 8, 2013
    2 replies
  • Conditional formatting Solved/Closed

    I am trying to maintain three lines of accounting on one spreadsheet. Basically, I have an order amount (C3) . I want to take that total from one of...

    CrazieB317 | Latest reply: TrowaD Apr 8, 2013
    3 replies
  • Count when a range of cells contains a certain word or phrase Closed

    Hello, I have a spreadsheet which I am trying to summarise information from. We receive enquiries from many different properties we manage, and I'...

    HABBHR01 | Latest reply: TrowaD Apr 8, 2013
    1 reply
  • Copy data from one WB to another Closed

    Hello. I'm hoping I can describe my problem/question in a way that makes sense... Here goes: At my work, we have a program that will create an exce...

    sistrbubbles | Latest reply: rizvisa1 Apr 6, 2013
    3 replies
  • Macro for inserting missing monthly rows Closed

    Hello, Can someone please help me with writing up a macro which inserts rows, which contain missing monthly dates within a data set? I basicall...

    Lillian888 | Latest reply: rizvisa1 Apr 6, 2013
    3 replies