Excel Forum

Ask a question
Results 4151 - 4200 of about 9,830
  • logging Closed

    I have a form that we have to manually insert data into. And I would like to log the data in a sperate workbook of list of 200 people. Logging it i...

    acastle | Latest reply: acastle Feb 4, 2015
    0 replies
  • copying info Closed

    Hello, How do I get information in one cell to two there sheets with out copy and paste. The info in the cells are the same on all three sheets bu...

    CDUB | Latest reply: CDUB Feb 4, 2015
    0 replies
  • If formula Closed

    This formula is killing me! I have a column of numbers E3:E12. These are dollar amounts of bills that have been paid. E13 contains the sum of t...

    Brandonw409 | Latest reply: pijaku Feb 4, 2015
    1 reply
  • details to another worksheet fr main worksheet using macro Closed

    Hi, I trying to input my project data into my Master list. When we won or lost the project, the data will auto disappear and transfer to the Won list ...

    kai1401 | Latest reply: kai1401 Feb 4, 2015
    0 replies
  • Date not showing up as a date??? Closed

    Hello, I have entered & formatted a column as a date but shows up as a 5 digit number. I followed your instructions and it still showing up as a 5 ...

    phaney | Latest reply: BrianGreen Feb 3, 2015
    5 replies
  • Ms. Closed

    working with several worksheets in one notebook, how do I get amounts from sheet 1 plus sheet 2 plus sheet 3 etc. to total to the final total sheet? ...

    4536057 | Latest reply: 4536057 Feb 3, 2015
    0 replies
  • Conditional Formating Closed

    I have several rows of data and a legend which needs to apply based on the mutiple values. The idea is that D1/D2 equals a % if that percentage is a...

    Mscrystal | Latest reply: xpcman Feb 3, 2015
    1 reply
  • Macros code Closed

    My excel depends on date column.... I have used macros to calculate all my required columns. So when I generate data for today or tomorrow I get on...

    Gokulcgs | Latest reply: TrowaD Feb 3, 2015
    10 replies
  • Macro for transferring data from one excel to different excel Closed

    Hi I need macro for transferring data from one excel to different excel. Here I want to transfer data from "Book" = "temp", "Sheets" = "auditreport...

    Gokul | Latest reply: venkat1926 Feb 3, 2015
    1 reply
  • Looking for help with a macro/vba for find/copy/paste Closed

    I have a lot of data in column A of a spread sheet. I would like to "search" for part of a string, and then copy the row of the cell with this data in...

    nsettlemire | Latest reply: RayH Feb 2, 2015
    7 replies
  • Enter current time in a cell by clicking it Closed

    Hello, I followed the instructions and it works great. My problem is how do you turn it off with out deleting the visual basic entry? AJ Co...

    AJ | Latest reply: RayH Feb 2, 2015
    1 reply
  • If function date problem Closed

    Hello, i am trying to use excel to give me two values depepnding if its a monday or a wednesday i have a date box so every week a person will pu...

    zombie_hunter | Latest reply: RayH Feb 2, 2015
    2 replies
  • Comparing two lists of names in Excel and then sorting them Closed

    Hello, I am wanting to compare two columns of information containing names from two different excel sheets. Names that do not appear on both list...

    atjays | Latest reply: TrowaD Feb 2, 2015
    1 reply
  • Can I accomplish this with Conditional Formatting or another way Closed

    Hello, I have two worksheets. I would like to enter values in a column of sheet 1. When any of those values match a value in a table on sheet 2, ...

    SD | Latest reply: TrowaD Feb 2, 2015
    1 reply
  • excel Closed

    Hello, I Want to change date format dd/mm/yyyy to dd.mm.yyyy in MS Excel 2003 Please solve my problem urgently

    anand | Latest reply: kieferschild Feb 2, 2015
    1 reply
  • removing false in excel Solved/Closed

    =IF(D5>=150000,D5*21/100,IF(D5>=100000,D5*15/100,IF(D5>=70000,D5*21/100,IF(D5>=50000,D5*7/1000)))) What,s wrong in this formula Please Help!

    umer007 | Latest reply: umer007 Feb 2, 2015
    2 replies
  • VBA UDF for Color Closed

    Hello, I'm sure my question is simple to most of you as I'm new to UDF. I've created the following UDF but cannot apply it across columns when I us...

    Debbie | Latest reply: Debbie Feb 1, 2015
    0 replies
  • Increment a cell value - conditions applied Solved/Closed

    Hello, I needed a formula to add a value to a cell when the cell next to it contains a value where that value is obtained by incrementing the value ...

    peweuk | Latest reply: peweuk Feb 1, 2015
    2 replies
  • Michelle Closed

    Hello, I am Having enormous difficulty with my MAC keyboard operating in Excel. I feel i must have put the scroll lock on but cannot find any ...

    Michelle | Latest reply: RayH Feb 1, 2015
    1 reply
  • want to copy sheet1 data to sheet2 Closed

    Hello, hi there i am just new to excel and iam trying to understand by praticing by own i want to copy sheet1 data to sheet2 when im typing in she...

    NASEER | Latest reply: vcoolio Jan 30, 2015
    1 reply
  • Apply a negative until 0 is reached in Excel Closed

    I am trying to create either a formula or a macro (which I do not know how to create) so that the following rule works: (1) If last row of data (ie c...

    kentster4 | Latest reply: RayH Jan 30, 2015
    3 replies
  • How to merge the data from 2 different sheets into 1? Closed

    I currently have 2 spreadsheets which show payments from 2 different companies. I'd like to be able to merge them into one spreadsheet which updates i...

    gcaorsiw | Latest reply: RayH Jan 30, 2015
    3 replies
  • Rating from Parameter Lookup Solved/Closed

    Hi.. I have some data that reference parameter to fill Rating in my excel sheet. The problem is those parameter are in Text Type. Here is the e...

    dxa02091 | Latest reply: dxa02091 Jan 30, 2015
    11 replies
  • Nesting if() functions? Solved/Closed

    Hey guys, I'm relatively new to Excel, so bear with me here. I'm making this spreadsheet to check if the payments of certain products are either la...

    gcaorsiw | Latest reply: pijaku Jan 29, 2015
    3 replies
  • Excel macro create new sheet copy & paste cells Closed

    Dear Sir I need help in a macro to create a new sheets with colum A name and copy row cells to the new sheet. Name Age Gender XX 25 M ...

    Matar | Latest reply: pijaku Jan 29, 2015
    1 reply
  • automiatic email Closed

    Hi all, I have used excel for years but never at an expert level. I am currently in a position where I need to view multiple tabs of data daily to...

    fpiechota | Latest reply: Ambucias Jan 28, 2015
    2 replies
  • transfer data Closed

    I am working on a spreadsheet and I need to transfer the ending balance on one page to beginning balance on another page, for the entire tenant list. ...

    LPOFF | Latest reply: LPOFF Jan 28, 2015
    0 replies
  • Copy data from one workbook to another workbook using vba Closed

    Hello, Good Afternoon, I need some help to be able to complete the below task. I need to be able to copy data for 2 different tabs in an wo...

    wooton | Latest reply: wooton Jan 28, 2015
    0 replies
  • HELP HELP HELP Excel Formula Closed

    Hello, I really need help trying to figure out this formula, as I have tried so many different formulas and can't seem to find one that works. I nee...

    PD | Latest reply: ArashMan Jan 27, 2015
    2 replies
  • Due Date Reminder With An Email to the filtered list Closed

    Hello, Here I have a filtered list from Master Sheet to DueReminder Sheet In which column I represents Email address Now my motive is to se...

    Babu546 | Latest reply: RayH Jan 27, 2015
    1 reply
  • Change date format using Excel Macro Closed

    Hello, In SAP BI I have created a BEx Query. We can see BEx reports in MS Excel. Date format in the report is DD/MM/YYYY and I want it to be displa...

    Harry | Latest reply: SUNIL Jan 27, 2015
    9 replies
  • Comparing Excel sheets with only a few overlapping records Closed

    Hello, I have two worksheets (1 & 2) that have different info, with not many duplicate records. I need to identify the duplicate records. I can ...

    lynn.frances | Latest reply: RayH Jan 26, 2015
    1 reply
  • Mtch formula required Closed

    Hello, In one column - A i have name for eg -Anuj Muchhala and another column B - Anuj & column C - Muchala - I want to know how to match maximum ...

    bans | Latest reply: RayH Jan 26, 2015
    1 reply
  • How to make a cell flash using Excel 2011 for Mac Closed

    Hello, I have Excel 2011 for Mac. Is it possible to make a cell flash using the Mac version of Excel 2011? If so, how is it done? I would apprec...

    Randall | Latest reply: RayH Jan 26, 2015
    1 reply
  • Find, copy, create a row under, paste, loop. Closed

    Hello, I would like to ask for a macro (as I was unfortunate to experiment with a lot of them and none of them worked as I'd like). What it sho...

    Dawid | Latest reply: Dawid Jan 26, 2015
    0 replies
  • Excel - Merge several worksheets into a single one Closed

    I use Excel to store information about several users and their cars information and have a different worksheet for each month. How to merge all these...

    jaja599 | Latest reply: jaja599 Jan 25, 2015
    0 replies
  • Replace cell content in Excel 2007 Closed

    Hello, I've two columns like below and i'd like to replace the one in 1st column with the one in column B in another table. Name_A Name_B Joe ...

    ymaher | Latest reply: RayH Jan 24, 2015
    1 reply
  • macros or vba for data validation Closed

    Hi, I have a data in sheet1 with ID, name ,area, amount,January amt,February amt.....(below month column particular dates are mentioned) Anybo...

    Johnzz | Latest reply: venkat1926 Jan 24, 2015
    1 reply
  • 1 time data entry Solved/Closed

    Hello, is there any way that make a condition for a cell which don't let to any body change the cell after they enter the date. i mean when i enter...

    ArashMan | Latest reply: ArashMan Jan 23, 2015
    14 replies
  • Add an X to cell if other conditions met Closed

    Hello, I've got a list of products for an e-commerce site. What I'm trying to do in Excel is flag any items that have a quantity of zero AND are i...

    lancert | Latest reply: RayH Jan 23, 2015
    5 replies
  • convert numbers to words in excel Closed

    please clarify my problem "convert numbers to words in excel"

    siddhardha | Latest reply: RayH Jan 23, 2015
    1 reply
  • mm/dd/yy AND dd/mm/yy AND mm-dd-yy AND dd-mm-yy in one column Closed

    Hello, I have the problem of having all the 4 date formats in the very same column: mm/dd/yyyy dd/mm/yyyy mm-dd-yyyy dd-mm-yyyy I would nee...

    Viktoria | Latest reply: RayH Jan 23, 2015
    5 replies
  • transferring data Closed

    Hello, Dear to whom it may concern, I want the data in sheet 1 to automatically export the data in sheet 3 and when the row is empty in sheet 1 th...

    leutrime | Latest reply: leutrime Jan 23, 2015
    0 replies
  • Replacing duplicates Closed

    Hello Trowa Sorry to bother you again but a problem has arisen. Everything was working OK until I tested "Pair names 4" Column Q. When I ran the code...

    whatsit | Latest reply: whatsit Jan 23, 2015
    1 reply
  • Notification popup every time a cell to change certain color. Closed

    Hello, my English is not good, so I'm using google translator, sorry about that. I am creating a spreadsheet where is the organizational chart of...

    rafao13 | Latest reply: rafao13 Jan 22, 2015
    0 replies

    Hello, I Have a problem in this code =INDEX(Master!$B$3:Master!$B$1067,MATCH(TODAY()+30,Master!$H$3:Master!$H$1067,0)) HERE I HAVE COLUM...

    Babu546 | Latest reply: Babu546 Jan 22, 2015
    5 replies
  • Compare two sheets and copy cell if match found. Closed

    Hi guys. I have two sheets and would like to compare sheet2 with data in sheet1 and copy a cell data from sheet1 to sheet2. Eg: SHEET1 A ...

    CJoubert | Latest reply: CJoubert Jan 22, 2015
    0 replies
  • Copying a row to another sheet with a trigger Closed

    Hi All, I was preparing an excel workbook, based on the sales pipeline. To simpify, The first sheet has company name and contact column. Titled "...

    Zav | Latest reply: TrowaD Jan 22, 2015
    1 reply
  • To create new sheet every time new information is added Closed

    I am currently creating a wage calculation template in excel. There are 3 sheets currently in my file. First is "employee information". Second is "emp...

    tuang | Latest reply: tuang Jan 22, 2015
    0 replies
  • Excel transfer of comments Closed

    from excel file to excel file, how can I get comments updated automatically, similar to vlookup or hlookup? i.e. comment in cell c4 of file abc.xls...

    j4lidas | Latest reply: j4lidas Jan 22, 2015
    0 replies