Excel Forum

Ask a question
Results 4551 - 4600 of about 9,870
  • formatting a column with repititive lines of texts with same col Closed

    Hi i have just completed a time and motion excercise and i have enetered the details into excel. i have also cleaned up my data, checked for inc...

    skyK | Latest reply: skyK Oct 30, 2014
    0 replies
  • How to Copy my all data in excel sheet1 to sheet 2 Closed

    HI.. all I have a Question. I have some data in my excel sheet1 . i want same data move or copy sheet1 to sheet2 by formula. i wait response. ...

    c.pnadey6 | Latest reply: venkat1926 Oct 30, 2014
    1 reply
  • Making Buttons to direct to a certain cel location. Closed

    Hello, I'm just wondering if its possible to make a button that redirects you to a certain cel information in EXcel. Sample: I want the button...

    Mymyname | Latest reply: Mymyname Oct 30, 2014
    0 replies
  • Auto Copy Closed

    I have a spreed sheet set up to log information on (sheet 1). On this sheet, it is a dynamic work sheet that we enter names on that we are currently w...

    knight1103 | Latest reply: knight1103 Oct 29, 2014
    0 replies
  • Insert/Remove photos depending up on ref. cell value changing Solved/Closed

    Hello, I designed a Student Profile in excel using LOOKUP function. In this profile, near the Student Name title I created one drop down list of stu...

    jinoob | Latest reply: KALEEM Oct 29, 2014
    9 replies
  • calculate difference in date Closed

    Hello all I have date column in following format- 21/09/2014 06:26 AM I want to calculate difference between above date and today. I tried doing ...

    gururajtiwari | Latest reply: gururajtiwari Oct 29, 2014
    2 replies
  • How to Create Macro to Search, Copy, & Paste? Closed

    I have Two Excel sheets Sheet2: Database file(Row wise Data has been updated i.e only in A column- refer below A1: Name A2 : person nameA3: ...

    hariexcel1987 | Latest reply: hariexcel1987 Oct 29, 2014
    0 replies
  • Move multiple entries from main sheet to multiple sheets Closed

    My First sheet is titled "D-4 listing" and contains all of the data for other sheets. I have columns F thru P that I put an "x" in if the information ...

    DjSkidz | Latest reply: DjSkidz Oct 29, 2014
    0 replies
  • Excel VBA copy and paste loop with logic condition Solved/Closed

    Hi, I am new to VBA and would appreciate some help with a problem I am trying to solve. I would like a macro that is able to copy information f...

    Yogibearv | Latest reply: Yogibearv Oct 28, 2014
    6 replies
  • Excel workbook with two sheets Solved/Closed

    Hi, i have an Excel workbook with two sheets and when i enter data in sheet #1 it automatically goes to sheet # 2. How on earth can i stop this fro...

    ibraun | Latest reply: ibraun Oct 28, 2014
    2 replies
  • Need help with formula if multiple cells are empty then another Closed

    I am using excel 2010, I need help with a formula that i can t seem to get i know i am close. example. A1,B1,C1,D1 - if B1 is blank and C1 is blank ...

    trevor34 | Latest reply: trevor34 Oct 28, 2014
    2 replies
  • Keep rules & formatting intact when data is copied to cells Closed

    Hi, I have an excel sheet made with few rules and formatting for cells but many times I have the requirement to copy values to these cells from tex...

    rchandran1 | Latest reply: TrowaD Oct 28, 2014
    3 replies
  • How to copy data from rows with value to a new sheet using macro Closed

    I have a massive excel spread sheet that I am using to keep track of sales. I would like a formula or function that will take both the headers along...

    ospeng | Latest reply: TrowaD Oct 28, 2014
    3 replies
  • %age of numbers Closed

    I have ten different numbers in a column. I want to calculate the percentage value of each number in next box to each number with respect to 350

    rmanzoor | Latest reply: ac3mark Oct 27, 2014
    1 reply
  • Substitute text into x in excel Closed

    Hi there, I'm nowhere to run related to the above subject, hoping you can help me to sort out this issue. In column/row A1 text is equal to "clo...

    Udjut | Latest reply: Udjut Oct 27, 2014
    0 replies
  • Copying the same format data from n number of sheets in 1 sheet Closed

    Hello, Scenario : I need to monitor a particular type of transactions. For each transaction done I get a automated mail with an attached excel. T...

    sautri | Latest reply: sautri Oct 27, 2014
    0 replies
  • Excel to send email when a cell changed Closed

    Hi, I'm totally lost, I'm new to macro world and would like to send email from excel when a cell changed, the sheet is very simple: Name Pr...

    thabeeb | Latest reply: thabeeb Oct 25, 2014
    0 replies
  • Shared File want to get a pop up message when the file is opened Closed

    I am trying to share a file between 3 people. I found the share option but I want to get a pop up message anytime the file is already open & someone ...

    kell70510 | Latest reply: ac3mark Oct 24, 2014
    3 replies
  • convert from one Column using if function Closed

    hi i have the information in one Column "A". This "A"Column contains 100 address .(Each line of the address has been typed in separate row) but eac...

    ssoumitra | Latest reply: ssoumitra Oct 24, 2014
    3 replies
  • Auto Transfer of a filtered item to a different sheet. Solved/Closed

    Hello everyone, I would like to ask for some help regarding some EXEL problems. Example: I want some data from sheet1 E columns to transfer to...

    Mymyname | Latest reply: Mymyname Oct 23, 2014
    6 replies
  • Moving data in specific columns to another sheet Closed

    Hi there, I have a workbook with multiple tabs. I need to move the first 3 columns of data in a row on tab, "MV Data" to another sheet labeled, "Campa...

    Andria17 | Latest reply: venkat1926 Oct 23, 2014
    1 reply
  • Simple report reminder - email notification Closed

    Hi, I would like to create a spreadsheet that list the dates of reports that I need to complete. The spreadsheet would be relativly simple, just a...

    louisecrane | Latest reply: louisecrane Oct 22, 2014
    0 replies
  • last row does not show. 44 names bt i see 43 Closed

    The function below , leaves there the last name (in column) in excel Private Function GetNameList() As String() Dim names() As String Dim...

    biira | Latest reply: biira Oct 22, 2014
    0 replies
  • Re: Need to copy excel every Row data to Excel template file Closed

    Good Afternoon, I am new to excel macro. I have a excel file with Row data . I want to copy specific cells data from each row and copy to a speci...

    Cleo760 | Latest reply: Cleo760 Oct 21, 2014
    0 replies
  • Sorting contents from columns to Rows Closed

    Hi, I have data sets in particular file format. Total no: of rows : 3623 (Column A) Total no: of rate cards: 26 (Column E) Rates for each code...

    ganeshkrish85 | Latest reply: TrowaD Oct 21, 2014
    1 reply
  • Any way to keep the formatting when using a formula in Excel2007 Closed

    I would like to copy the contents and format of a column of cells and paste them in another column using a formula. All columns are formatted as ty...

    Sven60 | Latest reply: TrowaD Oct 20, 2014
    1 reply
  • Comparing Data Between Two Spreadsheets Closed

    I have two spreadsheets that includes account number, name, and a charge amount for one (positive number) and a waiver amount (negative number) on the...

    keltikroze | Latest reply: venkat1926 Oct 19, 2014
    1 reply
  • How do I check for a blank cell in a range and replace them Closed

    I am looking for a way to check to see if cells in a column are blank and replace the blanks with a character (in the case a ?) in an Excel 2010 works...

    bjgranger | Latest reply: ac3mark Oct 16, 2014
    3 replies
  • How to Cycle through 2 different workbooks and adding rows from Closed

    Hello, i have 2 workbooks customer and Item customer has 1 sheet named custname which has a list of customer's name in column A (I. E. John, ...

    croft12329 | Latest reply: croft12329 Oct 16, 2014
    0 replies
  • color cells based on input Closed

    I want to change color of my cells based on an input. eg: If I input 3 in a particular cell, 3 consecutive cells must be highlighted. Any thoughts?

    myexcel.ren | Latest reply: TrowaD Oct 16, 2014
    1 reply
  • Excel 2007 Using vlookup function in VBA Solved/Closed

    I have a list of name and employee number in sheet 1 in column a and b.. Then what i want is to by simply typing the employee number in sheet 2 column...

    gsyrill | Latest reply: gsyrill Oct 15, 2014
    2 replies
  • Conditional formatting-color a cell based on the value of anothe Closed

    Hello, I have 2 columns of cells: R1-R100 & S1-S100. The cells in column R are the sum of cells L2:Q2, etc are is labeled "Expected Time to Process ...

    wharrington | Latest reply: TrowaD Oct 14, 2014
    1 reply
  • Comparing street address in two different worksheets Closed

    Greetings collaborators! I would like some assistance with comparing street addresses in two different worksheets. The lists are quite long (thous...

    Sick_of_you | Latest reply: TrowaD Oct 14, 2014
    1 reply
  • I am trying to add 10 days to a "custom" date Closed

    In the original cell I am using a custom date format of 00\/00\/0000 and in another cell I am adding 10 days to the date with the simple formula C1+10...

    realpple | Latest reply: TrowaD Oct 14, 2014
    3 replies
  • Strange problem with a macro Closed

    Hi, I've been using an Excel macro for some time that opens another spreadsheet, selects all of the cells, copies them, comes back to the .xlsm wor...

    slocumDoc | Latest reply: venkat1926 Oct 14, 2014
    1 reply
  • automatically transfer data from Excel forms into worksheet Closed

    Hello, I have a requirement to automatically extract data contained in Excel Forms, (there could be hundreds of forms) into a worksheet. Any assistan...

    larobina | Latest reply: TrowaD Oct 13, 2014
    1 reply
  • How to write vba macro in excel 2013 to delete cells in column Closed

    I am analyzing data of two column A1-A310632 cell and B1-B310632 cells to check and delete the first 2 columns i.e A1-2,B1-B2 while keeping the nex...

    waisi | Latest reply: TrowaD Oct 13, 2014
    1 reply
  • hey may I ask you something please? Closed

    i have two columns "County" and "County Code" i want to check country code not blank , and country code blank then return a value from a County to a n...

    shivraj | Latest reply: TrowaD Oct 13, 2014
    1 reply
  • Macro for shifting contents of a particular cell Closed

    I am trying to create a small macro which helps me copy the contents of a particular sheet (In my case the total of a long list of calculations) as an...

    blah85 | Latest reply: TrowaD Oct 13, 2014
    3 replies
  • format a cell with a comment based on a comment in another cell Solved/Closed

    Hi, I need to format a cell with a comment based on a comment in another cell. So cell A1 might ask a question like is the window clean? B2 will...

    stevo5355 | Latest reply: stevo Oct 12, 2014
    2 replies
  • Macro to copy paste without having all the source books opened Solved/Closed

    Hello Kioskea users. I hope you're all doing great. Today I have a concern that I'm not able to figure out. Any help will be really appreciated. I...

    fabianchpe | Latest reply: fabianchpe Oct 12, 2014
    2 replies
  • PDF overwriting previous PDF Closed

    Hello fellow Kioskeans, When I generate an invoice from my invoice template, it is automatically saved to an "Invoice" folder as a pdf. However, I...

    vcoolio | Latest reply: vcoolio Oct 11, 2014
    2 replies
  • Automatically moving cells with data Closed

    I have a column of times ie A1 = 00:25 A2 = 00:32 A3 = Nothing or it could be 0 or #N/A A4 = Nothing or it could be 0 or #N/A A5 = 00:27 an...

    SuttonRider | Latest reply: SuttonRider Oct 10, 2014
    2 replies
  • excel Closed

    Hello, I have report which consist date 1-30 in that first 15 days different format. last 15 days different format. first 15 days i can change dat...

    husni88 | Latest reply: venkat1926 Oct 10, 2014
    3 replies
  • Delete Rows with no conditional formatting highlights Closed

    Hi everyone! I have a quick query regarding tidying-up some worksheets I generate regularly that I've been unable to find a solution for despite se...

    oldschool1234 | Latest reply: TrowaD Oct 9, 2014
    3 replies
  • Suppress displaying True or False in a conditional cell Closed

    =IF(J7>=$M$4, IF(J7

    Rnfowler57 | Latest reply: Rnfowler57 Oct 8, 2014
    0 replies
  • Auto Sort groups of columns Closed

    Hello there, I (finally!) figured out the AutoSort macro, but I'd like to take it a step further if possible. I have columns A,B,C,D that I wa...

    aholden | Latest reply: aholden Oct 8, 2014
    0 replies
  • adding cells in excel from diff. sheets Closed

    Hello, Is it possible to add cells from different sheets in a single workbook. If so what is the formula? Thanks

    gizmo | Latest reply: An1 Oct 8, 2014
    4 replies
  • VBA Code Not working when modified Closed

    Hello! I have the following VBA Code on an Excel worksheet, which has been working fine up until today, when I modified it slightly (just changing ...

    CristinaSC | Latest reply: TrowaD Oct 7, 2014
    1 reply
  • how to convert Date to word in excel Solved/Closed

    how to convert Date to word in excel e.g. 05/01/1992 to change Five January, Ninteen Ninty two

    maheshprajap... | Latest reply: carminabigue Oct 6, 2014
    1 reply