Excel Forum

Ask a question
Results 2151 - 2200 of about 9,840
  • insert row based on criteria in EXCEL Closed

    hi friends, i'll get same data in two different sheet with a small changes, i will compare sheet one and sheet two, to create new sheet eg. (...

    raja | Latest reply: raja Aug 19, 2016
    0 replies
  • Creating a GANTT Chart with Calendar List of Tasks Closed

    Hello, Need help in creating a GANTT chart with a calendar function. For example, if according to the GANTT Chart Task 1 is due on the 25th of Octo...

    Oliver | Latest reply: Oliver Aug 19, 2016
    0 replies
  • Macro to make the same graphs on multiple sheets Closed

    Hello I have multiple sheets of data, all with the same formatting (although different numbers of data sets) formatted as a table. I am trying to ...

    Artemis | Latest reply: Artemis Aug 18, 2016
    0 replies
  • Insert 1 result if a cell contains one of several possibilities Closed

    Hi All, I am new to this level of excel - but what I need is a formula that does the following : Insert if an adjacent cell contains one of up ...

    Dan | Latest reply: Mazzaropi Aug 18, 2016
    1 reply
  • Copy values only when using a filter Closed

    Hello, VBA below, this is doing exactly what I want... however I can not get it to copy values only...not the formulas and a list which is in a co...

    Debs269 | Latest reply: vcoolio Aug 18, 2016
    3 replies
  • Preparing a commission worksheet from an excel spreadsheet Closed

    Hello, I am a payroll specialist. Every two weeks I run a report for all employees who have funded loans. I copy that information into another w...

    mel | Latest reply: mel Aug 17, 2016
    0 replies
  • Macro Closed

    Hello, in excel 2013 I have column of cells a:2:a4955 of the cell.interior.colorindex = 3 then I need to return "red" I can't get his to work.

    KarenPostell | Latest reply: KarenPostell Aug 17, 2016
    1 reply
  • copy paste data from one sheet to another automatically Closed

    Hello, First of all thanks for your wonderful site. I have a large set of information on one sheet. Column b has the name of the sheets in the ...

    ssdgeek | Latest reply: ssdgeek Aug 17, 2016
    12 replies
  • Copy and paste Closed

    Hello, i haven't done much lately with VBA so need some help please Copying from Sheets("Input (2)") to Sheets("New Items Added") The rows o...

    Debs269 | Latest reply: Debs269 Aug 17, 2016
    0 replies
  • Create Duplicate Sheet Closed

    Hi all, Is it possible to create a worksheet automatically in the same excel workbook. For e.g i have a sheet "1" with some content (includes f...

    MAasifkhan | Latest reply: PoulJ Aug 17, 2016
    1 reply
  • Auto-copy rows from one tab to another based on cell value Closed

    Hello! I'm really hoping this works to get a response because I am stumped. I've read a lot of sites and lot of similar posts but nothing seems to...

    Marissa Garrock | Latest reply: fdibbins Aug 16, 2016
    1 reply
  • Nested if functions using time values Closed

    Hello, I have an excel formula here, but it wont work. =IF(AND(G2>=TIMEVALUE("06:00:00"))*(G2=TIMEVALUE("00:00:01"))*(G2

    Dannnnn0710 | Latest reply: fdibbins Aug 16, 2016
    2 replies
  • Auto Fill in for List - based on another cell's value Closed

    Hi! I have different sections of an excel document that feature the same lists over and over again. Sometimes the values selected will be different...

    seh09 | Latest reply: fdibbins Aug 16, 2016
    1 reply
  • Copying data from 1 sheet to another using a macro Closed

    Hello, I am trying to copy data from a specific cell on one sheet (Invoice) to the next blank cell in another sheet. My macro was working well in ...

    Jen | Latest reply: Jen Aug 16, 2016
    0 replies
  • Cut paste data into the left cell of the row below Closed

    Hello, I have a worksheet with hundreds of thousands of rows and its conditionally formatted to show 2 different colors. Here is a screenshot of ...

    Yathin | Latest reply: Yathin Aug 16, 2016
    0 replies
  • how could I do automatically find the price Closed

    Hello, I have question for Excel, it is small hotel booking system? If I have for example 6 rooms, and they have all different prices, i.e. 1...

    Damir | Latest reply: Mazzaropi Aug 16, 2016
    1 reply
  • Copy row if criteria is met macro Closed

    Hello, I am looking to make a macro that will copy the entire line from sheet 1 to sheet 2 if criteria from column H is met. Essentially if th...

    Ram | Latest reply: Ram Aug 16, 2016
    4 replies
  • Starting new sheet from info gained in sheet one Closed

    Hi I am trying to replace a hard cover book and a manually written piece of paper with the spreadsheet. I work in the building industry doing insu...

    RCJ1975 | Latest reply: RCJ1975 Aug 15, 2016
    0 replies
  • copy range of cells and paste them multiple times Closed

    Hi all, My VBA / Coding skills are basic and I've been googling to try to find an answer to my question to no avail. I'm trying to copy a range of...

    bm63081 | Latest reply: bm63081 Aug 15, 2016
    0 replies
  • Compare columns and create list of duplicates Solved/Closed

    Hello I am a complete newbie when it comes to VBA code but I tried to set up a macro with examples I found online. Let me explain my needs. I have a ...

    CarlosIRL | Latest reply: CarlosIRL Aug 15, 2016
    2 replies
  • Auto Generate a copy of a Template Worksheet and rename each Closed

    Hello, I am very new to Excel and VB and am trying to create a macro that will do the follow; 1. Create a copy of a template worksheet (named Tem...

    ChukieD | Latest reply: vcoolio Aug 15, 2016
    2 replies
  • Conditional Formating of cells Closed

    Hello, I am trying to set up the conditional formats of cells as follows :In column D place the company name - have the next 13 cells to the right t...

    Spike | Latest reply: fdibbins Aug 15, 2016
    1 reply
  • help need sample of master sheet Closed

    hi can give a sample of using excel in exam committee

    zead | Latest reply: zead Aug 14, 2016
    0 replies
  • Copy data from one sheet 1 to sheet 2 only if text Closed

    Hello, I have sheet 1 tracking a lot of different information (Client name, date in, date put etc...) for 2 machines. (Machine A & Machine B) N...

    Loo0105 | Latest reply: fdibbins Aug 14, 2016
    1 reply
  • need help to macro my invoice number Solved/Closed

    Hello, I wish to increment my invoice number everytime I open my invoice....format is 1-2015-001 and increment by one 1-2015-002 should be the next...

    Janit | Latest reply: ac3mark Aug 12, 2016
    6 replies
  • Alphabetical arrangement Closed

    What formula do you use to arrange items or values in alphabetical order in Excel?

    profebo1 | Latest reply: profebo1 Aug 12, 2016
    0 replies
  • Pivot table help Closed

    Hello, I really hope someone can help me out with this. I would like to know how can I get excel to automatically fill the data (I specified wi...

    dgname | Latest reply: dgname Aug 12, 2016
    0 replies
  • Excel Macro Copy if Criteria is met in a column Closed

    Hello, I have two sheets and the plan is after the "TotalScores" sheet is filled out, the second sheet "NOPA" will be filled with a macro. For...

    Ram | Latest reply: Ram Aug 12, 2016
    0 replies
  • search value error Solved/Closed

    HI, The value for false refuses to come up as a blank cell in my formula to find and copy a cell if it contains certain initials, or leave it blank i...

    Stu | Latest reply: Mazzaropi Aug 12, 2016
    3 replies
  • Selecting the different Range of cells based on values Closed

    Hi all, consider the Excel sheet A B C D 1 NAME CITY AGE CLASS 2 ALEX NEWYO...

    AKILSYED | Latest reply: ac3mark Aug 11, 2016
    1 reply
  • Information automatically updated Closed

    Hi, So I am creating a file for my boss on excel 2016 that I want to automatically update information from one table to the other without me havin...

    justahumblea... | Latest reply: ac3mark Aug 11, 2016
    1 reply
  • Need help with conditional formatting. Closed

    Hello, I need to have my spreadsheet enter a date that is 6 months (180 days) from an original date once it is entered. I have 2 columns - Date Pl...

    JessaSteele | Latest reply: Mazzaropi Aug 11, 2016
    1 reply
  • Searching and Replacing Dates Closed

    I need to search and replace dates. For example, in one row (representing one employee), all dates prior to 8/9/16 and replace those dates with 8/9/1...

    FranBacAero | Latest reply: TrowaD Aug 11, 2016
    1 reply
  • automatic numbering of invoices in excel Closed

    How do I create a macro for sequential invoice numbering in Xcel

    Steve | Latest reply: TrowaD Aug 11, 2016
    1 reply
  • Need a formula to compare two columns and return a value of 1 Closed

    Good Morning, I need a formula that will compare two different columns and then return a value of one if certain criteria are met. The criteria: ...

    alinville | Latest reply: TrowaD Aug 11, 2016
    3 replies
  • Once the value is one, change cell in the right column Closed

    Hello, I am in a struggle here :/. Let's say I have a table with 2 data columns. The first one is "phase", the second one is a "due date" which...

    Eucram | Latest reply: Eucram Aug 11, 2016
    0 replies
  • Invoice sequential numbering Closed

    Hello, excel macro auto invoice numbering

    Steve | Latest reply: Steve Aug 11, 2016
    0 replies
  • =IF(SEARCH("BP",Sheet1!B4),Sheet1!B3,"") Closed

    The value for false refuse to come up as a blank cell in my formula to find and copy a cell if it contains certain initials. why? =IF(SEARCH("BP",S...

    Stu | Latest reply: Stu Aug 10, 2016
    0 replies
  • Nested If Statement not working Solved/Closed

    Hello, I am trying to use nested excel IF(And) formula. here's my logic table If O4=Planned,TRUE, FALSE TRUE =IF(AND(I6>=C7,I6=F7,I6=C7,I6=F7,I...

    Mimi | Latest reply: Mimi Aug 10, 2016
    2 replies
  • Macro - pictures to excel acc to name Solved/Closed

    Hi, I have an issue - I checked all forums I could, but with office 2013 and changed excel functions, I got lost. My excel has pictures names in...

    Northimn | Latest reply: Northimn Aug 10, 2016
    2 replies
  • Pull just the description from old spreadsheet to new spreadshee Closed

    Hello, I have two spreadsheet one (new) that has parts and pricing. I have an old spreadsheet that has same parts and old pricing and descriptions....

    Sunshine | Latest reply: Sunshine Aug 10, 2016
    0 replies
  • copy data from monthly workbooks paste in a single workbook Closed

    Hi Team, I want a Macro which can assist on the following time consuming task: I need to copy data from monthly workbooks (each having only 1 sh...

    peerreh | Latest reply: peerreh Aug 10, 2016
    1 reply
  • Unable to fill formula in the range which has been set. Closed

    Hello, I have created vba to creatable from the consolidated data in a sheet1. After a table structure is created, the macro will populate the val...

    AgniArul | Latest reply: ac3mark Aug 9, 2016
    1 reply
  • help on running two code auto when opening Excel workbook Closed

    Hello guys i need some help about merging two or more code on vba i used this code and it helps for only one code: Private Sub Workbook_Open() ...

    Saeed1373 | Latest reply: TrowaD Aug 9, 2016
    1 reply
  • conditional formatting. Closed

    Hi, I have prepared a master sheet in which we enter the data. There are different sheet in the same file which will use the same data but not simult...

    hmnanavati | Latest reply: TrowaD Aug 9, 2016
    4 replies
  • copying a name range Closed

    Hello, Am struggling here and i need help please. I have defined a name range in the name box and it is B20:B30 and given it a name: Data. some...

    Saif | Latest reply: Saif Aug 9, 2016
    0 replies
  • Comparing two sheets for mismatch Closed

    sheet1 abcd 18383 91939 82838 3828 ...... cdef 29832 82738 28392 2938....... xywz 23872 237 28 27382 6727...... sheet2 cdef 2983...

    excelraj | Latest reply: excelraj Aug 9, 2016
    0 replies
  • Formula please! Closed

    Hello, Can you help me with this data. What formula can I use? If 18:00 to 18:59 = 1 If 19:00 to 19:59 = 2 If 19:00 to 19:59 = 3 If 20:00 to...

    thepishoner | Latest reply: fdibbins Aug 8, 2016
    4 replies
  • copy rows of data based on cell value Closed

    Hello, I have a spreadsheet with multiple tabs and I want to copy entire rows based on the value of a column - for example I have a column named Acc...

    Jean | Latest reply: Jean Aug 8, 2016
    0 replies
  • Automaticaly populate activity sheets from master sheet. Closed

    Hi all, I am a volunteer working for an organization helping veterans. We run several activities as part of their rehabilitation and re-integration b...

    Jacko | Latest reply: vcoolio Aug 8, 2016
    3 replies