Excel Forum

Ask a question
Search
Close
Results 3901 - 3950 of about 9,830
  • adding one day to a date Closed

    Hello, I have a spreadsheet that i use for planning truck maintenace, I am trying to work out how to have 2 buttons that i can assign 2 macrows too,...

    tripped | Latest reply: tripped Apr 1, 2015
    1 reply
  • Copy Excel Data present in common location to excel Closed

    Just a beginner with macro... no experience at all... Here is my problem... I have some excel sheets placed in a common folder in my local disk. Th...

    krish7 | Latest reply: krish7 Apr 1, 2015
    0 replies
  • How to copy data from one worksheet to another Closed

    Hello, I'm having the following problem, I have made a file with two active worksheets. Now I would like to copy the totals from worksheet1 into...

    Donj01 | Latest reply: Donj01 Apr 1, 2015
    0 replies
  • with the help of name we can get the data one sheet to another Closed

    Hello, with the help of name we can get the data one sheet to another sheet in excel in pdf Configuration: Windows XP / Firefox 12.0

    naveen | Latest reply: TrowaD Mar 31, 2015
    1 reply
  • Please help, COUNTA AND COUNTIF SAME FORMULA Closed

    Hello, Please help me, I am trying to accomplish is this: I would like to count the text in Range (B1:b5) excluding duplicates, however only i...

    stephmbingham | Latest reply: TrowaD Mar 31, 2015
    1 reply
  • click on an item and it copies it to another separate workbook Closed

    Hi there, I have two catalogues that I have to use to purchase equipment, They are on different workbooks. To save time I was wondering if there w...

    maggot30 | Latest reply: maggot30 Mar 30, 2015
    0 replies
  • Merging excel files into one file Closed

    Hello, at first, sorry for my bad English, I hope everything is understandable. I need a macro for excel that will copy rows from a few spreads...

    marco | Latest reply: marco Mar 30, 2015
    0 replies
  • Autogenerate worksheets from a list of names... Adding names? Closed

    Hi, I'm trying to auto-generate worksheet from a list of names. Reading other questions in the forum I found the solution for this questions. But I ...

    Juliza | Latest reply: TrowaD Mar 30, 2015
    1 reply
  • Not showing Save as dialogue box. Closed

    I am an office assistant. Every time I have to spell the numbers in words. I got a solution from net that a function can be added to the function libr...

    Sanjib | Latest reply: TrowaD Mar 30, 2015
    1 reply
  • Copy multiple workbooks to another workbook on a specific row Closed

    Hi Guys, The below VBA code helps me to import all the workbooks from the specified path to the current workbook. The code works perfectly Ho...

    roshanjohn | Latest reply: roshanjohn Mar 30, 2015
    0 replies
  • set cell value Solved/Closed

    Hello, how to create formula for: if AI=1, B1=2 than show C1= 25....... if A1=1 B1=3 than show C1=28........ if A1=5 B1=5 than show C!=32.... ...

    Jaspinder | Latest reply: MaxStart Mar 28, 2015
    1 reply
  • VBA Copy sheet to new Excel File + automated manual data entry Solved/Closed

    Configuration: Windows 7 / Firefox 35.0 Dears, I hope this is not a to extensive VBA script request and this is the place to ask. I need to cre...

    Sib | Latest reply: MaxStart Mar 28, 2015
    4 replies
  • how find out similar book name from the list Closed

    Hello, I have a catalog in xlsx format in which there are many book name which are similar to each other i want to find out the book names which s...

    kalpaz | Latest reply: kalpaz Mar 28, 2015
    0 replies
  • How to transfer a block of data between to workbook Closed

    Dear Sir, Please help me how to transfer block of data between two workbooks. Thanks in advance

    PSV | Latest reply: PSV Mar 28, 2015
    0 replies
  • macro to merge multiple files to one for selected column only Closed

    Hi, I have hundreds of excel files that I want to combine into one file. The problem is that these files contain hundreds of columns of extra data th...

    jp_hi | Latest reply: jp_hi Mar 28, 2015
    0 replies
  • add new data from another workbook in excel vba Closed

    Hi All, I have a problem with excel vba as below that need your help: I have 2 workbook (wb1, wb2). What I want is to loop through data in collu...

    nhan1411 | Latest reply: nhan1411 Mar 27, 2015
    0 replies
  • Conditional Formatting a cell based on an entire row. Closed

    I'm trying to set up a sheet where I have field names in column A, rows 2-20, and dates in row 1 from column B to CD. This format works great for wha...

    Nick | Latest reply: Nick Mar 27, 2015
    0 replies
  • excel formula Solved/Closed

    hello, hope you can help! working on an excel spreadsheet and require a formula: If cell a > 0 then cell b should equal the value in cell c thanks ...

    Nic | Latest reply: Nic Mar 27, 2015
    4 replies
  • COUNTA and COUNTIF IN SAME FORMULA Closed

    So what I am trying to accomplish is this: I want to count the text in Range (B1:b5) excluding duplicates, however only if the text in range(a1:a5...

    stephmbingham | Latest reply: stephmbingham Mar 26, 2015
    0 replies
  • I need a macro that can extract data Closed

    Hello, I need help with creating a macro that can automatically copy data from different worksheets and put it into a master worksheet for a repor...

    excelmwangi | Latest reply: vcoolio Mar 26, 2015
    26 replies
  • Formula to extract data if found in another cel Closed

    Hello, I have a large excel spreadsheet and need a formula that can extract data from one cell if that same data is found in another cell. So, for...

    kristenstrouse | Latest reply: kristenstrouse Mar 26, 2015
    0 replies
  • Code Visual Basic Solved/Closed

    Hello, I've been unable to copy data from one sheet to another, based on selecting multiple criteria. I've been able to use the string below t...

    mcculloch1dj | Latest reply: mcculloch1dj Mar 26, 2015
    2 replies
  • Copy multiple rows depending on value of cell. Closed

    Hello, I'm working on a excel-book where it is 3 sheets of data. In the 3rd sheet I want to be able to type in e.g. Ior and then get all the rows ...

    SAØASG | Latest reply: SAØASG Mar 26, 2015
    0 replies
  • compare range of cells and get the result of a third cell Closed

    Hello, i have a file with 3 columns, i need to compare each cell of the first 2 columns and of it match print the data that in the third column th...

    mcpcmcpc | Latest reply: TrowaD Mar 26, 2015
    1 reply
  • Copying a Conditional Format to other cells... Closed

    Hello, I have set a formula to calculate how many days between two dates i.e. Date in A5 - date in A4 +1 = number of days in A6. Pretty simple ok....

    Dom | Latest reply: TrowaD Mar 26, 2015
    1 reply
  • Excel Formula Display in Cell Solved/Closed

    Hello, Apologize if the question is too stupid. In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to display the formula in cell A6 for this...

    eltonlaw | Latest reply: rc Mar 25, 2015
    6 replies
  • Deadline alert Closed

    Hello, I would like to change the colour of a date cell (target date) to yellow when it is 3 days away from the target date and remain yellow only u...

    Demo man | Latest reply: Demo man Mar 25, 2015
    0 replies
  • Copy multi data (range) from a set of excel files inside a folde Closed

    Hello, It's my first post in this forum after a lot of visits that i`ve done in the past and really helped me a lot. Well the situation is this: ...

    gzaxar | Latest reply: gzaxar Mar 25, 2015
    0 replies
  • Day of week and date in same cell, autofill rest of month? Closed

    Hello, Is it possible to put day of week and date in the same cell in Excel 2004, and then autofill down for the rest of the month? I have tried ...

    zinnia | Latest reply: venkat1926 Mar 25, 2015
    1 reply
  • categorise my customers into C0,C1,C2,C3 based upon there last s Closed

    Hello, i want to categorise my customers into C0,C1,C2,C3 based upon there last service date & Date of Delivery. C0 are the customers who are not ...

    rajan adepu | Latest reply: rajan adepu Mar 25, 2015
    0 replies
  • Visual Basic Closed

    I've been able to use the string below to copy rows to sheet 2 by selecting value ("5064") in Column G, sheet 1. I need to select more than one value...

    mcculloch1dj | Latest reply: mcculloch1dj Mar 25, 2015
    0 replies
  • Macro code to copy and past in new sheet last row of data Closed

    Hello, I'm trying to write a simple macro to copy in one sheet a selected amount of column data (which varies by size each time) and then paste the...

    Arg | Latest reply: vcoolio Mar 24, 2015
    1 reply
  • Formula to find/replace if same data is contained in another cel Closed

    I have a large excel spreadsheet and need a formula that can extract data from one cell if that same data is found in another cell. So, for example: ...

    kristenstrouse | Latest reply: kristenstrouse Mar 24, 2015
    0 replies
  • Convert to mm/dd/yy to dd/mm/yyy Closed

    Hello, Pls help how to change mm/dd/yyy to dd/mm/yy in excel. Configuration: Windows / Chrome 41.0.2272.101

    Ravindra | Latest reply: TrowaD Mar 24, 2015
    1 reply
  • Day of week and date in the same cell, then autofill rest of mon Closed

    Hello, I would like to know how to put the weekday and date into one cell, as in: Wednesday, 4/1. Then I want autofill to fill the rest of ...

    zinnia | Latest reply: TrowaD Mar 24, 2015
    1 reply
  • Find and replace a specific number Closed

    Hi All, I am new to this, so I hope somebody can help. I have a code CF|0612|1-12 in cell A1. That code is the code for an apartment block we...

    phill4356 | Latest reply: TrowaD Mar 24, 2015
    1 reply
  • Macro for Extracting Data Closed

    I need helping writing a macro to extract data from column A and input into column B. Example data = 13A:123456789:V1 and what I need is the data betw...

    MHerren | Latest reply: TrowaD Mar 24, 2015
    1 reply
  • cell color Closed

    Hello, I have a worksheet with various dollar values in it. I want to write a formula to add all the cells that are a certain color (green or yel...

    Doc1772 | Latest reply: TrowaD Mar 24, 2015
    1 reply
  • Some cell Date Could not change Solved/Closed

    Hello, I was having the same problem and this solution worked But Some cell Date Could not change Configuration: Windows XP / Firefox 36.0

    Muhammad Afzal | Latest reply: TrowaD Mar 24, 2015
    1 reply
  • Pop-Up Closed

    Hello, I want to know, how to set Pop-Up in excel, Suppose I will have make on payment on 30th March 15 so pop-up will alert me on 28th March 1...

    SUNIL BK | Latest reply: SUNIL BK Mar 24, 2015
    0 replies
  • Use information in one excel to update another Closed

    Hello, I am trying to track batches being completed. We have different process steps. When these are finished, this is updated in individual excel...

    Grainne | Latest reply: Grainne Mar 24, 2015
    0 replies
  • Comparing data in 3 columns on a Microsoft Excel spreadsheet Solved/Closed

    Would be really grateful for some help. I have 3 columns of different lengths with email addresses in them and I want to see all instances where th...

    daniz39 | Latest reply: daniz39 Mar 23, 2015
    2 replies
  • formula which calculates the percentage of these cells Closed

    I was wondering if anyone could help me with a formula for some work I am currently doing. I have a set of data (numbers ranging from -0.8 to + 0.7) w...

    Lucy | Latest reply: TrowaD Mar 23, 2015
    1 reply
  • Macro VB for Reconciliation Closed

    Is it possible to write an excel macro that can do a simple recon for me, I intend to do as described below: If information in a selected column i...

    oyeski | Latest reply: oyeski Mar 23, 2015
    0 replies
  • Excel 2013 Formula - maybe IF formula? Solved/Closed

    I have a list of names in Excel and I need to put their supervisor name in the cell to the right of each name. I would like to find a formula that wi...

    Cookie5 | Latest reply: Cookie5 Mar 23, 2015
    2 replies
  • Copying Data based on number from one sheet to another Closed

    Hello, I would really like a VBA CODE which would help me to copy Data based on number from one sheet to another: So I have 5 projects(sheet1,s...

    Aivaras | Latest reply: MaxStart Mar 21, 2015
    1 reply
  • Call Equation According to choice Closed

    Hello, When choosing from a data validation list, i want some cells to import specified equations according to the choice selected from the list ...

    Diver | Latest reply: MaxStart Mar 21, 2015
    1 reply
  • compare sheet 1 and 2 and copy to sheet 3 Closed

    Hi, I got this code which compare sheet 1 and 2 and copy to sheet 3 data with similar data from 1 and 2. Now what i need is to cell from sheet 2 t...

    Pat | Latest reply: venkat1926 Mar 21, 2015
    1 reply
  • Date Formulas Closed

    I am wanting to know how to make a copy of the same spreadsheet many times and when I do I want the date on the spreadsheet to change automatically ea...

    Laura | Latest reply: Laura Mar 21, 2015
    4 replies
  • Need Help in Excel Closed

    Hello, I have sheet which have 100 records of students obtained marks and I want top 20 students list on another sheet. Configuration: Windows ...

    fidamj | Latest reply: fidamj Mar 20, 2015
    0 replies