Excel Forum

Ask a question
Results 5851 - 5900 of about 9,840
  • Roster with each person getting their own weekly sheet printed Closed

    Hello, Ive put together a spreadsheet for work, where we have a main page called roster, the whole weekly roster for all staff members goes onto t...

    cobbadan | Latest reply: rizvisa1 Jan 23, 2013
    8 replies
  • Macro Help: Copy Data from a Range of Sheets to a Master Sheet Solved/Closed

    Hi, I'm looking for some help developing a macro to collect data from a range of sheets in a workbook, but not all sheets. The macro needs to: ...

    supermate | Latest reply: supermate Jan 23, 2013
    7 replies
  • Tagalog Solved/Closed

    Hello, Hi! Is there anyone here knows how to speak Tagalog? If so, please let me know..I just have a few questions regarding in Excel. I cant ex...

    flower_girl | Latest reply: flower_girl Jan 21, 2013
    2 replies
  • How to convert number into text in Excel Solved/Closed

    Hello, pls.send me formula to convert number into text in Excel e.g.100001 in words like' one lakh one only"

    boratechandu | Latest reply: Raj Jan 21, 2013
    9 replies
  • Camparing two coloumns in excel and copy another cell value Closed

    Hello Sir I have two excel files where I want to match file1 Coloum A with File2 Coloumn A If match found File1 Coloumn C cell value should copy to...

    SP Kumar | Latest reply: basri hamid Jan 18, 2013
    1 reply
  • Adding a new entry into a list - Excel 2007 Solved/Closed

    Hi Hope that someone can help me with this problem..... I've created a list in Excel 2007. I've added 3 colours in the list (blue, red, green). I ...

    talana | Latest reply: confused Jan 18, 2013
    12 replies
  • Need help with macro for 2 worksheets Closed

    Hello, I've seen examples close to what I need, but I'm not an experienced macro person and I don't know how to tweak them to get what I want. ...

    mjaybee | Latest reply: mjaybee Jan 17, 2013
    2 replies
  • I need help getting info from one worksheet to copy to others Closed

    Hello, I have an Accounts Receivable worksheet for each year. I want to log each entry into the main spreadsheet and then into a separate worksheet b...

    syrenitytoo | Latest reply: TrowaD Jan 17, 2013
    1 reply
  • Hi, Need some help - Copy pasting and creating coments! Thanks Closed

    Hello, Getting a little stuck - would anyone know how to copy text/number from one cell and with one function: in a new cell create a comment AND ...

    shock43 | Latest reply: TrowaD Jan 17, 2013
    7 replies
  • VLOOKUP range question Solved/Closed

    Hello, =VLOOKUP(A4,OLD!$A1:$B1404,2,FALSE) I'm using this formula in my spreadsheet and it is working EXCEPT when the new spreadsheet has inse...

    mjaybee | Latest reply: mjaybee Jan 17, 2013
    1 reply
  • colour column based on dates Closed

    Hello, I'm having a hard time to figure out a formula that colour the column with respect to dates. Can anyone help me out on this please..here's...

    Angga06 | Latest reply: Angga Jan 17, 2013
    6 replies
  • macro which can countif on multiple criteria and export result Closed

    Hello, I have to create a macro, which can count for me how many of different categories of services we have. there are around 20 main categorie...

    Chiara666 | Latest reply: rizvisa1 Jan 16, 2013
    1 reply
  • Macros Closed

    Hello, I'm new to Macro's and now wanted to learn how to run a macro based on the column values. Eg: If in column D has a values and if D3 has ...

    Goutham G | Latest reply: rizvisa1 Jan 16, 2013
    3 replies
  • New in MS Excel Closed

    Hello, Morning! Anyone can help me? i dont understand what ive read in wiki about macros. i dont know how it works even in simple excel! Can y...

    flower_girl | Latest reply: flower_girl Jan 16, 2013
    2 replies
  • Macro - concatenated cells until if finds a blank cell Closed

    Hello, Please assist. Im trying to concatenated cells with text until it finds a cell with no text then it stops current continate then continues...

    PFMONEY | Latest reply: TrowaD Jan 15, 2013
    1 reply
  • how to useing percentage formula in excel Closed

    how to useing percentage formula in excel Configuration: Windows 7 / Chrome 24.0.1312.52

    bharathkumarg | Latest reply: Zohaib R Jan 15, 2013
    1 reply
  • adding the same action to every second line Solved/Closed

    hi guys, i wonder if you could help me with the following: there is a worksheet where column A is full with numbers. I would like to add to ever...

    DG83 | Latest reply: Dg83 Jan 15, 2013
    8 replies
  • sum certain cells in a column if corresponding cells of another Closed

    Hello, I want to sum certain cells in a column if corresponding cells in another column contain a certain letter. I have amounts in cells G2:G1...

    taiawelty | Latest reply: rizvisa1 Jan 14, 2013
    1 reply
  • Conditional equation Closed

    Hello, I am desperately trying to write a formula for the following: If C23 is less than 2 but greater than zero, then value of E14, and if not,...

    kpoirier | Latest reply: rizvisa1 Jan 14, 2013
    1 reply
  • Formula to measure percent of checklist complete Closed

    Hello, I am trying to build a checklist where if you have completed the task on the list, you put an X in the cell below that task. As tasks...

    jlmetzger | Latest reply: TrowaD Jan 14, 2013
    1 reply
  • If, Then formula Solved/Closed

    Hello, I am creating a spreadsheet for the company airplane. Part of it is to calculate how many of the miles flown were "occupied" (had passengers...

    eaglewings1983 | Latest reply: eaglewings1983 Jan 14, 2013
    2 replies
  • Counting between two given dates Closed

    Hello, I need help. I need to count on Excel 2007 between two dates including the start date and end date. But the DatedIF fdoes not work. and...

    2709christine | Latest reply: TrowaD Jan 14, 2013
    8 replies
  • convert date into month name Solved/Closed

    Hello, suppose date has mention 1/1/09 and no month name then how to get the month name

    danny | Latest reply: Manoj Jan 14, 2013
    20 replies
  • Macro to copy data under matching column header Closed

    I am trying to write a macro to copy data from multiple spreadsheets and get the data to paste into the proper matching headers. Here is what I have s...

    nsabree6 | Latest reply: rizvisa1 Jan 13, 2013
    4 replies
  • copy Excel 07 sheet to other & keep formulas? Solved/Closed

    Hello, Is it possible to copy an Excel 07 spreadsheet to another window spreadsheet (not another tab but completely different spreadsheet) and keep t...

    Linda | Latest reply: limitdydx Jan 13, 2013
    8 replies
  • excel - Active X Combobox, Selecting Sheets Solved/Closed

    Hi, Am a newbie in trying to automate Excel. I have a workbook with 50 worksheets and a menu sheet. On the menu sheet I created a Actixe X ...

    MRafik | Latest reply: rizvisa1 Jan 12, 2013
    5 replies
  • Comparing two spreadsheet data Closed

    Hello, If I have an original sheet comprising of 8 columns and a number of other row items with subtotals in between. The next sheet contains t...

    vikas.nandanwar | Latest reply: vikas.nandanwar Jan 12, 2013
    0 replies
  • Add-ins not show on excel 2010 Closed

    Hello, Please , somebody can help me with this wrong I follow all the step for add an add-ins on excel 2010 , But this not appear What i...

    saraydelarosa | Latest reply: rizvisa1 Jan 11, 2013
    5 replies
  • How to Recover Excel Password? Closed

    Hello, I can't able to open my excel file, i have lost my excel file password please suggest me how to open my excel file and how to recover excel f...

    micalhassey | Latest reply: Ambucias Jan 11, 2013
    1 reply
  • calculating sum of the amounts of each Airports automatically Closed

    Hello, I have TWO tables such as below,according to the First Table :the first column (Airport name) the second column is ( the amounts in USD) ...

    SALWA ATALLAH | Latest reply: rizvisa1 Jan 11, 2013
    1 reply
  • Creating Macro to copy data from one WB & Save to new WB Closed

    Hello, I am very new to creating Macro's and need some assistance. I have a large report with data for several different campuses. I'd like to cre...

    sawallac | Latest reply: rizvisa1 Jan 11, 2013
    3 replies
  • Help needed with Excel Macro Closed

    Hello, I have the following sheet: A B C D 1 XXX Monday 5-Jan 5 2 YYY Tuesday 18-Feb 0 3 ZZZ Wednesday 23-Mar 3 4 AAA Thursday 12-Dec 4 ...

    BeeZeeXLS | Latest reply: rizvisa1 Jan 10, 2013
    3 replies
  • Help on merging multiple excel files data Closed

    Hello, I am trying to merge multiple excel files placed in a folder. all of them have same headers and similar pattern of data. the purpose of th...

    seekermay | Latest reply: rizvisa1 Jan 8, 2013
    7 replies
  • Many Columns return into fewer columns. Solved/Closed

    Hello, I have a spreadsheet that was exported from Survey Monkey. So the format cannot be changed. There can be data in any of 100 columns. Howeve...

    JW32 | Latest reply: Ambucias Jan 8, 2013
    15 replies
  • Formula to check for text in column Closed

    Hello, I am trying to write a formula that searches an entire column for specific text, if it finds it, then add 1. There are three different text v...

    cristinev | Latest reply: Zohaib R Jan 7, 2013
    1 reply
  • MSOffice 2010 Solved/Closed

    Hello, How can I customize Naira Symbol in MS excel Office2010. Thank you.

    SADETR9876 | Latest reply: rizvisa1 Jan 6, 2013
    1 reply
  • copy many columns and past it in one single column Closed

    Hello, I am trying to copy many columns C,D, and G and paste them into on column B in the first blank cell in the same sheet and I will need to do the...

    dobdobdob | Latest reply: Zohaib R Jan 6, 2013
    3 replies
  • convertion of numeric to text Closed

    Hello, I have used your program for converting numeric to text in excel but there is problem regarding when we are entering greater than 100000 (o...

    shaikh4shoukat | Latest reply: Ambucias Jan 5, 2013
    1 reply
  • Search for a text in a column when found copy cell above it Closed

    Hello, Boy Results Ttstm063 Mark Earned Points Earned Boy Results Ttstm063 Mark Earned Points Earned Boy Results Boy Results Ttstm063 ...

    recyhood | Latest reply: rizvisa1 Jan 5, 2013
    4 replies
  • Aline data horizontally in excel using vba or vbs Closed

    Hello, ...

    akashneelh | Latest reply: akashneelh Jan 5, 2013
    0 replies
  • If and logic Closed

    Hello, I am trying to write an Excel formula where i have a condition statement that varies result. For example if my target figure is > 30 but le...

    antress | Latest reply: rizvisa1 Jan 4, 2013
    1 reply
  • All permissions in protected and shared workbook disabled autom Closed

    hello friends, Version: Excel 2007 OS: Windows 7 Professional Situation: I have a 1000 rows X 50 columns of data. Filters are applied on th...

    harivov | Latest reply: harivov Jan 2, 2013
    0 replies
  • Copy from one excel sheet to another Closed

    Hello, I am trying to figure out if it is possible to copy from one sheet to another. Not the whole sheet, but rather I would like to put cells f...

    sutch | Latest reply: sutch Dec 31, 2012
    2 replies
  • Short cut to merge cells Solved/Closed

    Hello, If there a short cut on the key board to merge cells in excel?

    rossdavid | Latest reply: Roopesh Dec 31, 2012
    17 replies
  • Macro to connect to Paste All Clipboard Excel 2007 Closed

    hello, I wish to make a macro that will paste All from the clipboard Excel 2007 ( do the same as the Paste All Clipboard button ) The cell is A1 sh...

    pennbowl | Latest reply: Zohaib R Dec 30, 2012
    1 reply
  • How can I lock the column in excel Closed

    Hello, If I have a table or Excel sheet and I made a function in a cell A2 and drag this function to be coped in all column A and finally I wan...

    BSS Hakim | Latest reply: Zohaib R Dec 27, 2012
    1 reply
  • Macro to sort clipboard Paste all function Closed

    WINDOWS 7 EXCEL 2007 Hello, I would like to make a macro that would convert the data below to (See-Below) LIFETIME RECORD STARTS WINS 2NDS 3R...

    pennbowl | Latest reply: pennbowl Dec 23, 2012
    2 replies
  • Updating Excel that has Macros Closed

    Hello, How can you easily update an Excel workbook that already is using Macros? I need to insert two columns but once I do, I receive errors. T...

    VLS | Latest reply: rizvisa1 Dec 20, 2012
    5 replies
  • Vlookup ? Closed

    Hello, I have list of 1000 company names in col A and in col B 20,000 company names. I would like to know if the company in A appears anywhere in ...

    David-59 | Latest reply: rizvisa1 Dec 20, 2012
    3 replies
  • Convert numbers to text format: Closed

    Hello, i got a problem in my data. there are many soluations already available for converting text format to number. But how can number format ca...

    Alizak | Latest reply: RWomanizer Dec 20, 2012
    2 replies