Excel Forum

Ask a question
Search
Close
Results 2101 - 2150 of about 9,840
  • Excel - A Macro to move data from rows to columns Closed

    Excel - A Macro to move data from rows to columns Thanks to Venkat1926 for this tip! This Macro is working well for me, but with the exception of...

    yvonlet | Latest reply: TrowaD Aug 30, 2016
    3 replies
  • Macro to repeat x amount of times - next row Closed

    I'm trying to wrote a macro which writes a csv from lines of data. Currently it roughly runs: Copy B3:L3 Paste in A2 (new page) Copy A22 Paste i...

    MWILKINSON | Latest reply: MWILKINSON Aug 30, 2016
    0 replies
  • copy data of 1 sheet to another if criteria matched Closed

    Hello, 1 have 3 sheet master, damage & shortage. in master sheet if i enter in n column damage then full row should be copied in sheet damage also...

    preeti | Latest reply: vcoolio Aug 30, 2016
    3 replies
  • Selecting all colored cells VBA Closed

    Hello Everyone, i trying to create a button that once i click it, all colored cells RGB (255,178,178) will be selected. i don't want to fill the...

    danielshaal92 | Latest reply: danielshaal92 Aug 30, 2016
    0 replies
  • remove the date of 17/2/2012 from country A Closed

    Hello, i have recently faced a problem in excel. my problem is that i have three country data on daily basis. i want the same date will be appeared ...

    arshad | Latest reply: arshad Aug 29, 2016
    0 replies
  • Conditional paste, based in colour. Closed

    Hello, I'm looking to copy one value in one cell, following this condition: If A1 is green, then copy the value of C1 in B1. If not, leave it bla...

    Malfreds | Latest reply: Malfreds Aug 29, 2016
    0 replies
  • How to stop today function date changing every day in Excel Closed

    Hi, I am using this formula on my work sheet in cell (M7), and I have 13 sheets for each month in this workbook and I dragged the formula till cel...

    Haneen H | Latest reply: Klaas86 Aug 29, 2016
    9 replies
  • Format cells Closed

    Hello, I need to format cells based on date on another cell. for example if column A is complete then in Column B which is date column has to be g...

    Jawadh Shareef | Latest reply: Jawadh Shareef Aug 29, 2016
    0 replies
  • trying to create an order sheet Solved/Closed

    Hello, I am trying to create an order sheet in Excel. I have an inventory list with various information. One of the cells is where I input how may o...

    JesterGrafix | Latest reply: vcoolio Aug 29, 2016
    3 replies
  • Help to automatically update data from a master sheet to another Closed

    Hello, Can somebody please point me into the right direction? Example: I have 12 Tow trucks labeled T30-T41. I have to keep track of all maintena...

    Killerbeesnc | Latest reply: Killerbeesnc Aug 28, 2016
    0 replies
  • add 7 days to a set date Closed

    i formated the column to the german setting 28.8.2016. i put the formular in =sum(A1+7) the result returns #VALUE! how do i get it to work? it w...

    gebum | Latest reply: gebum Aug 28, 2016
    0 replies
  • Need to have a row of data automatically transferred Closed

    Example: I have 12 Tow trucks labeled T30-T41. I have to keep track of all maintenance done on each truck and the cost for the budget. If I have a ...

    Killerbeesnc | Latest reply: Killerbeesnc Aug 27, 2016
    0 replies
  • multiple if then statements Closed

    Hello, i am trying to write a ridiculous amount of if then statements (100+). i can nest them on a single worksheet no problem, however, trying t...

    ax837077 | Latest reply: ax837077 Aug 27, 2016
    0 replies
  • creating an order Closed

    Hello, I have a multi sheet database where each sheet represents a vendor. I'd like to transfer the information from the row, Column A, B, C, to my ...

    Jeremy | Latest reply: vcoolio Aug 27, 2016
    1 reply
  • Macro to copy data from a externalworkbook based on cell data Closed

    Hi everyone! I'm new here and have a question. I've been away from macros for 10 years and seem to have forgotten most of what I thought I knew. I n...

    tay916 | Latest reply: tay916 Aug 27, 2016
    0 replies
  • Exporting data Solved/Closed

    Hi am so excited to join this forum!!! Pls I need help. I have 14 sheets on a workbook (for 14 of the company's locations in Canada). The data c...

    chidazy | Latest reply: vcoolio Aug 26, 2016
    6 replies
  • Add row below last entry Closed

    I want to create macro for adding entire blank row with formatting if first cell of last row is populated with data. My row is B32:AM32. If user types...

    Heath Yackel | Latest reply: Heath Yackel Aug 26, 2016
    0 replies
  • Conditional formatting Closed

    Hello, Can I use conditional formatting to change a number from positive to negative based on the text in another cell? For example, I have a fil...

    Steve | Latest reply: Mazzaropi Aug 26, 2016
    1 reply
  • add data inputed from one sheet to anther Closed

    I'm trying to do an inventory control spreadsheet where I can put the data (ex, inventory in hand, use, buy, etc and it will be saved in another sheet...

    natita1422 | Latest reply: ac3mark Aug 26, 2016
    1 reply
  • Conditional format to highlight cell based on date Solved/Closed

    hi guys! I need some help. I'm creating a spreadsheet to show when car MOT expires. I have a column (F) which has MOT expiry dates in. I h...

    kieferschild | Latest reply: Mazzaropi Aug 26, 2016
    7 replies
  • Inserting rows Closed

    Hello, I Want to Insert Multiple rows Between Existing Data Along with TRANSPOSE formula Configuration: Windows 7 / Chrome 40.0.2214.111

    Maruthi | Latest reply: Maruthi Aug 26, 2016
    0 replies
  • formula that will make a specific text into a number Closed

    Hello, I need formula that will make a specific text into a number example: if A1 is R134a then B2 is 1430, if A1 is R404A then B2 is 3922, ...

    Hello, I ... | Latest reply: Mazzaropi Aug 26, 2016
    1 reply
  • Conditional Formatting Closed

    Hello, if i type "T" in one Cell i want to be fill colour to entire row how can it possible Configuration: Windows 7 / Chrome 53.0.2785.80

    Altaf | Latest reply: TrowaD Aug 25, 2016
    1 reply
  • Select a single line even if there are merged cells with VBA Closed

    Hello, I'm creating a worksheets that needs to be protected at all time. However, users may need to duplicate a line sometimes. What I want to do ...

    Jerry | Latest reply: TrowaD Aug 25, 2016
    1 reply
  • Excel "IF" function with DATE in test cell Closed

    Hello, I am trying to use the IF function with a date in the 2 logic test cell; If the 1st logic test cell has a date then I want the word "IN TRANSI...

    LNTP3 | Latest reply: TrowaD Aug 25, 2016
    1 reply
  • Keeping data Closed

    Hello there, I have what I consider an interesting issue and would certainly appreciate some options for resolving it as I am no Excel expert. We h...

    Mtujohn | Latest reply: vcoolio Aug 25, 2016
    2 replies
  • How to separate data between sheets Closed

    Hello, I'm don't know much about Excel in regards to functions and formulas, what I'm trying to do seemed like it may be a simple task but I'm le...

    oWICKo | Latest reply: vcoolio Aug 25, 2016
    1 reply
  • VBA search column for matching string Solved/Closed

    I am trying to write a script in VBA for excel. For an entire column of data in sheet 2, for each individual cell in a column, I need to search a c...

    pidge | Latest reply: Juzer Aug 25, 2016
    5 replies
  • enter date in dd-mm-yyyy Closed

    Hello, Please enter date in dd-mm-yyyy only. I have give 25-12-1988 but not accept Configuration: Windows 7 / Chrome 52.0.2743.116

    sam | Latest reply: fdibbins Aug 24, 2016
    2 replies
  • Capturing & Keeping Data Closed

    Need help capturing data from continually updated spreadsheet. Specifically, sales $'s are tracked by customer until payment in made, then deleted...

    MTUJOHN | Latest reply: MTUJOHN Aug 24, 2016
    0 replies
  • need a formula Closed

    on 1/1/16 (a1) , John (b1) told me he'd pay me $1 in 30 days. i want a formula that will automatically add 30 days from (a1) in date form in another...

    doutol1 | Latest reply: Mazzaropi Aug 24, 2016
    4 replies
  • negative cells Solved/Closed

    Hello, Please would someone help me with what I think is a simple problem. I have a range of cells which decrease in value and some become positive n...

    whatsit | Latest reply: Mazzaropi Aug 24, 2016
    3 replies
  • Extract data from specific cells and paste into a row Closed

    Our sales department has been using an Excel spreadsheet template to update product specifics, then printing it out and sending to our typesetting dep...

    WrshpMzshn | Latest reply: WrshpMzshn Aug 23, 2016
    0 replies
  • code for transferring data Closed

    i Have an excel workbook with different sheets. In sheet 1, i have date picker, where i select date and enter all the data for that particular date. T...

    Ashwin Reddy | Latest reply: ac3mark Aug 23, 2016
    1 reply
  • Excel Calendars and how to modify them Closed

    Hello, I am doing a Calendar for my work. It will include 3 tabs. Tab 1 will be a list of events going on and the date that event will take place....

    I | Latest reply: I Aug 23, 2016
    0 replies
  • calculate no of days left from today to a future specified date Solved/Closed

    Hello, How to calculate no of days left from today to a future specified date Configuration: Windows 7 / Chrome 52.0.2743.116

    raghs | Latest reply: TrowaD Aug 23, 2016
    2 replies
  • compare two sheet on weekly to see if any data is missing Closed

    I have two excel work books which we update daily. Since the sheets are used by multiple users, it is difficult to know if we miss any lines . Is ther...

    Hashu | Latest reply: Hashu Aug 23, 2016
    0 replies
  • Merge Rows and Seperate Data with Semicolon Closed

    Hello, I am hoping to merge rows in an Excel document based on shared Names (listed in a single column) and then consolidating the remaining data ...

    Dave | Latest reply: Dave Aug 22, 2016
    0 replies
  • adding new sheets based columns and moving rows to sheets Closed

    I am new to Excel and need some assistance. Summary: I need to distribute cases to investigators from a raw data list. I would like to create a...

    RPfraud | Latest reply: RPfraud Aug 21, 2016
    0 replies
  • Copy data different sheet with multiple columns with same header Closed

    Hi, I am new to Macros I have situation where some column headers are repetitive like column Header XYZ repeats n times and column header ABC rep...

    Soma | Latest reply: Soma Aug 21, 2016
    0 replies
  • Selecting all colored cells VBA Closed

    Hello, i want to create a button that once i click it, all colored cells RGB (255,178,178) will be selected. i don't want to fill them or anything...

    danielshaal92 | Latest reply: danielshaal92 Aug 21, 2016
    0 replies
  • Formula zero return Closed

    Hello ~ How can I get a zero return instead of a FALSE statement with the following formula? =IF(F4>E4,(F4-E4)*24,IF(F4

    laters150 | Latest reply: Mazzaropi Aug 20, 2016
    1 reply
  • help regarding a pricing sheet Closed

    Hello, I'm looking for help regarding a pricing sheet I'm trying to create on excel. I have my quantity in C5 = 2500 and cost in C15 = 75,000 if C...

    Kev1027 | Latest reply: Kev1027 Aug 19, 2016
    4 replies
  • Changing colour of cell once multiple other cells contain text Closed

    Hello, I would like to indicate in a cell at the beginning of a row whether multiple 'mandatory' cells within the row contain text. Red for incomple...

    VanessaR | Latest reply: fdibbins Aug 19, 2016
    1 reply
  • Count if formula Closed

    Hello, I have a Excel file where i have specific paths of the files and i Need a formula where it should reefr that cell path and Count the rows w...

    waseem | Latest reply: ac3mark Aug 19, 2016
    1 reply
  • format the color font depending on the value of another cell Closed

    Im new to Excel. Is there away or formula to change the color font of a cell depending on another cell? I want my text in colum A B C to be the font ...

    SADY1106 | Latest reply: Mazzaropi Aug 19, 2016
    1 reply
  • VBA looping/range Closed

    Hello, im attempting to run this but I want to add in separate loops that search for certain keywords. currently this successfully will find one and m...

    camtognetti | Latest reply: camtognetti Aug 19, 2016
    0 replies
  • how do you custom sort data in a pivot table Closed

    Hello, I need to sort the largest amount in a pivot table how is this done ? Configuration: Windows 7 / Mozilla 11.0

    vfelts | Latest reply: vfelts Aug 19, 2016
    0 replies
  • excel formula to move a word from one cell to another Closed

    Hello, Hi what is the formula to move anything that begins with "other: " to the adjacent cell Advocate at Home Advocate at Home Other: Bria o...

    vfelts | Latest reply: vfelts Aug 19, 2016
    0 replies
  • Creating Remarks from grades Closed

    How do I create corresponding remarks against letter grades?

    Ssysie | Latest reply: Mazzaropi Aug 19, 2016
    1 reply