Excel Forum

Ask a question
Search
Close
Results 4301 - 4350 of about 9,830
  • Excel - To generate unique ID Solved

    Hello, Good day. I would like to generate a unique ID from date and a customer number field. I tried this way but it was not working as desired. Bel...

    wliang | Latest reply: ferg Jan 1, 2015
    4 replies
  • decrease the value first by 10% and then increase the value by 5 Closed

    I want to decrease the value first by 10% and then increase the value by 5%. What is the formula in Ms excel.

    chandansufi | Latest reply: chandan Jan 1, 2015
    2 replies
  • I need a macro please Solved/Closed

    Hello, 1 spreadsheet has 15 columns of data with column A having the unique identifier 2 spreadsheet has 37 columns of data with column B havin...

    rjbuer | Latest reply: rjbuer Dec 31, 2014
    7 replies
  • trying to base format on date in cells Closed

    Good morning all, I have a worksheet that formats the cell containing the last date an item was issued when it is within 30, 60 or 90 days of ...

    kubi1and | Latest reply: kubi1and Dec 31, 2014
    0 replies
  • Want to add to Excel Macro, unsure how to do what I want Closed

    Hello, I have the following Excel Macro that counts the amount of times a specific campaign value is present in a column. I would like to add on to th...

    kapperson | Latest reply: kapperson Dec 31, 2014
    0 replies
  • Excel using date range and formula on separate sheets Closed

    I'm creating a bank register with the dates in column A. Values are in columns C and D. The title of my first page is 'Register' What I'm trying ...

    Action | Latest reply: vcoolio Dec 31, 2014
    1 reply
  • Copy daily cost entries into the particular ledgers Solved/Closed

    Hello, I want to copy the daily cost entires into the particular ledgers, which i put in different sheets. Ex: I have the following data: D...

    shanthich | Latest reply: vcoolio Dec 31, 2014
    6 replies
  • Brijesh Parmar Closed

    Hello, how to count job dates for in column if dates are repeated. report no Date 5462 21.12.14 5463 22.12.14 10134 21.12.14 20354 22.12.14...

    Brijesh | Latest reply: Brijesh Dec 31, 2014
    0 replies
  • Need MSExcel 2007 Formula Closed

    Hello, Masters of Excel. I need formula like H5+I5+J5+K5+L5+M5+N5-O5=P5. I need H5 to N5 add & subrtact O5 in P5. Hope i have detailed this brief. T...

    ishfaq90 | Latest reply: vcoolio Dec 31, 2014
    3 replies
  • Change General data into date format Closed

    Hello, I have a date format in excel like 28/04/2014 00:00:00. I am unable to convert into date format. if i enter formula like date(A1) it is s...

    GSM | Latest reply: GSM Dec 31, 2014
    0 replies
  • Excel cell equal another cell only if its a certain percentage Closed

    Hello, I'm trying to have a cell equal another cell only if its a certain percentage (percentages are in another cell also, I tried "IFSUM" but its ...

    Matt | Latest reply: vcoolio Dec 30, 2014
    6 replies
  • Excel 2010 format rows with a related cells rule based formattin Closed

    I have a worksheet that formats the cell containing the last date an item was issued when it is within 30, 60 or 90 days of the annual issue date. Ho...

    kubi1and | Latest reply: kubi1and Dec 30, 2014
    0 replies
  • I need help, a macro that will filter, copy, and then paste. Closed

    Hello, Hi there, thank you for opening this. I really need some help. I began working at a hotel and lets just say that they need some help. I've ...

    Unforgiven12311 | Latest reply: Unforgiven12311 Dec 30, 2014
    0 replies
  • A macro to copy data into new worksheets Closed

    Hello, I am looking to write a macro to copy information in rows, and paste them into new worksheets by columns e.g DataSheet: Name¦ Country¦ City...

    dnick94 | Latest reply: dnick94 Dec 30, 2014
    0 replies
  • Lock a Cell in conditional formatting Closed

    Hello, is that possible to lock a cell in conditional formatting. for example: if B4=END then lock A4 Cell thank you it will helps.

    ArashMan | Latest reply: ArashMan Dec 30, 2014
    0 replies
  • Excel Macro for gathering data at one place Closed

    Hello, I want to make a marco that copies the data from no. of workbooks which also contain no. of worksheets and gather all that data in one work...

    Rai | Latest reply: Rai Dec 30, 2014
    0 replies
  • date Entry Solved/Closed

    Hello, i have an Excel sheet which my colleague should enter the date after he finished his job, for example:\today date is 2014/28/12 he shou...

    ArashMan | Latest reply: ArashMan Dec 30, 2014
    2 replies
  • How to Lock or password protected specific cell in excel 2010 Solved/Closed

    Dear all: Hope you are fine. How can I Lock a specific cell of excel 2010 that any one can not change or input anything in that cell. Pleas...

    Biswajit-Shaha | Latest reply: Biswajit-Shaha Dec 30, 2014
    4 replies
  • Checking Cell Value against a Range of Numbers Closed

    Hello, I want to check a cell's value and if it falls in a particular range then I want to write "OK" in some other cell and if it falls out of sp...

    Maverick81 | Latest reply: shanthich Dec 29, 2014
    1 reply
  • Help with macro in excel Closed

    Hi I need some help in writing a macro for the below: 1. In sheet 1, I have column A with a list of items and many of them will be repetitive, ...

    excelwip | Latest reply: venkat1926 Dec 29, 2014
    1 reply
  • date change in excel sheet Closed

    Hello, in excel sheet date come to 29/12/2014 now i wants date on 29/12/14. so help me how to change date format or use formula to change date fr...

    chandresh | Latest reply: venkat1926 Dec 29, 2014
    1 reply
  • Compare excel data Closed

    Hello, In excel i have say the following coordinate data: 2792691.388 215476.765 423.165 2792691.388 215526.765 423.045 2792691.388 215576.765 ...

    zaidshb | Latest reply: venkat1926 Dec 29, 2014
    1 reply
  • Excel macro to format report Solved/Closed

    Hi everyone, I am new to this forum..........so new I've already typed my question, then clicked "ask your question" again instead of submit..........

    LaurenM | Latest reply: ramu sanga Dec 29, 2014
    7 replies
  • Excel function I cant figure out Closed

    Hello, is this possible below? so A2 & A4 are the numbers I want ti time by 50% and only if B2 & B4 are equal or greater then 54%, so row "A" should e...

    Matt | Latest reply: Matt Dec 28, 2014
    0 replies
  • Excel File is corrupt. Closed

    I hope one of the experts here will be able to save the files, which are very necessary for my work. My excel file became corrupt for very obvious rea...

    HawkinYellow | Latest reply: NikkiTum Dec 27, 2014
    2 replies
  • how to format a cell based on date in another cell. Closed

    Hello, i.e. We want to format B1 based on date in A1. ( If date in B1 is 2 or more days higher from the date in A1, then B1 must get colored. This...

    Abhi | Latest reply: Mazzaropi Dec 26, 2014
    1 reply
  • look through each sheet and copy and paste to another workbook Closed

    Hello, Dear Sir Would you know how to copy from row 2 to row 20,000 in sheet 1 to sheet 10 in one workbook and paste to corresponding sheet 1 t...

    Wen | Latest reply: Wen Dec 25, 2014
    0 replies
  • Conditional Formatting importing data from website into Cell A1 Closed

    Hi I am importing data from a website into Cell A1. The data is a numerical value. I want the Cell's background colour to change depending o...

    Mac | Latest reply: Mac Dec 24, 2014
    0 replies
  • How to Create a Dependent Dropdown List in Excel Closed

    Dependent dropdown list is something that keeps-on changing its items based on a change in the value of another dropdown. Execute the following st...

    krishnap2w2 | Latest reply: krishnap2w2 Dec 24, 2014
    0 replies
  • dropdowns in excel Closed

    There are multiple ways in which you can create a dropdown list in Excel. Data Validation Form Control (Combo Box) ActiveX Control (Combo Box) But...

    krishnap2w2 | Latest reply: TrowaD Dec 23, 2014
    1 reply
  • Conditional formatting based on dates Closed

    Massive long shot here.....I'm trying to conditionally format certain cells to black out after the end of a certain month. It is for a monthly time...

    Arwalder | Latest reply: TrowaD Dec 23, 2014
    1 reply
  • move completed data in sheet 2 Closed

    Hello, I have raw data in sheet 1. I need to move completed data in sheet 2. I m using column H to update work status as "completed or pending". Pls...

    anil 88 | Latest reply: TrowaD Dec 23, 2014
    1 reply
  • Excel VBA - Color Code Column cells based on values Closed

    Hi, Super new to VBA, and need to write code to evaluate the values in Column I, starting with I3 and going down a varying number of rows depending...

    jdmurphy | Latest reply: TrowaD Dec 23, 2014
    1 reply
  • How do I change the format "YY/MM/DD" to show as "MM/DD/YY"? Closed

    Hello, I have a spreadsheet that I need to convert the date fields from the format "YY/MM/DD" to read as "MM/DD/YY". For example, if the field c...

    Guest3309 | Latest reply: Mazzaropi Dec 22, 2014
    2 replies
  • Need to write a macro to copy a row of information if true Solved/Closed

    Hi, I have a workbook with several tabs and I want to first check if Column F on the first sheet contains 13 as the year (12/16/13 is the format) and...

    lrjupiter | Latest reply: vcoolio Dec 22, 2014
    7 replies
  • VLookup Closed

    Hello, I have a spreadsheet with column headings, Project Manager, Project Cost Engineer, and Project Schedule Representative. Once I key in th...

    lrjupiter | Latest reply: lrjupiter Dec 22, 2014
    0 replies
  • VBA cut/paste in another tab Closed

    Dear all, I'm trying to copy in a different tab all rows that indicate in column [AN] a value less to or equal to 12. However, this column, as i...

    Lyriste | Latest reply: TrowaD Dec 22, 2014
    1 reply
  • Transfer Data from a sheet to another many sheets Closed

    Hello, I am trying to transfer data from one sheet to many other sheets . For example , when I write data to a row , I woul...

    polybag3 | Latest reply: TrowaD Dec 22, 2014
    10 replies
  • every time copy and paste to master excel sheet one by one Closed

    Good morning, Am working at Food Product Company in Quality Section . i received so many mails from depot Product complaint details in excel sheet...

    krshna.mk24 | Latest reply: krshna.mk24 Dec 20, 2014
    0 replies
  • Assistance with Excel macros Closed

    Greetings all My company uses Excel to track inspections and maintenance of portable fire extinguishers and I'm trying to add some functionality to...

    xOgrex | Latest reply: RayH Dec 19, 2014
    1 reply
  • Automatic duplication of info to sheet 2 for ordering form Closed

    Hello, Configuration: Windows 7 / Chrome 39.0.2171.95 I'd like to know if anyone on this board could help me or direct me to where I can fi...

    Pierre | Latest reply: Pierre Dec 19, 2014
    0 replies
  • Text label and value if value in other worksheet is > 0 Closed

    can anyone help me with a formula for this. Text label and value, if value in other worksheet from 2 different cells is > 0, label based on witch c...

    fixradio | Latest reply: fixradio Dec 19, 2014
    0 replies
  • Conditional Formatting a row from a validation list Closed

    Hello, OK, I am trying to apply a conditional format to a worksheet whereas I have a validation list in a column at the end of the row of data. Ba...

    Todd | Latest reply: Mazzaropi Dec 19, 2014
    1 reply
  • Excel-Macro to sumup data from multiple workbooks to Master xlsx Closed

    Hi All, Can you please help me. Scenario: 1. There is a common template which has some tasks listed in columns against which the team members wil...

    Unokashi | Latest reply: Unokashi Dec 19, 2014
    2 replies
  • VBA help! Closed

    Hello, I am absolutely a novice when it comes to macros and VBA and need some help. I have a workbook with 6 worksheets. The first work sheet ("Al...

    amandashipp | Latest reply: vcoolio Dec 18, 2014
    2 replies
  • Using a Macro to copy & Paste from one sheet to another. Solved/Closed

    Hello, Hi Guy's I hope you can help, I am using two sheets. one is spread across different rows so when I click create list it copies everything ...

    Marksman702 | Latest reply: vcoolio Dec 18, 2014
    8 replies
  • excel formula numbers to dates Solved/Closed

    Hi, I need an excel formula for changing numbers to dates. It is part of the Julian Calendar but backwards and one extra number. Ex. 273143 is 9/...

    ah2jh1sh2 | Latest reply: ah2jh1sh2 Dec 18, 2014
    6 replies
  • how to use releative refrences in conditional formating?? Solved/Closed

    the first picture is the formatting rule of C7 cell the second picture is the formatting rule of E7 cell which i copy from C7. as you c...

    ArashMan | Latest reply: Mazzaropi Dec 18, 2014
    8 replies
  • Transferring Data From A Excel Workbook to Another Automatically Closed

    Hi There, I'm fairly new at macros and I would like to write a code that will help me transfer data from a workbook to another. I update Workbook 1...

    Legacy1990 | Latest reply: Legacy1990 Dec 18, 2014
    2 replies
  • Conditional formatting based on another cell Solved/Closed

    Hello, this is what I want: EXAMPLE: B3= Arash if B6=1 then B3 goes red if B6=2 then B3 Goes yellow and if B6=3 then B3 goes green i want to...

    ArashMan | Latest reply: ArashMan Dec 17, 2014
    2 replies