Excel Forum

Ask a question
Results 551 - 600 of about 9,840
  • Populate cells in worksheets from an updating list Closed

    I have a club workbook with 150 member Worksheets that need to be populated from the members list. First Member is starting with A2 Second A3 etc....

    LazyDave | Latest reply: LazyDave Jun 20, 2018
    2 replies
  • VBA code for command button Solved/Closed

    hello everyone, i had created a macro enabled workbook (abc123.xlsm)which holds about 10 user forms and every user form complies data to separate wo...

    MUKUL_1308 | Latest reply: MUKUL_1308 Jun 20, 2018
    4 replies
  • Multiple text in a cell Closed

    Hi Please can someone help I have text in columns that uses multiple words example, annual leave, sick leave, maternity leave and i want to add...

    AfsanaEssop | Latest reply: ac3mark Jun 19, 2018
    1 reply
  • Multiple columns into a single column Closed

    Hello, I am using excel 2013 and I want to convert a range of data with variable no. of columns and 24 rows to a single column (columns stacked on...

    Jags | Latest reply: Jags Jun 17, 2018
    0 replies
  • Vlookup where table arrary contains certain value Closed

    Hello, I have a "Key" Code Value 000 Black 123 White and another sheet with the data below Data Colour BKI000T GTEF123X...

    _Liv_ | Latest reply: _Liv_ Jun 16, 2018
    0 replies
  • Compiling data in excel Closed

    Hello, I am working with a large spreadsheet of contact information for people in my industry. I have columns titled with different interest areas...

    jdlt | Latest reply: ac3mark Jun 15, 2018
    1 reply
  • looking for VBA code. Closed


    MUKUL_1308 | Latest reply: Ambucias Jun 15, 2018
    1 reply
  • Auto update of data from one sheet to other Closed

    Hello, Pls guide me regarding how to update data from one sheet to other in excel. In sheet1, if i update the details of the student it sho...

    aruncs | Latest reply: ac3mark Jun 12, 2018
    1 reply
  • Creating Excel Email Alert For Expiring Dates Closed

    Hello, all I want to do is to create a code that will send me an e-mail when one of my docs will be expiring or expired. The problem is that there...

    Imgladuc4me | Latest reply: ac3mark Jun 12, 2018
    3 replies
  • How to combine/merge multiple rows into single row Closed

    I have name of person in 1 row and multiple car names owned by him in different rows .How to combine these rows together so that name is in one column...

    PadmapriyaTG | Latest reply: PadmapriyaTG Jun 12, 2018
    0 replies
  • Copying and looping data from one file to another Closed

    In one tab I have information, where I have made it output the information on a second tab (It's more in depth than this but I tried making this as si...

    dhunited12 | Latest reply: ac3mark Jun 11, 2018
    1 reply
  • Convert date to the English spelling Closed

    Hello, My date of birth 1-3-1995 Please convert to the English spelling System Configuration: Android / SamsungBrowser 2.0

    Hassanuddin | Latest reply: TrowaD Jun 11, 2018
    1 reply
  • VBA - how to repeat a set number of values X times Closed

    Hi, I am having an issue with a code I am writing. I want to insert 1,2,3,4 down an empty column X times ( where X will be inserted by the user)...

    NELM | Latest reply: vcoolio Jun 10, 2018
    1 reply
  • Mac VBA & Excel, auto change image based on a cell Closed

    Hello, I'm trying to produce a simple excel spreadsheet on my Macbook which automatically changes the image in cell B3 when I change the name in A...

    winstoncheets | Latest reply: winstoncheets Jun 9, 2018
    27 replies
  • Auto populate when changing from quoted to sold? Closed

    Hello, I am working on a work book in excel for work. On one page, I am tracking quoted / sold cases when a case sell, I have it change colors. ...

    niko1216 | Latest reply: ac3mark Jun 8, 2018
    5 replies
  • How do i install excel on my pc Closed

    how do i install excell on my pc

    wellynoah | Latest reply: xpcman Jun 6, 2018
    1 reply
  • Birthday Closed

    Hello, 17/03/1996 in word

    Arbazkhan | Latest reply: Arbazkhan Jun 4, 2018
    0 replies
  • Scale Tab in Format Axis in Excel 2000 Charts Closed

    Hello, Using Excel 2000 charts, in some files, when I right-click on the horizontal (Date) axis, select the Scale tab in Format Axis, I get a "Time ...

    skeezix | Latest reply: skeezix Jun 2, 2018
    2 replies
  • Macro which copies formula down to end of row Closed

    I am new to this this and would be grateful for any assistance with a macro which copies the formula from the cell above and continues in a loop till ...

    DennisBroughton | Latest reply: ac3mark May 31, 2018
    1 reply
  • When the field is =N, want to subtract that field Solved/Closed

    Hello, This formula works, but when the field is =N, I want to subtract that field. What could I add to this formula to make that work? =(COUN...

    JBALLEST | Latest reply: ac3mark May 31, 2018
    3 replies
  • Conditional formatting across multiple columns Solved/Closed

    Hi there, I have two columns which if equal(unless blank), I wish to fill in with a colour. I have defined the range as the two columns(BX3:BY3) an...

    wolfy1s13 | Latest reply: wolfy1s13 May 28, 2018
    2 replies
  • MS Excel file error message Closed

    Hello Folks, There is something wrong with my Excel file. It was working fine on last night. Today, I opened it anf got the following error: S...

    Zacharynelsonn | Latest reply: TrowaD May 28, 2018
    1 reply
  • Conditional formatting across columns Closed

    I have two columns which if equal(unless blank) I wish to fill in with a colour. I have defined the range as the two columns(BX3:BY3) and specify the ...

    wolfy1s13 | Latest reply: wolfy1s13 May 27, 2018
    0 replies
  • Data transfer from master to other sheets by type Closed

    Hello, I'm trying to create a workbook with a master sheet and four subsequent sheets. Ideally the master sheet will be where my admin assistant w...

    Lucaso | Latest reply: ac3mark May 24, 2018
    1 reply
  • Highlight blank cells if data present within row Closed

    Hello, So I know it's using conditional formatting but I can't find a formula for what I want. I only want the blank cells highlighted, not the en...

    Smokeydriver | Latest reply: TrowaD May 24, 2018
    1 reply
  • Master sheet populating data to other sheets Closed

    Hello, I'm trying to create a workbook with a master sheet and four subsequent sheets. Ideally the master sheet will be where my admin assistant ...

    Lucaso | Latest reply: Lucaso May 23, 2018
    0 replies
  • Convert date format Closed

    Hello, May 1, 2018 Wanted to convert the above date into DD/MM/YYYY in excel. Pls help

    NileshNaraya... | Latest reply: xpcman May 23, 2018
    1 reply
  • change data to Date Closed

    Hello, I am copying data from Access to Excel; the data in Access is a Date, but when it is copied to Excel it is 43190. I have tried to data cha...

    Marcia | Latest reply: ac3mark May 22, 2018
    2 replies
  • pasting data in row keeping blank rows Closed

    Hello, How can i paste data in between three rows ie first 1 copied to next 4 th row (3 rows to be leaved blank)f or a whole work sheet. Sys...

    emkeaar | Latest reply: emkeaar May 20, 2018
    0 replies
  • Copy conditional formatting for an entire row based on one cell Solved/Closed

    Hello. I'm working on an Excel sheet, where the entire row is colored based on the values of two cells in the current row. If one of the cells in t...

    Maurits Kvåle | Latest reply: guest May 17, 2018
    23 replies
  • Formula which will highlights the cell in master s Closed

    Hello, I have a workbook with 30 worksheets and a master sheet. I hyperlinked the worksheets with master sheet. I want to know is there any formul...

    Sudeer | Latest reply: Sudeer May 17, 2018
    0 replies
  • Copy and paste data from different sheet using vba Closed

    Hi, I have spent a lot of time to copy data from different sheets to a destination sheet using excel VB by selecting a region from a dropdown list....

    sarfaraz416575 | Latest reply: vcoolio May 12, 2018
    3 replies
  • Transfer data to sheet w/ condition met Closed

    I have a 4000+ row data set that is continually updated. I need to write a VBA code to ensure that when Sheet1 column A = "N," Sheet1 columns B-G tran...

    mychem858 | Latest reply: mychem858 May 11, 2018
    0 replies
  • Duplicate rows from multiple worksheets Solved/Closed

    Hello, I have a workbook that I'm hoping will be the template for a monthly log. It is almost done, but I cannot figure out the best way to perfor...

    iksta | Latest reply: vcoolio May 8, 2018
    8 replies
  • Auto-generate/Populate Excel Worksheets from Data Closed

    Hello I wonder if anyone could help me. I need to separate a list of data into separate worksheets based on the data in the first column. For examp...

    Nuebee | Latest reply: TrowaD May 7, 2018
    8 replies
  • Data from one master sheet to 100 other sheet Closed

    Hello, I have this kind of problem that i have serial numbers xxx-xx-xx listed in 1200 rows in A column of master sheet. I have already macro for ...

    anakonda93 | Latest reply: TrowaD May 7, 2018
    4 replies
  • Look up tables across workbook Closed

    Hello there! I am currently working on a spreadsheet for my organization. As far as the data is concerned, it is collected by another part of the o...

    MACrucible | Latest reply: vcoolio May 7, 2018
    1 reply
  • Move that tab to a new workbook Closed

    Im relatively new to excel macros and have done half of what i need to do. I created a macro that takes data from one tab (which contains a pivot tab...

    eaja2 | Latest reply: ac3mark May 6, 2018
    1 reply
  • How to insert pictures in Excel using Macro Closed

    Hi, I'm facing 2 issues in using below code. 1st, suppose the image names are in column B from B2 to B11. Now, if the image against the image name ...

    atulmangal | Latest reply: ac3mark Apr 30, 2018
    1 reply
  • Resize cell to match picture size Closed

    Hello, Using above codes pictures are getting sized but the cell remains the same. pictures are overlapping each other. please help

    san | Latest reply: ac3mark Apr 30, 2018
    1 reply
  • Failing to sign in to excel Closed

    hie can you be of assistance im failing to sign in to excel it keeps telling me that there is a problem with my account. i have tried resetting the pa...

    kemielgeal | Latest reply: Ambucias Apr 30, 2018
    3 replies
  • Excel "IF" function w/ date in test cell Solved/Closed

    Hello, I am trying to use the IF function with a date in the logic test cell; If the logice test cell has a date then I want the word "DONE" to sho...

    Mike in PA | Latest reply: salim Apr 29, 2018
    6 replies
  • Updating a sheet name in Excel without macros? Closed

    Hey everyone, I've been working on a project and in order to do it how I was planning, I need to update sheet names dynamically without using macro...

    Graudenzo | Latest reply: ac3mark Apr 26, 2018
    3 replies
  • calculate how many times member A visit the cafe Closed

    Hello, member A register at cafe on a date 12 april 2017. He visited the cafe every times started from the registed date when the cafe opened at ...

    jeff | Latest reply: TrowaD Apr 26, 2018
    1 reply
  • transferdata from 1 sheet to other sheets criteria Closed

    Greetings! I have been trying to look for vba codes and formulas but am still at a lost as to how to even start. Am a total newbie at this whole vb...

    Sheiraa | Latest reply: ac3mark Apr 24, 2018
    1 reply
  • Auto Update a workbook with multiple sheets on one sheet of the same workbook. Closed

    Good pm. I need your help in order to enable me carry out update in ms excel. I have a workbook with multiple sheets (namely, creche , nursery1, ...

    topkentalk | Latest reply: ac3mark Apr 24, 2018
    1 reply
  • Table Values used to auto calculate and return val Closed

    Is there a way in a formula to have Excel continually look in a table, and insert a value in a cell , so that the value in another cell will never be ...

    LeedMe | Latest reply: ac3mark Apr 24, 2018
    13 replies
  • VLookup formula gives error Closed

    =VLOOKUP(A29,'I:\Vending Reports\2018\3. March 2018\[March 2018.xlsm]Crews'!$A$1:$H$370,8,FALSE)+G29 This is my formula. It is supposed to look f...

    ltlrose | Latest reply: TrowaD Apr 24, 2018
    6 replies
  • Copy data from one sheet to another Closed

    How can I copy data from one sheet to another on the basis of value in cell G10, say if value is DELHI then set of column corresponding to delhi will ...

    vipulk | Latest reply: ac3mark Apr 23, 2018
    1 reply
  • Concatenate columns in Excel Closed

    Hey actually i have a prob, i have 4 columns in my excel sheet, among them based on 2nd column i have to concatenate the contents of 4th column...

    karthikkp | Latest reply: ac3mark Apr 23, 2018
    1 reply