Excel Forum

Ask a question
Search
Close
Results 2901 - 2950 of about 9,850
  • Macro to copy and paste rows until blank comes Closed

    Hello, Can anyone help me to write macro code for the below condition. I have data sheet which updates on a daily basis and no. Of rows with r...

    Emmanuel | Latest reply: Emmanuel Jan 16, 2016
    0 replies
  • Excel Filter/Macro Solved/Closed

    Hello, Thank you in advance for any time/help you can offer! I'm working on a contact list in Excel and I need to be able to filter my contacts i...

    LSKM | Latest reply: vcoolio Jan 15, 2016
    4 replies
  • Run-time error with copy-and-insert rows macro Closed

    Hi, I am using the following macro to copy and insert rows in an Excel spreadsheet, based on a user inputted value. I place the cursor in the desire...

    Greg | Latest reply: Greg Jan 15, 2016
    12 replies
  • How to automate copying cells from one workbook to another. Closed

    I need a VBA, macro or some way to be able to load cells from one workbook to another. The first workbook has the cells I need on one row, I need to c...

    smoothsa | Latest reply: smoothsa Jan 15, 2016
    0 replies
  • Colours for dates that are on 2 & 3 month cycles Closed

    Hello, In my current role, I have a number of people that I have to assess. I would like to be able to do the below so i can easily identify who i...

    akers | Latest reply: ac3mark Jan 14, 2016
    1 reply
  • Columns & Rows Help Solved/Closed

    Hello all, In short, here is what I need help doing: I would like to take 15 items in one column and transfer them into a row in another spread...

    futurepsych92 | Latest reply: futurepsych92 Jan 14, 2016
    5 replies
  • Formula for if cell contains word, assign value for multiple Closed

    Hello, I am looking for a formula to help me assign a value for multiple words and values. If column A has the contains Apple, assign X. IF i...

    hdiesel | Latest reply: ac3mark Jan 14, 2016
    1 reply
  • Highlight Dates for 3 or 2 month cycles Closed

    Hi, I manage a number of staff and have to assess them. I want to be able to do the below so i can easily identify who is close to the time limit. ...

    akers | Latest reply: akers Jan 14, 2016
    0 replies
  • Excel Filter Question Closed

    Hello, I'm working on a contact list in Excel and I need to be able to filter my contacts in a few different ways. Each contact is in a row and ea...

    LSKM | Latest reply: LSKM Jan 14, 2016
    0 replies
  • Excel conditional formatting Closed

    Hi All, I need your help with conditional formatting please? I've a project timeline on a week and month calendar form. I've applied conditiona...

    Danieeeella | Latest reply: TrowaD Jan 14, 2016
    3 replies
  • forget password of Excel file Closed

    Hi, All friends I have forget password for my excel files to open, can any one help me to open this file. I have attached picture of problem. ...

    musharafpk | Latest reply: musharafpk Jan 14, 2016
    0 replies
  • get last used column address using current region property Closed

    Greetings, I have attached an image a look like of my input file. In this, I need to get the address of the highlighted portion. I have used 1 as t...

    Poojapriya | Latest reply: Poojapriya Jan 14, 2016
    0 replies
  • 25% of a cell if text in another? Closed

    Hello, I was wondering if someone could help me with the formula for 25% of a cell if another cell has text in it to give me the sum total of a ra...

    ojitos | Latest reply: ojitos Jan 13, 2016
    0 replies
  • Excel data transfer between separate spread sheets Closed

    Hi guys, I have a table in the spreadsheet that I want to transfer data from to another spreadsheet. The thing is that even though not every field ...

    dynamit3 | Latest reply: dynamit3 Jan 13, 2016
    0 replies
  • Need to search an excel spreadsheet column Closed

    but hoping I'm wrong? Need to search an excel spreadsheet column (say column D) for all rows with the text "3 Pounds" If the text is found in a cel...

    heyhere | Latest reply: heyhere Jan 13, 2016
    1 reply
  • conditional formatting Closed

    Hello, I need a help from you . Am trying to give three color condition in a pivot table and slicers report. We have sheet with Pivot table ...

    Sriram | Latest reply: Sriram Jan 13, 2016
    0 replies
  • Bringing similar names of different spelling together Closed

    Hello, I have 2 similar files. each has several columns of information. each row for one person. 80-90 % of the rows in 2 files are the same person...

    Hafez Gorgani | Latest reply: Hafez Gorgani Jan 13, 2016
    0 replies
  • formula if you have credit in one column, debit in next column Solved/Closed

    Hello, what is the formula if you have credit in one column, debit in next column and balance in 3rd column. Many thanks R Horner Configurat...

    Jack | Latest reply: Jackthelad Jan 13, 2016
    4 replies
  • Macros Invoicing drop down list Closed

    Hello, Hope everyone it doing well. I am looking for some help with Excel 2010. I have a template that I use to invoice my customers. My customer ...

    snorklemanjd | Latest reply: ac3mark Jan 12, 2016
    1 reply
  • Excel right and left arrows not working properly Closed

    Hello, I spilled Coke on my laptop this afternoon and while frantically trying to remove it I pressed something that has inserted some kind of pr...

    Renatta | Latest reply: Renatta Jan 12, 2016
    0 replies
  • how excel displays ascending order of data in other spreadsheet Closed

    hello, I try to prepare data of students details with random serial no.s in one excel spreadsheet. How I link it to display ascending order i.e.sma...

    akshay@kumar | Latest reply: TrowaD Jan 12, 2016
    1 reply
  • Data subsets and duplicates Closed

    Hello, I have been trying to find the answer in a few forums but haven't found quite what I'm looking for. I have a column (A) of around 2000 n...

    ResearchFellow | Latest reply: TrowaD Jan 12, 2016
    1 reply
  • need a cell to change colour if another cell has an 'x Closed

    hello, i need a cell to change colour if another cell has an 'x' in it. so if cell r14 has an x in it cell r13 turns green can anyone help? tha...

    Martin | Latest reply: vcoolio Jan 12, 2016
    1 reply
  • Excel conditional formatting w/date range and containing text Closed

    Hello, I need to make a conditional format based on the date in a cell being between 30-60 days past today's date and only if another cell contain...

    debbie | Latest reply: Dani Jan 12, 2016
    2 replies
  • Date format not changing! Closed

    I exported some data from a CRM system and the date exported like: Dec 9 2015, 3:00 PM I need to change this to: 12/9/2015 I've tried chan...

    jena206 | Latest reply: jena206 Jan 11, 2016
    0 replies
  • Excel date formula won't change Closed

    Hello, I exported some data from a CRM system and the date exported like: Dec 9 2015, 3:00 PM I need to change this to: 12/9/2015 I've tried...

    Jen | Latest reply: Jen Jan 11, 2016
    0 replies
  • conditional Formatting cell in a column vs a cell in other col. Closed

    Hello, I am comparing two cells in two different columns. I will do this for the 124 rows. if column G cell let's say G7 is larger than B7 then G...

    jjpcpanama | Latest reply: jjpcpanama Jan 11, 2016
    0 replies
  • Help with Sumif function please.. Closed

    Could someone please help me?? I need to sum the values of a range of cells that contain certain text (product codes) into another cell. For example...

    sterjohn | Latest reply: aquarelle Jan 9, 2016
    1 reply
  • if condition Closed

    if a2=mathura then result plm a2=agra and b2

    AMIT | Latest reply: aquarelle Jan 9, 2016
    1 reply
  • How to re/name a cell if another cell contains X Solved/Closed

    Hello, Apologies if this is a simple question but having some trouble figuring it out. I have say 1000 rows of data and I need to label them all...

    Alexzandeur | Latest reply: vcoolio Jan 8, 2016
    5 replies
  • Screen is locked - its not scroll lock Closed

    Hello, My screen wont move up or down, neither from cell to cell. Its not the scroll lock function. Anybody know what function I activated by mi...

    Carien | Latest reply: Carien Jan 8, 2016
    0 replies
  • Data arrangement Closed

    Hello, I have 2 sheets in an Excel workbook. I am trying to code certain cells in a pre-made template on Sheet 1 to automatically sync with my dat...

    apple78 | Latest reply: vcoolio Jan 8, 2016
    1 reply
  • Define a default path for macro enabled template file (saving) Closed

    Greetings, I have created a macro enabled template file named test.xltm. Double click on the file opens a file named test1. on choosing save as res...

    maya | Latest reply: maya Jan 7, 2016
    0 replies
  • fill in automatically Closed

    Hello, I have two colum in excel sheet colum A1 contain big list of job titles each one of it have a code for example: Job Title name ...

    iSaeed11 | Latest reply: iSaeed11 Jan 7, 2016
    2 replies
  • Macro Help Closed

    Hello All, In short, this is the issue I am facing: I have created a macro to copy and paste data from one spreadsheet to another. Specifically,...

    futurepsych92 | Latest reply: futurepsych92 Jan 6, 2016
    2 replies
  • copy data from 2 sheets in 1 workbook to new workbook Closed

    Hello, I am new to macros in Excel and could use any help. I want to copy the basic name and customer info from 1 sheet(1) and create a new workb...

    DoubleDDD | Latest reply: DoubleDDD Jan 6, 2016
    2 replies
  • Can I get the Autofilter to work automatically without Closed

    I have the following which is filter my data based on a cell: Private Sub Worksheet_selectionchange(ByVal Target As Range) If (Intersect(Target...

    Matt | Latest reply: Matt Jan 6, 2016
    3 replies
  • How to transpose and move data Closed

    Hello, Have a data set which is 2 columns and 596 rows, in which I need to transpose parts of the data set, remove empty columns, and then line up...

    Alex | Latest reply: Alex Jan 6, 2016
    2 replies
  • conditional data display depending on a dropdown list Closed

    Hello, I would like to creat a form which would display certain data dependent on what was chosen in a dropdown list. For example, if my dropdown...

    Paskie_be | Latest reply: rizvisa1 Jan 6, 2016
    3 replies
  • Create new workbook copying data from 2 sheets in same workbook Closed

    I want to copy the basic name and customer info from 1 sheet and create a new workbook with that customer's name as part of the file (and copy several...

    DoubleDDD | Latest reply: DoubleDDD Jan 5, 2016
    0 replies
  • IF Formula Query Closed

    Hi there, I have a spreadsheet which using the IF formula should be bringing back either "update Required" or "N/A" depending on if the date in the...

    eterry | Latest reply: rizvisa1 Jan 5, 2016
    1 reply
  • Data consolidation Closed

    Dears Need your expertise advice. I have an excel data in below format , need a formula Column 1 has text like ABA, ABA , ABB, ABC, ABC, ABC . ...

    Karthikeyan1207 | Latest reply: rizvisa1 Jan 5, 2016
    8 replies
  • How to create a macro to update a file based on a masterfile Closed

    Hi I would like to create a macro (program) which will update a file by clicking on a button, based on a masterfile. Basically I have a list of ...

    ExcelPam | Latest reply: ExcelPam Jan 5, 2016
    0 replies
  • Transferring data Closed

    Hi, I use excel 2007 version. I have some data in an excel sheet - students' names, ids, test items attempted, multiple attempts made by each st...

    sailajaravik... | Latest reply: sailajaravikanth Jan 4, 2016
    0 replies
  • Transfering data for a spreadsheet to another Closed

    Its not working. May be size (row height & Column Width) not same. Is there any other way to solve this problem.

    Amit.kumar@3 | Latest reply: ep2789ccm Jan 4, 2016
    3 replies
  • Conditional format only if different from cell in another sheet Closed

    Hello. I am using Excel 2011 on a Mac. I have two sheets in my worksheet. Both sheets are a two week schedule. Sheet 1 is titled PP - it is the ...

    Jambo818 | Latest reply: Jambo818 Jan 4, 2016
    0 replies
  • auto-copy cells one to another + formation too Closed

    Hi! I want to make intelligent excel, like.. i have many sheets and i want it to work the way, that sheet2 takes data from sheet1. so 1) ...

    nullun | Latest reply: nullun Jan 3, 2016
    1 reply
  • set a conditional formatting to highlight the latest number Closed

    I have a column to record invoice numbers in this formatting KI-00123 where the number portion is in running order. How do i set a conditional formatt...

    littleclam | Latest reply: littleclam Jan 3, 2016
    0 replies
  • Strike through when entering date Solved/Closed

    Hello, In excel I have a row of information in six different cells. The first cell and last cell have a date format. When I enter the last d...

    Bill | Latest reply: vcoolio Jan 2, 2016
    3 replies
  • Place new Code to Working Code Solved/Closed

    Hello, I would like to request that some line of code (marks as bold) I have to place in the Working Code which is given below that I cannot figure...

    smuneeb | Latest reply: smuneeb Jan 1, 2016
    2 replies