Excel Forum

Ask a question
Search
Close
Results 3401 - 3450 of about 9,840
  • Please help in getting data clubbed in one cell Solved/Closed

    Please inform how to get the following information clubbed in a row Data as follows Required data in a ...

    Pkg1403 | Latest reply: TrowaD Sep 3, 2015
    3 replies
  • master sheet to work sheet, Solved/Closed

    I have been getting help at this site and I am not able to get into my messages to respond anymore. I am not sure if it is just a work computer issue ...

    Wayvic | Latest reply: vcoolio Sep 3, 2015
    29 replies
  • Macro to Copy Data From Multiple Sheets onto Single Sheet Closed

    Hello, I have multiple sheets that contain basically identical data and I am trying to extract certain parts and place it onto a single sheet. The ...

    mhigh22 | Latest reply: vcoolio Sep 3, 2015
    3 replies
  • vb averaging random fields in Excel 2007 Closed

    Thanks very much for help on this . . After finding a row based on a field value, I need to get the value from a different field in that row . . ....

    SSAMS | Latest reply: ac3mark Sep 2, 2015
    1 reply
  • using partial text in a field, color the row Closed

    Thanks for help on this . . . Using the last 2 characters in a string in field GFi, color that row . . next row Example: for all rows with...

    SSAMS | Latest reply: ac3mark Sep 2, 2015
    1 reply
  • Accounts data requires automatic analysis Solved/Closed

    Five columns headed Value, Type, Food, Household, Medical. The data is in Value and Type listed alongside each other. I wish to have those transfer...

    249ccjames | Latest reply: 249ccjames Sep 2, 2015
    2 replies
  • how to autogenerate a new daily report Closed

    I have a daily report made up in Excel containing daily (manually entered) data, and "to date" (computed in Excel) data. I would like to be able to...

    aldeane1 | Latest reply: aldeane1 Sep 2, 2015
    2 replies
  • how to get data from another sheet in many rows? Closed

    Hello, Im helping my dad out with some office software of his. so im basically trying to make it in excel. There's a monthly sheet and a daily sheet...

    gunjan17 | Latest reply: gunjan17 Sep 2, 2015
    0 replies
  • How to create auto populating multiple sheets based on cell Closed

    Hello, I'm currently creating a building condition assessment form. I would like to know how to create auto populating multiple sheets once I sele...

    helena | Latest reply: TrowaD Sep 1, 2015
    1 reply
  • custom sorting & calculating average based position Solved/Closed

    please help me with this. i want to get the position based on average. but when i put all these in a table, all are getting jammed. please can u h...

    oluwaridenawa | Latest reply: oluwaridenawa Aug 31, 2015
    2 replies
  • Extracting Data of new Entries to another Sheet or Workbook Closed

    Hello, I currently have a large matrix of data that I use to index work with a lot of categories. I would like to create some metrics based on t...

    elee12345 | Latest reply: elee12345 Aug 31, 2015
    0 replies
  • search word from list, match it copy values next to it Solved/Closed

    I have a list of product part numbers in one excel document. Now I need to pull the description and pricing from another document which is attached in...

    haris1989 | Latest reply: haris1989 Aug 31, 2015
    2 replies
  • Sum value of one column if in another column there is a text Closed

    Hello, I am trying to sum values in column A if in column B there is a certain number. So, Column A 10 20 30 40 50 Column B E45D...

    Europeoffice | Latest reply: Mazzaropi Aug 31, 2015
    1 reply
  • If cell have specific text it give us alert message Closed

    Hello, If cell have specific text it give us alert message Configuration: Windows XP / Chrome 44.0.2403.157

    Mahmoud | Latest reply: TrowaD Aug 31, 2015
    1 reply
  • how to get the database values in excel ? Closed

    Hello, pls give me one solution Configuration: Windows 7 / Chrome 44.0.2403.157

    SHEEBU | Latest reply: SHEEBU Aug 31, 2015
    0 replies
  • Extract the number A1-A10 like a A1,A2,A3,A4,A5,A6,A7,A8,A9,A10 Closed

    Dear Team, I Need extract the Number like a below in excel sheet Cell A1 have a character is "A1-A10" Cell B1 need to extract A1,A2,A3,A4,A5,A6...

    shivarajed | Latest reply: shivarajed Aug 31, 2015
    0 replies
  • Transpose data in single column into 4 columns Closed

    Hello, I have data in a single column and would like to transpose it into a row for every 4 rows. I have about 7000 rows in the 1 column. I'd l...

    montyb1992 | Latest reply: Mazzaropi Aug 28, 2015
    1 reply
  • Compare 2 columns choose answer in third Closed

    Hi all, First of all thank you for reviewing this. I have a data dump from a survey. Column A shows the survey #. On other sheet (sheet1) I have...

    John | Latest reply: xpcman Aug 27, 2015
    1 reply
  • Macro-Copy data from one workbook to another Closed

    All, I need to copy data from one workbook and append the content to another workbook (WB). Ex: WB1 (source) has 1 2 3 4 5 WB2 (target) al...

    Krishna | Latest reply: Dvibe Aug 27, 2015
    12 replies
  • A macro to change the values on a specified cell Closed

    Hello, I am searching a macro code on excel to set a value on a cell that is found by using such an excel function =ADDRESS(MATCH(N7,'Sheet1'!...

    prov | Latest reply: TrowaD Aug 27, 2015
    1 reply
  • Copying cell information Closed

    Hello, I would like to copy + add up the numbers in the cells. However when I change the filters, the numbers brought through change. The informatio...

    Excel numpty | Latest reply: TrowaD Aug 27, 2015
    1 reply
  • amount in words Excel formula Closed

    Hello, kindly guide me how this formula apply in excel for amount converted in words plz guide me plz help me reply on this id ***@*** Confi...

    zakir | Latest reply: zakir Aug 27, 2015
    0 replies
  • Excel - transfering information from sheet to sheet under condit Closed

    Hello, I have one problem to solve. I have 2 work sheets in excel. In the first one I have few columns. 3 of them I want to transfer for another she...

    ZygmuntDeRyk | Latest reply: ZygmuntDeRyk Aug 27, 2015
    0 replies
  • Would like to Transfer Date from Sheet 1 to Sheet 2 Automaticaly Closed

    Hello, Trying to Edit incoming data faster, would like to be able to input data lets say Sheet 1 A2 First Name B2 Last Name, then Take given informa...

    Nate | Latest reply: Nate Aug 27, 2015
    0 replies
  • Using IF formula for dates Closed

    hello, i want to make a sheet for my job to track the allotments, i want it to count the days allotment sent for signature till it is back from sig...

    Ranaamani | Latest reply: ac3mark Aug 26, 2015
    1 reply
  • Copying Cell Information (with moving filters) Closed

    Hello, Please, please, please can I have your expert help with his matter I would like to copy + add up the numbers in the cells from a differe...

    ExcelNumpty | Latest reply: ExcelNumpty Aug 26, 2015
    0 replies
  • Grouping data in excel Closed

    Hello, I have one excel spreadsheet with data in this form Country: UK France UK Spain Germany UK Spain France UK Germany data1: ...

    kwstas | Latest reply: kwstas Aug 26, 2015
    0 replies
  • Copying selected row from one sheet to another, Closed

    I am trying to have Excel lookup values in Column A from Sheet A in Column B Sheet B, and then, copy entire Row (or just to the left from Column B), w...

    lkiljanek | Latest reply: lkiljanek Aug 26, 2015
    0 replies
  • Next Empty Cell Closed

    Hello, I work at a fitness center. We have an equipment checkout system that we use Excel for. In my "Lockers" sheet, locker keys get checked out ...

    Michaela | Latest reply: Michaela Aug 26, 2015
    0 replies
  • Auto Sort New Entry Closed

    Hi everyone! I'm sure you get asked this often but I can't find what I'm looking for on the internet so I'm asking and yes I'm a new-be! No laughi...

    Nardi0923 | Latest reply: Nardi0923 Aug 25, 2015
    0 replies
  • Data Validation If Then Closed

    Hello, I have a "Yes" or "No" data validation list in cell C1 and manual input cells in D1, E1 etc. I would like to create a code that says (If C1...

    Chris | Latest reply: xpcman Aug 25, 2015
    1 reply
  • Compare two columns in an excel Closed

    Hello, How to compare numerical values in two columns and get their difference in an excel?

    Manu | Latest reply: Manu Aug 25, 2015
    0 replies
  • Need to copy data from one sheet to another Closed

    Hello experts, I am new to excel, I have a requirement where I have multiple sheets and I need to create a master sheet..based on the surrogate ...

    Dev | Latest reply: Dev Aug 25, 2015
    0 replies
  • Search,compare,update,indicate data in excel sheet (macros VBA) Closed

    Q) 1 core excel sheet with 10 to 15 thousands rows and around 150 columns. Another targeted sheet to be completed with using VBA which content same 10...

    May7 | Latest reply: MAY7 Aug 25, 2015
    2 replies
  • transposing data Closed

    Hello! I need some help for data transposing. the data set above is the raw data and the data set at the bottom is the set I need to create. ho...

    mgorange10 | Latest reply: mgorange10 Aug 24, 2015
    0 replies
  • Help with a school Directory Closed

    Hi all, I am creating a school directory. My columns are Last Name, First Name, Father/Mother, Phone, Email, Address, Zip, Teacher, Grade. I ha...

    directoryhelp | Latest reply: xpcman Aug 24, 2015
    1 reply
  • Urgent,,,custom database from one entry sheet to multiple sheets Closed

    Hello, Thank's in advance...for helping in my problem I enter data in a sheet and based on that i print few page report that contains that variable...

    vkdsynd | Latest reply: xpcman Aug 24, 2015
    1 reply
  • Copying to cell information Closed

    Hello, I would like to copy + add up the numbers in the cells. However when I change the filters, the numbers brought through change. The informat...

    ExcelNumpty | Latest reply: ExcelNumpty Aug 24, 2015
    0 replies
  • Enable Macro Security Via Macro Or automatically Closed

    Hello, Dear Friends i m not good in english so sorry in advance for bad english. but i need to enable macro automatically when worksh...

    aptpsbwmraj | Latest reply: TrowaD Aug 24, 2015
    3 replies
  • Transfer data from multiple sheets to sheet 1 based on criteria Closed

    Hello, I am creating an estimating workbook where I have multiple product sheets that list qty, part#, description, volume, lbs, list price & disc...

    catyana | Latest reply: vcoolio Aug 23, 2015
    1 reply
  • Creating custom database from one entry sheet to multiple sheets Closed

    Hello. I enter data in a sheet and based on that i print few page report that contains that variable data I want to some extra work so that every...

    vkdsynd | Latest reply: vkdsynd Aug 23, 2015
    0 replies
  • Pop up setting Closed

    Hello, I have got two excel sheets one master sheet that gets updated everymonth with the new employees joining that month. In the second sheet ...

    Lalchand | Latest reply: Lalchand Aug 22, 2015
    0 replies
  • convert date to English words Closed

    Hello, Hello i want to know how to convert date into words(english) in excel 2003, 2007 or 2010 for eg. 22.04.2010 - convert it into Twent...

    arshadbilal3390 | Latest reply: arshadbilal3390 Aug 22, 2015
    0 replies
  • Concatonating within commands??? Solved/Closed

    Ok - I know I said no more scripting, but ... Im still with Excel (VBA) macros and trying to find a way of inputting data from a html sheet (stored...

    BrianGreen | Latest reply: BrianGreen Aug 21, 2015
    4 replies
  • Automatically populating master excel sheet from other files Closed

    Hi, I am fairly new to Excel, especially when it comes to macros. I will be having a lot of files saved in a particular folder that contain inspec...

    bsns | Latest reply: bsns Aug 21, 2015
    0 replies
  • why the type mismatch error? Closed

    My question is in the comment in the code: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Target.Cells.Count > 1...

    Fulicasenia | Latest reply: xpcman Aug 21, 2015
    1 reply
  • format row based on text length Closed

    Hello guys, Can you pls help me? I am beginner in VBA and I need to sort out one macro. I have table and need to have highlited row with color, bu...

    Llupo01 | Latest reply: vcoolio Aug 21, 2015
    3 replies
  • using if condition with date function Closed

    Hello, Sir, i am using if condition with date function. my question is that I have two date in two column. dates are different. if 1st date col...

    Saifi | Latest reply: vcoolio Aug 21, 2015
    3 replies
  • Step by Step Instructions Closed

    Hi everyone: Following policies is a difficult thing because it is open to interpretation. I was wondering if it is possible to create a prompt in...

    nnavarro | Latest reply: nnavarro Aug 21, 2015
    7 replies
  • get month name and year from date Closed

    Hello, how do I can convert the date in to month name and year ex. 01/05/2015 , I want to get month name as May and year 2015 pls help me, b...

    well | Latest reply: vcoolio Aug 21, 2015
    1 reply