Excel Forum

Ask a question
Search
Close
Results 4101 - 4150 of about 9,830
  • Transferring data from one worksheet to another Closed

    Hello, I have a data dump where i need to run a macro which will segregate selected data to another worksheet: For e.g. Title Date/Time Resource...

    Anoymous | Latest reply: Anoymous Feb 17, 2015
    0 replies
  • Count a value change in cells Closed

    Hi, I'm trying to count how many times did 1 cell from a row has been changed from 1 to 0 and then back to 1, how many times did this form of change h...

    MindTwister | Latest reply: MindTwister Feb 16, 2015
    2 replies
  • Conditional Formatting based of another cell Closed

    Hello, I am attempting to do conditional formatting in Excel 2013. I am trying to make Cell C 3 turn red if cell 1 is 25% less or greater than cell...

    Delightful2k4 | Latest reply: TrowaD Feb 16, 2015
    1 reply
  • How to create a file in makro and copy a row from other makro Closed

    Hello, Please help me how to create a new excel file and copy data into this from other excel file. The new file filename will be a column.xls from ...

    Csongi | Latest reply: TrowaD Feb 16, 2015
    3 replies
  • Transferring Data from one spreadsheet to Another Closed

    Suppose i have a file name tan.xls and another file names rule.xls! then i want to copy all data in tan.xls file in cell D2 - D22 to rule.xls file in ...

    Alazeem | Latest reply: Computertech Feb 16, 2015
    1 reply
  • Conditional formatting help please Closed

    I need some help that could possibly save me a huge amount of time. I'm new to conditional formatting and am working on a new method to help my staff...

    lb_028 | Latest reply: vcoolio Feb 14, 2015
    1 reply
  • trfing data from master wks to another wks Closed

    Hi all...I would to get help from here as I trying to input my project data into my Master list. When we select won or lost under the status for proje...

    kai1401 | Latest reply: vcoolio Feb 14, 2015
    14 replies
  • replacing a field with value. Closed

    Hello, I hope someone could help me with this issue, i have a field TN1 and want to copy the one TN1 and replace the first TN1 with 375 and then rep...

    hogs | Latest reply: hogs Feb 13, 2015
    0 replies
  • Enter time in a column by click Closed

    I'm trying to enter the time in a column by clicking

    dbrumm | Latest reply: dbrumm Feb 13, 2015
    0 replies
  • If logical test value Closed

    Hello, I am trying to use a formula to only add the value of a certain cell (filled with a time unit)(A1), if the date mentionned cell (filled wit...

    Robert | Latest reply: Robert Feb 13, 2015
    0 replies
  • Compare two cells Closed

    Hello, I am looking for a formula that compares a number in a cell with another number in a different cell on the same spreadsheet and insert the sm...

    w1ll1am | Latest reply: w1ll1am Feb 12, 2015
    0 replies
  • COMPARISON OF TWO CELLS Closed

    Hello, I need a formula that compares two cells on the same page an inserts the smaller of the two into a third cell. Configuration: Mac OS X ...

    w1ll1am | Latest reply: w1ll1am Feb 12, 2015
    0 replies
  • populating a work sheet from excel based Closed

    Hello, I need your guidance please: I've got a tall order :) I hope you can help me! I am trying to have a new worksheet created from a templa...

    melissa | Latest reply: TrowaD Feb 12, 2015
    3 replies
  • Excel sheet automation need help Closed

    Hello, Dear Concern i am a new user of Microsoft excel. i need help from you. my case is below. in a excel file i have 4-5 sheets with same tab...

    Joni | Latest reply: Joni Feb 12, 2015
    0 replies
  • If Function using date ranges for Annual Quarters Closed

    I'm trying to make a formula that says If the start date falls within this quarter, Divide the Revenue by the POP (12 months) times either 1, 2 or 3 m...

    JohnnyhH | Latest reply: JohnnyhH Feb 11, 2015
    0 replies
  • Excel If Function using dates and calculating values Closed

    Hello, I'm trying populate sales by quarter with rows of business opportunities. I have a column for "Revenue" then a column for "number of Months"...

    JohnnyhH | Latest reply: JohnnyhH Feb 11, 2015
    0 replies
  • Automatic Transfer and Removal Closed

    Hello, My first post here. I have a spreadsheet that I am trying to get as automated as possible. What I am trying to do is have a line of 6 cells...

    evandaviscruz | Latest reply: evandaviscruz Feb 11, 2015
    0 replies
  • Copy an entire row n number of times EXCEL Closed

    Hi, I need a macro in EXCEL to repeat entire rows n number of times where n is in the row to be repeated. I have tried using answers already here b...

    Tom97836 | Latest reply: Tom97836 Feb 11, 2015
    0 replies
  • Pivot tables and ordering of dates Closed

    Hello, I have converted standard dates into just a month and year, using the formula I found on this site. I have also sorted my original table of...

    Simon | Latest reply: Simon Feb 11, 2015
    0 replies
  • Insert images in cells Closed

    Hello, Would anybody know how to change this macro https://ccm.net/faq/14170-excel-a-macro-to-insert-pictures-in-a-worksheet so that images are in...

    pepi1943 | Latest reply: ac3mark Feb 11, 2015
    1 reply
  • if cell has value copy to the next vba code Closed

    I'm searching a lot of forums but i cant find exact solution for this. my problem, i'm looking for a macro which will copy any cell in column A if th...

    zois27 | Latest reply: zois27 Feb 11, 2015
    0 replies
  • notification in excel Closed

    Hello, How can I get a notification or alert to remind me a an event , per date in cell, is date + 335 days?

    tch68 | Latest reply: tch68 Feb 11, 2015
    0 replies
  • Different Formulas Based Off of Font Colors Closed

    I have a cell with a date that the font color is either black or green. I need another cell to recognize the color and use a specific formula to calc...

    jpcedotal | Latest reply: jpcedotal Feb 11, 2015
    0 replies
  • Conditional formatting with range Solved/Closed

    Hello, I have a little bit of a problem, I want to mark a cell in a range that is equal to another cell in different range, I can't figure it out....

    MindTwister | Latest reply: MindTwister Feb 10, 2015
    2 replies
  • If formula using dates Closed

    I have a spread sheet using projected dates for next training. I'd like to run an "if" formula that would fill the cell red when dates are past due (...

    Trainer2010 | Latest reply: Trainer2010 Feb 10, 2015
    0 replies
  • Macro for copying 1st 4 rows from 1 worksheet to other worksheet Closed

    Hello, I have a set of agencies and each agency having a spreadsheet with some details. Every time the 1st four rows are copied and pasted in new...

    naga | Latest reply: naga Feb 10, 2015
    0 replies
  • IF/OR Formula Solved/Closed

    Help please I need to look up a cell and if it =1 return 1, =2 return 0.6, =3 return 0.4, = 4 return 0.2, if >4 return 0.0 for example A B ...

    ad1959 | Latest reply: vcoolio Feb 10, 2015
    3 replies
  • Copy Data from Main sheet to another Sheet Closed

    Hello, I have a document that has a quote on the first sheet. What I want to do is if the code in column C meets a certain criteria, it will auto...

    mayi1986 | Latest reply: venkat1926 Feb 10, 2015
    1 reply
  • Conditional formatting Closed

    Conditional format A2 if either H2 or I2 is not blank.

    dkheiler | Latest reply: dkheiler Feb 9, 2015
    0 replies
  • Partial Match two columns of Data Closed

    Hello, So I have a Column with the MPN and then another column with the Image location. The image contains the MPN as well as info, but the image c...

    Paige | Latest reply: Paige Feb 9, 2015
    0 replies
  • display value in a cell A7 which is refered to the value in A6 Closed

    Hello, I want to display value in a cell A7 which is refered to the value in A6 which shows the average of A1:A5 and the value of A6 satisfies the...

    lokesh | Latest reply: TrowaD Feb 9, 2015
    1 reply
  • Script Closed

    Hi Joe here, Sheet 1 Data A B 1001 HE 1002 SHE 1003 HIS 1004 HERS When I type t...

    jotowill | Latest reply: TrowaD Feb 9, 2015
    1 reply
  • How to save a data excel to non data spreadsheets to excel Closed

    Hello, I have a question? How to save a data excel to non data spreadsheets to excel Configuration: iPad / Safari 8.0

    Nikkie | Latest reply: RayH Feb 9, 2015
    1 reply
  • Excel, changed format Tue, 11 Nov 2014 08:14:09" to dd/mm/yyyy Closed

    Hello, I'm looking to convert the following excel format of "Tue, 11 Nov 2014 08:14:09" to dd/mm/yyyy. Thanks in advance for your answers. j...

    jtijerino | Latest reply: venkat1926 Feb 9, 2015
    1 reply
  • Identify same values in Column A Closed

    Hello, I have an excel sheet with too many rows. But in Column A, I have many values which starts with XYZ. I have to identify them and need to use...

    Dali | Latest reply: venkat1926 Feb 9, 2015
    1 reply
  • Inserting different photos into cells- macro Closed

    Hi, I am not a super savvy programmer, but looking for a Macro that might automate inserting a photo (so user selects image) and then re-sizing the ph...

    darcyjane | Latest reply: RayH Feb 8, 2015
    1 reply
  • how we can convert number to word in excel Closed

    how we can convert number to word in excel?

    chamak77 | Latest reply: RayH Feb 7, 2015
    1 reply
  • Need to create a macro Closed

    i have no clue on how to create a macro.i need to copy all items in sheet 1 rows to columns in sheet 2 every time its updated. sheet one will change ...

    bettyjk | Latest reply: vcoolio Feb 6, 2015
    2 replies
  • Shape not showing Text in excel Closed

    I moke a shape in excel I wrote text in shape but when I click on another cell the text disappears. Please Help!

    umer007 | Latest reply: RayH Feb 6, 2015
    1 reply
  • If Function Closed

    Hello, I'm having a bit of a trouble working the If Function in excel. Here's my problem: My manager asked me to find the commission fees to cha...

    Jen | Latest reply: vcoolio Feb 6, 2015
    1 reply
  • Number that turns in to date. Closed

    Hello, hi I'm Nokuthula. I want to ask why when I try to put a number it turn and become a date. Why is that ? Configuration: Windows 7 / C...

    Zet | Latest reply: vcoolio Feb 6, 2015
    1 reply
  • How to repeat a row 4 times, while increasing sequence Solved/Closed

    Hello all, I need help on the best way to repeat this 4 times, and then increase the number at the end. I need this: Column A AAA_BBB_0002135 ...

    Stumped.. | Latest reply: OldCoder Feb 6, 2015
    2 replies
  • Using one cell to refer to many Closed

    Hello, I'm trying to do something I'm not sure is possible. I have a spreadsheet to keep track of receipts and group items by category. In one column ...

    Underwater | Latest reply: Underwater Feb 5, 2015
    2 replies
  • Creating a task reminder for all tasks for that day Closed

    I'm hoping someone will be able to help me. I need to attempt to create a task reminder pop up that will list all tasks that need to be done today. An...

    mhurd | Latest reply: mhurd Feb 5, 2015
    4 replies
  • Converting rows of data in notepad to columns Solved/Closed

    Hello, Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains firs...

    Need help | Latest reply: Philgood_FR Feb 5, 2015
    2 replies
  • Excel Closed

    Hello, How to copy data from one sheet in a row containing formulas to another sheet in a column but not in a row still have the same data with it...

    Popo | Latest reply: TrowaD Feb 5, 2015
    1 reply
  • conditionally copy columns Solved/Closed

    Hello, I have a table with thousands of rows of text. Column B has errors in the data which I have fixed in column C (has many blank cells). I would l...

    GMHerbs | Latest reply: GMHerbs Feb 4, 2015
    2 replies
  • convert Nov-11-2014 to dd/mm/yyyy in Excel Closed

    Hello, I need assistance, Need to convert the following date of "Nov-11-2014" to dd/mm/yyyy Configuration: Windows 7 / Firefox 35.0

    jtijerino | Latest reply: jtijerino Feb 4, 2015
    0 replies
  • find word on Sheet1 move all adjacent column values to sheet2 Closed

    Hello, I have a list of accounts and information on items inside the accounts along with the account owner. It goes like this, A= account number, B...

    feeders | Latest reply: feeders Feb 4, 2015
    1 reply
  • Change a range dynamically - VBA script. Solved/Closed

    Hi everyone. I am stuck on a small problem with writing a Macro in Excel and would appreciate some help. I have the following script: For...

    BrianGreen | Latest reply: BrianGreen Feb 4, 2015
    5 replies