Excel Forum

Ask a question
Search
Close
Results 2701 - 2750 of about 9,840
  • Excel Macro Closed

    I am looking for help in writing a macro to highlight duplicate number in two separate rows. The conditional formatting is really close to what I nee...

    cm | Latest reply: cm Mar 10, 2016
    0 replies
  • Excel- How do I auto transfer rows of data to another worksheet Closed

    Hello all, I am after some help with excel. I am a PE teacher and need to find a way to cut down the processing time for our athletics carnival sco...

    dpirovich | Latest reply: TrowaD Mar 10, 2016
    1 reply
  • combine of column Solved/Closed

    Hello, How can we show value of more than two column in a single column but in two rows. please reply at the urgent.

    Deepak Upreti | Latest reply: TrowaD Mar 10, 2016
    3 replies
  • add data on 2 tables at once but in table2 only if text match Closed

    Hello Excel experts. I have 2 tables in separate sheets, I am using a userform to populate table1 and I need a formula to populate table2 as new data...

    Luis | Latest reply: Luis Mar 10, 2016
    0 replies
  • Compare values in two columns and return the value from third Closed

    Hello, I've a table containing four columns. If the values in the first two columns match to particular value (eg. A1="xxxx" and B1="yyy"), I need t...

    Wasim | Latest reply: venkat1926 Mar 10, 2016
    1 reply
  • Comparing two excel worksheets Solved/Closed

    please, I need a macro code that can actually compare two worksheets and flag up the differences using same color to show the dissimilar rows. Be...

    wingie | Latest reply: vcoolio Mar 10, 2016
    9 replies
  • Populate 2 tables at once but one table only if text match Closed

    Hello, I have 2 tables in separate sheets, I am using a userform to populate table1 and I need a formula to populate table2 as new data it's entere...

    Luis | Latest reply: Computertech Mar 10, 2016
    1 reply
  • userform populate combobox2 based on combobox1 selection Closed

    Hello, I have a userform with 2 comboboxes both work fine and they both get the items to select from the same column they each populate pulling uniq...

    Luis | Latest reply: Luis Mar 10, 2016
    0 replies
  • Date function Closed

    Hello, I'm using a function =date(year(j2)+(m2),month(j2),day(j2)) BUT.. I want to be able to type in words like NIL, NO, and DEFER in to cell M2...

    a2 | Latest reply: arieta Mar 9, 2016
    4 replies
  • need to find a data in a column and copy below cell data or add Closed

    column A column B column c 1......................... .........2 2.............. 23 3 2............... 25 5 want to use a excel function...

    hirdesh_saxena | Latest reply: hirdesh_saxena Mar 9, 2016
    0 replies
  • Error Closed

    Hello, I have written macro which have sheets 6 and when file which i get have sheet 2 only,when i run maco on file having sheet two i get error a...

    manisha | Latest reply: manisha Mar 9, 2016
    0 replies
  • Accounting Closed

    How do I create client data base for my small business

    tjoysure | Latest reply: tjoysure Mar 9, 2016
    0 replies
  • Carry forward formula Closed

    Hello, I'm trying to find if there is any formula to carry forward a figure to another spreadsheet on a daily basis. the cells were not at the sam...

    Hilmy | Latest reply: Computertech Mar 8, 2016
    1 reply
  • Drop Down List and Auto copy data based on date in cell to anoth Closed

    Hello, I need help fast. I'm not the resident expert my boss think I am apparently. Excel 2010. I imported info from a Word Perfect document whi...

    Nothing | Latest reply: ac3mark Mar 8, 2016
    1 reply
  • VBA Tricky Question Closed

    Hi All, I am working on excel and I need some help with VBA/macros. Basically, I have a variable called Y and I have a table of set values, call...

    marsdjinn | Latest reply: TrowaD Mar 8, 2016
    1 reply
  • Compare two csv files Closed

    Hello, I have two csv files which has member details. I just have to compare both the files and confirm if its similar. Any way to do it through e...

    Test | Latest reply: Computertech Mar 7, 2016
    1 reply
  • printing numerous copies Closed

    Hello, I have a seguential numbering macro that numbers a 2 part EWO - I want to be able to run more than 1 set at a time - how do I do that? C...

    mt | Latest reply: ac3mark Mar 7, 2016
    1 reply
  • Sending Data from one spreadsheet to multiple speadsheets Closed

    Hello, I am fairly new to VBA and have been searching for a solution for my problem but as yet have not managed to find one. I wish to send da...

    Pwaluk | Latest reply: TrowaD Mar 7, 2016
    1 reply
  • Save data to different sheet by clicking a button (LibreOffice) Closed

    Hi Everyone, I have a attendance record sheet that employees enter in the hours they worked each day for that pay period, which is a two week perio...

    hotshot79 | Latest reply: hotshot79 Mar 7, 2016
    0 replies
  • conditonal format a because of values in another cell Solved/Closed

    Hello, i am trying to figure out how i can format a cell to show green when above a figure and red when below the figure simple i know but here co...

    Watson | Latest reply: BrianGreen Mar 7, 2016
    3 replies
  • cursor in excel does not work Closed

    I use Window 7 and Office 2010 with license. I bought in Bangkok, Thailand. This morning my cursor in excel has been changed from arrow to be thick...

    MooPhet | Latest reply: kieferschild Mar 7, 2016
    1 reply
  • Arrow cursor has been changed to Cross and cannot move any cell Closed

    Hello, Please help me, I cannot use cursor in excel to move cell or drag. Thanks & Regards, Configuration: Windows 7 / Mozilla 11.0

    Moo | Latest reply: kieferschild Mar 7, 2016
    1 reply
  • Function Formula Date and Text Solved/Closed

    Good day I am looking for help with a function formula PLEASE. Example Decleration Start Date 2016.02.17 Last inv_ Inventory_ Decl frm 1...

    Gerberreinette | Latest reply: vcoolio Mar 7, 2016
    4 replies
  • SPELLNUMBER VBA IN EXCEL Solved/Closed

    Hello, I alreadly use spellnunber but the problem is it does not convert incorrect for my currency. Present Situation =SpellNumber(1,100,000) =...

    khamlanathph... | Latest reply: Lan Mar 5, 2016
    2 replies
  • Conditional Formatting for 2 columns Closed

    Hi I am currently using conditional formatting on cells with dates, I have used cell value rules to highlight a pending date within 14 days and one...

    NicA81 | Latest reply: BrianGreen Mar 4, 2016
    1 reply
  • If a cell A contains X then display cell B value - Please advise Closed

    Hello Everyone, How to get the cell B value when Call A1 is X the display what ever is there in Cell B1 as in Cell C. If not the leave the column b...

    Karthik | Latest reply: BrianGreen Mar 4, 2016
    1 reply
  • Excel question Closed

    I have an excel spreadsheet that I enter data on all month. At the end of the month I must extract that data and break it down into totals and put it ...

    Jbrig | Latest reply: Jbrig Mar 4, 2016
    0 replies
  • How to change Oct 26,2015 to 26-10-15 Closed

    Hello, Can any one help me to change Oct 26,2015 to 26-10-15 in a excel cell. Configuration: Windows 7 / Firefox 44.0

    Shahadat | Latest reply: kieferschild Mar 4, 2016
    1 reply
  • Conditional formatting on an entire row Solved/Closed

    Hello, I want an entire row to turn red, only when one cell in that row is less than 0. I tried highlighting the whole row with the formula =A12

    AKA | Latest reply: AKA Mar 4, 2016
    4 replies
  • Issue with Date and Text in if formula Closed

    Hello, I'm trying to write a function for a cell which refers to different descriptions in one column - where it only should combine some descript...

    Reinette | Latest reply: Computertech Mar 4, 2016
    1 reply
  • Receiving an error message for VBA Closed

    Hello, I was given a workbook to fix with 5 different sheets. The Summary sheet has a button to "Refresh Equipment List" which is supposed to ...

    mjp11 | Latest reply: ac3mark Mar 3, 2016
    1 reply
  • How to sum row color Closed

    Hello, Please help us with how to sum numbers marked in different colors. Configuration: Windows 7 / Chrome 48.0.2564.116

    Pooja | Latest reply: TrowaD Mar 3, 2016
    1 reply
  • simple way in Excel to copy data Closed

    Greetings, Can anyone help me. I am working on a huge project and looking for a simple way in Excel to copy data. If I have a master document w...

    dean94x | Latest reply: TrowaD Mar 3, 2016
    3 replies
  • Copy rows from sheet 1 to sheet 2 if rule is met Solved/Closed

    Hi I have a contact list I need to extract data from. Full contact list is sheet 1 Names are in A2:A12948 Internal phone numbers in B2:B12948 ...

    sierranz | Latest reply: sierranz Mar 3, 2016
    2 replies
  • VSB error autogenerate worksheet from list Closed

    Hello, So I have an excel that has mutiple worksheets "2016 Census" "Tracker Template" What I did was use a code to automatically pull data f...

    shayla03 | Latest reply: vcoolio Mar 3, 2016
    2 replies
  • how do io open 2 different excel sheets simultaneously Closed

    Hello, How do I open 2 different excel sheets simultaneously. Thanks

    Jaya | Latest reply: vcoolio Mar 3, 2016
    1 reply
  • How to sort product by keyword in description then add a prefix Closed

    Hello, I have thousands of products that I have to sort by category then assign a number prefix to its item ID. I was wondering if there was a way...

    CluelessPerson | Latest reply: CluelessPerson Mar 2, 2016
    0 replies
  • adding a value to a cell that contains text Closed

    Hello, Can someone please help me? I want my cell to have the word FREE written in it BUT I also want that cell to represent 0.00$ when I add it to ...

    sabrina | Latest reply: ac3mark Mar 2, 2016
    1 reply
  • Compare two spreadsheets to return a single value Closed

    Hello, I'm comparing two spreadsheets and I want to see if items appears on both spreadsheets. I've tried index match but I none of my columns hav...

    ATP | Latest reply: Computertech Mar 1, 2016
    1 reply
  • Only partial return of search for copy and paste rows Closed

    Hello, I have a workbook with multiple worksheets with same format that has data in A4:K15 that I would like to search by any field and have the r...

    smcgrath171 | Latest reply: smcgrath171 Mar 1, 2016
    4 replies
  • copy paste cells to another sheet when criteria met Closed

    Hello, I'm new to Macros and can't figure this one out. The data (numbers) read top to bottom, left to right, row by row. Some of the cells are h...

    frank7788 | Latest reply: frank7788 Mar 1, 2016
    0 replies
  • Activate Cells after Data Entry @A1 or Cell 1 Closed

    Hello Guys, Would you mind to help me on how to disable the rest of the cells unless upon inputting data on the first blank cell. (e.g., I input cha...

    Madz | Latest reply: TrowaD Mar 1, 2016
    1 reply
  • VBA Color cell in workbook based on value in other workbook Closed

    Hello everyone I needed a little help with a VBA macro. I have multiple sheets with data and I was wondering if a Macro could be written to pick up...

    RahulPai123 | Latest reply: RahulPai123 Mar 1, 2016
    0 replies
  • VBA Macro Help Closed

    So i have multiple sheets with data and i was wondering if a Macro could be written to pick up values from one excel file and color the cell in anothe...

    RahulPai123 | Latest reply: Computertech Feb 29, 2016
    1 reply
  • Create Macro to insert the editor's name, date and time Closed

    Hello, I would like seek some advise from expert to do the following: To create a macro box in excel. While I click on the box, the specific ce...

    Leow | Latest reply: Leow Feb 29, 2016
    0 replies
  • Search workbook and copy row results to worksheet Closed

    Hi, brand new to the site, but saw multiple posts that seem very close to what I am looking for. I have a workbook with 31 sheets that contain info i...

    smcgrath171 | Latest reply: smcgrath171 Feb 29, 2016
    0 replies
  • If a cell A contains X then display cell B value Closed

    Hello, How to get the cell B value when Call A1 is X the display what ever is there in Cell B1 as in Cell C. If not the leave the column blank or ...

    Karthik | Latest reply: Computertech Feb 29, 2016
    1 reply
  • Macro for the sheet where the master details are available. Closed

    Hello, Configuration: Windows 7 / Firefox 44.0 I would like to know how to create a Macro for the sheet where the master details are availa...

    shanojirao | Latest reply: shanojirao Feb 29, 2016
    0 replies
  • Checking Spreadssheet against Raw Data Closed

    Hello, I'm fairly new here. Let me thank you for your input in advance. I've created a master workbook with spreadsheets of the different system...

    gideon | Latest reply: gideon Feb 28, 2016
    0 replies
  • If cell equals text, then value/Formula Closed

    Hello, BACKGROUND: I am working on a budget and I'm paying down debt using a waterfall. I have a list of debts on a "Data Entry" tab, and I have ...

    Eesh | Latest reply: Eesh Feb 28, 2016
    0 replies