Excel Forum

Ask a question
Search
Close
Results 2651 - 2700 of about 9,800
  • Conditional Cell Marge Macro Closed

    Hello Great Community, One of my friends recommended your community and looking forward for someone can give a help hand for my issue. I have t...

    martel_9 | Latest reply: martel_9 Mar 17, 2016
    0 replies
  • Button to populate another sheet Closed

    I have spreadsheet with a button on it that opens a userform. This userform will populate data to the same sheet the button is on. How do I get this...

    lmeyer13 | Latest reply: lmeyer13 Mar 17, 2016
    0 replies
  • Retrieve data based on Categories in Drop Down list Closed

    Hello, I have a sheet full of entries that have at least five columns full of different data. One of these columns is a drop down list of categori...

    gogetter09 | Latest reply: gogetter09 Mar 17, 2016
    0 replies
  • display a range of cells if a condition (text) is met Closed

    well, i am regular for excel. now i need a help, if a cell value, is a particular text, then i want to display a range of cells at a particular loc...

    BEKNAL | Latest reply: TrowaD Mar 17, 2016
    1 reply
  • colour changing in rows determined by text in 2 different cells Solved/Closed

    Hello, i would like to change the colour of a number of cells in a row if column P contains any text, however the colour it changes to depends on the...

    kitchens | Latest reply: TrowaD Mar 17, 2016
    1 reply
  • converting numbers to text Closed

    hi I need to convert numbers / date of birth in excel pl suggest / advice thanks

    ak_cnb | Latest reply: TrowaD Mar 17, 2016
    1 reply
  • date formate Closed

    Hello, please help me, i have software date format {15/03/2016 5:26 PM} and i need convert to this format {Mar/14/2016} Configuration...

    munawwer | Latest reply: TrowaD Mar 17, 2016
    1 reply
  • Town/City to lookup county Closed

    Hello, I have a spreadsheet that what i am trying to accomplish is that when an address is typed into a column it will look up and match the town a...

    mohalloran | Latest reply: TrowaD Mar 17, 2016
    3 replies
  • Conditional Cells Merging Macro Closed

    Hello, I have the google contact in a CSV which shows an address in a separate rows. The key point on this file is the date that it is all of it i...

    martel_9 | Latest reply: martel_9 Mar 16, 2016
    0 replies
  • transfer data between sheets in excel Solved/Closed

    Hello, This involves an attendance sheet. A tab for each month with columns for weekly attedance and a total for the month and a summary tab contai...

    rodney hughes | Latest reply: Anonymouse Mar 16, 2016
    19 replies
  • Compare values of two separate sheets and returning value Solved/Closed

    Hello, Configuration: Windows 7 / Chrome 43.0.2357.81 I'm currently working a spreadsheet trying to match values from Sheet 1 Column B with...

    Camron | Latest reply: ac3mark Mar 15, 2016
    3 replies
  • Using an IF statement to compare dates Closed

    Hello, I'm trying to compare two dates by referencing two cells. I tried something like this IF(B2>C2, "past due", "on time"). I know to ...

    Clay | Latest reply: TrowaD Mar 15, 2016
    1 reply
  • How to have my results in different sheets in one workbook? Closed

    Good day I trust you are well? I was hoping you can assist me with the following and will be most grateful for any help I can get: I have to cr...

    wilnap | Latest reply: TrowaD Mar 15, 2016
    1 reply
  • How to invoke VLookUp function in Excel VBA. Closed

    Hello, Please, I need a visual basic code that can actually invoke or call a V Lookup function in Excel to query data in two separate worksheets an...

    Wingie | Latest reply: TrowaD Mar 15, 2016
    1 reply
  • Recording Macro To Duplicate Page And Rename To Numeric Value Solved/Closed

    Good day I am trying to record a macro that duplicates a page and renaming it to another file name but need to follow in numeric order. I have a...

    Shaun@1 | Latest reply: Shaun@1 Mar 15, 2016
    2 replies
  • Need to find a data in a column and copy below cell data or add Solved/Closed

    Hello , Please help me to solve this, it will be very grateful column A column B column c 1......................... .........2 2.................

    hirdesh_saxena | Latest reply: hirdesh_saxena Mar 14, 2016
    2 replies
  • Compare 2 worksheets and update one of them Closed

    I am a beginner Excel user and I hope I can get some help here. I am about to purchase a retail business. I have a copy of the master inventory list. ...

    kurtwm | Latest reply: TrowaD Mar 14, 2016
    1 reply
  • Help needed on saving then clearing content except selected rows Closed

    Hi I am writing a spreadsheet for my ward for TCI list which has admissions, discharges and transfers. I want to be able to save then clear the c...

    JPuk | Latest reply: vcoolio Mar 13, 2016
    7 replies
  • Autopopulating data from one main sheet to multiple sheets Closed

    Hello, I'm making a workbook for my coworkers to easily know what specific person they need to work with from month to month. I have created a "Mast...

    Ams1105 | Latest reply: vcoolio Mar 12, 2016
    1 reply
  • Transfer data from multiple sheets to one sheet. Closed

    Hi all, I'm kind of new to spreadsheets. I have 3 sheets each with the same columns. Column 1 has a type and column 2 has serial numbers, column 3 has...

    Darlz | Latest reply: vcoolio Mar 12, 2016
    1 reply
  • comparing columns in excel - can't remember?? Closed

    I used to do this function years ago and can't remember how now! I have three columns and each contains a value similar to A001187. I want to compa...

    Winkfield | Latest reply: Winkfield Mar 11, 2016
    0 replies
  • Compare workbooks Closed

    I have a two column workbook. Column 1 is a part number and column 2 is a description. I generate a second workbook with hundreds of numbers and u...

    mikeshog | Latest reply: mikeshog Mar 11, 2016
    0 replies
  • count days in excel Solved/Closed

    Hello, How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days. with =NETWORKDAYS(A1,A2) not count the weekends. Thanks F...

    Filippos | Latest reply: Banjo Mar 11, 2016
    18 replies
  • 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