Excel Forum

Ask a question
Results 5601 - 5650 of about 9,800
  • Re: Make a macro run when data entered in a cell -multiple event Solved/Closed

    Hello, I have three macros in the module and I want each macro to runs when the user changes the values in the cell (Cell F2) to "first", "second", ...

    tosinsog | Latest reply: TrowaD May 27, 2013
    1 reply
  • compare columns match and insert data from another column Closed

    Hello, have a sheet with following info A B C D E F G H I J date-sum-item percentage- date sum item now i need to match the date su...

    Mfrendo | Latest reply: TrowaD May 27, 2013
    16 replies
  • Daily attendance sheet that calculates monthly percentage Closed

    I am trying to design a daily attendance sheet that students sign in on via computer, but I need it to also have a column that shows their attendance ...

    jazzygirl77 | Latest reply: TrowaD May 27, 2013
    1 reply
  • conditional format Solved/Closed

    Dear reader, I was wondering if there is a possibility to specify the number of charakters in a conditional format in Excel. Example. NL08569638 ...

    boon1d | Latest reply: boon1d May 27, 2013
    2 replies
  • Comparing Data Closed

    I need to compare data in one column to that in multiple other columns to find missing data. Column "A" is static data, and can be entered into any ce...

    sointly | Latest reply: sointly May 26, 2013
    0 replies
  • excel Closed

    Within an entire excel sheet, I would like the entire row to turn into red font when I type the number 10 into any cell in column H. For example, ...

    Vikmanu | Latest reply: Vikmanu May 23, 2013
    0 replies
  • How to print data in multiple excel sheets Closed

    Dear All, I am new to excel coding. I need help regarding the below issue The below sub routine is the first sub routine. It gets the details fr...

    narayanpvg | Latest reply: narayanpvg May 22, 2013
    0 replies
  • Copying Excel Formula in different ranges Closed

    I want to copy a formula using different data ranges. The formula can't take dynamic range once copied. Example I want to use sumif formula from...

    Khurrum Iqbal | Latest reply: TrowaD May 21, 2013
    1 reply
  • Excel Macro - Selection of data from column using flag (0 or 1) Closed

    Hi, In Excel, I have a column of data and corresponding flags (either 0 or 1) in another column. I want to copy only those data which correspond ...

    Kunal Kumar | Latest reply: TrowaD May 21, 2013
    1 reply
  • convertion Number into word Solved/Closed

    Sir, How can convert Number into word in excel sheet. suppose there is 253900 in cell B2 in excel sheet. How can I convert this number as Two lakh ...

    Mathaiah | Latest reply: TrowaD May 21, 2013
    1 reply
  • 40 % add formula in excel cell Solved/Closed

    i want to increse 40% amount in my excel sheet and I have total quantity 90 can anyone like to tell me that how will I entre the 40% in excel cell tha...

    bvcds | Latest reply: TrowaD May 21, 2013
    1 reply

    Hi I have an excel sheet with blank rows every odd line (i.e rows 2,4,6,8...700 are empty). I have to paste a row of data (the same all the way th...

    MadLooni | Latest reply: TrowaD May 16, 2013
    1 reply
  • macro Solved/Closed

    Sub Macro1() ' ' Macro1 Macro ' Macro recorded 13/05/2013 by dhale ' ' Keyboard Shortcut: Ctrl+a ' Application.Goto Reference:="onecell" ...

    Phillip Kabala | Latest reply: TrowaD May 16, 2013
    6 replies
  • Multiple If Statement not returning numbers - returning words Closed

    Okay now I need the column to say if the amount in c18 is 500.00 then put 20.00, but if c18 is 38.46 then put 38.46. When I enter the formula below, ...

    Shaynajr | Latest reply: TrowaD May 14, 2013
    3 replies
  • How to find out two words matching with one additional Number Closed

    Hi.. Please tell me how to find out matching two words with only one differnce. If Two Columns of Excel contains Data like Vehcile Numbers MH01A123 an...

    Kolachana | Latest reply: TrowaD May 13, 2013
    1 reply
  • Greater than/Less than between 2 Dates Solved/Closed

    i am trying to to populate a spreadsheet that if the date is less than 01/01/2013 then populate the cell with $500.00, if the cell is equal to or grea...

    Shaynajr | Latest reply: TrowaD May 13, 2013
    3 replies
  • Macro to highlight cells. Solved/Closed

    I am very new to VBA and have spent countless hours looking for help on the web. I have a worksheet with 100,000 rows(locations) and 34 columns(Cha...

    steveo0707 | Latest reply: steveo0707 May 13, 2013
    2 replies
  • Lookup/Index data with multiple match Closed

    Hi, I am not an expert in excel but have some experience. Could some find me some excel formula or VBA code preferably for my data: 01/03/2013 C...

    Jason 22 | Latest reply: Jason 22 May 10, 2013
    2 replies
  • Macro to go into a series of Excel workbooks to make a change Closed

    Hi, I recently got some help to create a Macro to go into a series of workbooks saved in a certain forder to extract a range of information and creat...

    m_albges | Latest reply: m_albges May 9, 2013
    0 replies
  • Ms Excel found a problem and has to be finished Closed

    Hello, XP, Excel 2002 I have a data sheet with a Line-gragh and scroll bars (up/down) The scroll bar shut increase/decrease a cell value. Done b...

    juppkk | Latest reply: juppkk May 8, 2013
    5 replies

    Hi all, I need a set of 3 to 4 formulas which would show a monthly grow of accrued interest on each of the new amounts eg: formula 1:Month 1- 1...

    svdwest | Latest reply: svdwest May 8, 2013
    5 replies
  • Conditional Formatting VB Closed

    Hello, I wonder if you can help me please? I have an excel 2003 document which requires more than 3 conditional formats, i am using this piece of...

    nicola1987 | Latest reply: TrowaD May 7, 2013
    4 replies
  • Macro Closed

    Hello, I need to insert a multiple rows according to the count mentioned in column d. for example column A,B,C,D contains the data in Column D...

    Lalir | Latest reply: Zohaib R May 6, 2013
    5 replies
  • Excel Macro To Create New Worksheet Closed

    I have a invoice tracking spreadsheet, which I would like to update to highlight overdue payments in a new worksheet. I would like the spreadsheet to ...

    vikkitoria | Latest reply: Zohaib R May 6, 2013
    7 replies
  • How to work with empty cells in Excel Macro Closed

    Hello, I want to send email to list of users which are stored in Excel from A1 to A10. But if suppose if any of the cells from A1 to A10 is empty...

    navi | Latest reply: navi May 6, 2013
    0 replies
  • Inserting pictures into Excel based on file name Closed

    Hi, I found the below macro on another thread and used it successfully to insert pictures into Column A based on file names in Column B. Howeve...

    fantomvv | Latest reply: fantomvv May 6, 2013
    5 replies
  • Searching and copying Closed

    Hello, I am working on patent data and now I need a macro to transform the text to table. There are 30267 patent and it cannot be done by hand. One...

    sburmaoglu | Latest reply: rizvisa1 May 4, 2013
    1 reply
  • 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