Excel Forum

Ask a question
Search
Close
Results 2651 - 2700 of about 9,850
  • Calculating monthly attendance to percentage Closed

    i have a total of 8665 employees monthly attendance and i need to calculate that into percentage for the a month say for the month of March (31 days) ...

    DephyVIII | Latest reply: DephyVIII Mar 29, 2016
    0 replies
  • What is vba code to find if an active cell has a button over it? Closed

    Hello, In a column, i have a Macro Button for first row. I have programmed the Macro such that on pressing the Button, a data against the Empl...

    Shivam | Latest reply: Computertech Mar 29, 2016
    1 reply
  • Comparing Excel Closed

    I had a large excel file with multiple pages I was working on and computer shut down and created same file auto saved. I subsequently worked on one o...

    VPSC | Latest reply: VPSC Mar 28, 2016
    0 replies
  • How to bring searched columns copy and paste another sheet Closed

    Hello, I have set of data in sheet one. I have to search particular string in first row, if its found I need to copy that particular column and past...

    Aruna | Latest reply: Aruna Mar 28, 2016
    0 replies
  • Ask a question Message list Topic thread Forum list Report Macr Closed

    I tried the code and I getting a runtime error 9 on the following line Subscript out of range. lMaxRows_t = Workbooks(sBook_t).Sheets(sSheet_t).Cells...

    Lo2_35 | Latest reply: Computertech Mar 28, 2016
    1 reply
  • Insert same rows several times Closed

    Hello, I'm not familiar with macro's but I'm happy that the record option exists and that's what I copy/paste here under. But I suppose there is...

    Fredo | Latest reply: Fredo Mar 28, 2016
    0 replies
  • transfer data Solved/Closed

    Hello, Is it possible to transfer data for sheet 1 to another sheet i select form a drop down box that contains all the sheet's name in that wor...

    lynng | Latest reply: vcoolio Mar 27, 2016
    4 replies
  • Pop up reminder message in excel Closed

    Hi Guys, I'm just wondering if you would be able to assist me with this one, I have been trying to work this out myself but this is causing me a g...

    Blane | Latest reply: vcoolio Mar 25, 2016
    3 replies
  • I want to average Multiple Cells on Multiple pages. Closed

    Hello, I have an excel document and I need to average 10 different sheets. Each sheet has 374 cells that need to be averaged. So, Sheet one shoul...

    RobM | Latest reply: RobM Mar 24, 2016
    0 replies
  • move data Closed

    hi, is it possible to transfer data for sheet 1 to another sheet i select form a drop down box that contains all the sheet's name in that work book?...

    lynng | Latest reply: lynng Mar 24, 2016
    0 replies
  • Convert Letter to a Number Closed

    how do I convert a letter to a number, E needs to 4, M needs to be 3, P needs to be 1. I will be putting the letter in one cell and need it to conver...

    cmiller29 | Latest reply: cmiller29 Mar 24, 2016
    0 replies
  • How to calculate no of days between dates Closed

    Hello, How to calculate no of days between one constant date not written in excel sheet i.e. 31-03-2016 and other dates which is written in excel ...

    Trapti | Latest reply: Mazzaropi Mar 24, 2016
    1 reply
  • Hiding rows when validation list is changed Solved/Closed

    Hello, I have a excel sheet where have two sets of product line. I would need only details for one set of product line visible if i select it in ...

    Danny | Latest reply: tani Mar 24, 2016
    2 replies
  • Validation dropdown list to hide Rows Closed

    Hello, I have the following VB to hide number of rows by choosing validation drop down list. it worked great. but everytime I choose the drop down...

    tani | Latest reply: tani Mar 24, 2016
    0 replies
  • Userform to export data to another sheet Solved/Closed

    Hello everybody, Please could anyone spare his/her scares time to help me, I'm new in this forum and I hope to be an expert in excel. Your contribu...

    redbaby | Latest reply: redbaby Mar 24, 2016
    4 replies
  • Change colours of various text Closed

    Hello, I have a spread sheet with numerous rows named 1, numerous 2, then 3 etc. I want to change the text colour each time the text changes in ea...

    Ralph | Latest reply: Ralph Mar 24, 2016
    0 replies
  • counting and stop counting days in a cell Solved/Closed

    Hello, I need to create a formula for a cell involving number of days between dates. First cell - counts the number of days before and after du...

    diestra123 | Latest reply: diestra123 Mar 23, 2016
    4 replies
  • Match columns and assign a value from 3rd column Closed

    I have a list of ticket buyers from a recent event, including their zip code. I have a separate spreadsheet with every California zip code and it's...

    Jen | Latest reply: Coley925 Mar 22, 2016
    1 reply
  • Excel userform question Closed

    Hello, 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...

    lmeyer13 | Latest reply: TrowaD Mar 22, 2016
    1 reply
  • vlookup formula help please Solved/Closed

    =IF(PaymentDetails!$B22="","",VLOOKUP(PaymentDetails!$B22,AppMember,4,FALSE))*E22 Please everybody, how do I write this formula so as not to return...

    redbaby | Latest reply: redbaby Mar 22, 2016
    6 replies
  • VBA Excel 2013 Pleae Help Closed

    Hello, My question is and if this can be done. Say I have a date entered 3/15/2016 and have information in my excel file. Then I have to enter a...

    Scott T | Latest reply: Nado2oo2 Mar 22, 2016
    2 replies
  • How do i get the sales tax to pop up??? Closed

    Hello, how do I make it so I cant type in a city and have it so the sales tax automatically inserts itself in? Thank you Configuration: Windows...

    mgamble1990 | Latest reply: Coley925 Mar 22, 2016
    1 reply
  • How do i get the tax rate to pop up by itself??? Closed

    So I am trying to make an invoice for the company I work for. my question is: How do I make it so I type a city in the city cell and then automatica...

    mgamble1990 | Latest reply: mgamble1990 Mar 21, 2016
    0 replies
  • Conditional formatting one cell based on another excel 2016 Closed

    Hello, I want to conditionally format one cell in a row based on another cell in the row. i.e. If cell F1 has a value greater than 2009 I want cel...

    kd | Latest reply: TrowaD Mar 21, 2016
    1 reply
  • Need a formula to sum a column with #Value error Solved/Closed

    I need a formula that will sum column i8 to i65536 in cell m7 ignoring #value error. Any help? Thanks.

    redbaby | Latest reply: redbaby Mar 21, 2016
    2 replies
  • Userform to export data to another sheet Closed

    Hello everybody, I have a userform named MembersInformationEntry; it as the following details: Label1 named 'member Name' with a corresponding t...

    redbaby | Latest reply: redbaby Mar 21, 2016
    0 replies
  • auto copy/paste data if criteria (same value in 2 cells) is met Solved/Closed

    Hello from Barcelona, just signed up ... my first question ... excited :) I have 2 tabs. Tab 1 shows in column B the employee number and in col...

    JensBCN | Latest reply: JensBCN Mar 20, 2016
    1 reply
  • Creating a macro that will create a new sheet and copy data from Closed

    Hello, I want my macro to 1) create a new sheet and 2) copy data from another sheet onto the new sheet. For some reason it (my macro) will create...

    Susan | Latest reply: vcoolio Mar 19, 2016
    3 replies
  • HOW TO COMPARE NAMES FOR EXACT, NO MATCH, CLOSE MATCH IN EXCEL Closed

    I have 3 millions database of names in excel, I want to compare each rows for match, close match, no match, first name juxtapose for other names, & ab...

    QueenP | Latest reply: QueenP Mar 19, 2016
    0 replies
  • Painting by Numbers Challenge Closed

    Hello, I want a large matrix (100's of cells) to contain numbers, say from 1 to 20 and conditional formatting to colour fill the cell and font wi...

    JTD | Latest reply: JTD Mar 19, 2016
    0 replies
  • I want to compare multiple areas in city Closed

    Hello, I want to compare multiple areas in addresses for ex Industrial Development Area, Balanagar,Hyderabad Apollo Hospital Complex,Jubilee ...

    vishnuteja | Latest reply: vishnuteja Mar 19, 2016
    0 replies
  • Duplicating data from one line on sheet 1 to sheet 2 Solved/Closed

    Hello, I'm looking for help, I have data in one box on sheet1 one that when I update that data I would like for it to automatically change in a bo...

    Buford | Latest reply: vcoolio Mar 19, 2016
    6 replies
  • 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