Excel Forum

Ask a question
Search
Close
Results 1351 - 1400 of about 9,840
  • Macro to move data from one workbook to other workbook Closed

    Hi, I am working on two different workbooks, one of them is a scorecard and the other is the data entry workbook, I am trying to copy a lot of cell...

    srajgoswami | Latest reply: srajgoswami Apr 14, 2017
    0 replies
  • Copy cells to new sheet to create order form Closed

    I am trying to write code that will allow me to place an "X" in column A. In response I would like the cells in that line (B:E) to be copied into the...

    nicknebo | Latest reply: nicknebo Apr 14, 2017
    0 replies
  • Comparing columns and returning value Solved/Closed

    Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A...

    ll | Latest reply: kittu Apr 14, 2017
    35 replies
  • Compare two sheets in Excel Closed

    Hello, First, thank you for taking the time to help me understand how to execute this comparison. I have an excel file with two sheets. I need ...

    Workingonit2017 | Latest reply: Workingonit2017 Apr 13, 2017
    0 replies
  • Transfer multiple excel data from cells and moving to another wo Closed

    Hello, I would kindly appreciate your help in getting an answer to my question, which is, I have used "Find & Select," specifically Find & Replace...

    BobbyO | Latest reply: BobbyO Apr 13, 2017
    0 replies
  • Using Find & Select Closed

    Hello, I have used "Find & Select," specifically Find & Replace dialogue box to find specific values/data and then REMOVE, CUT, and Move to anothe...

    BobbyO | Latest reply: BobbyO Apr 13, 2017
    0 replies
  • Data in Hot Key Closed

    I want to put an email address in a hot key so I don't need to type it ever time.

    lbascom | Latest reply: lbascom Apr 13, 2017
    0 replies
  • how do i calculate VAT inclusive Closed

    Hello, how do i calculate VAT inclusiev? for example, TZS 849235 is vat inclusive, how do I take out the VAT? Taking VAT as 18% System Configur...

    moonga | Latest reply: Mazzaropi Apr 13, 2017
    1 reply
  • macro automatic numbering of invoices combined with letters Closed

    I want to know how to perform a macro for automatic invoice number combined with letters at the beginning for example XZY0001

    samba1309 | Latest reply: samba1309 Apr 13, 2017
    0 replies
  • Excel Logic Closed

    Hello, when i input R in cell, it shows a tex "ok" Or "Not Ok" in another cell

    Toihid | Latest reply: Toihid Apr 13, 2017
    0 replies
  • Split single excel worksheet into multiple worksheets Closed

    While I see many VB solutions 'almost' there, I don't see a solution for me. Challenge is I have client data where each set of data has 'Patient Code...

    Magoo0853 | Latest reply: Magoo0853 Apr 13, 2017
    0 replies
  • Conditional Formatting Closed

    Hello everyone, I'm trying to compare a table from one sheet to one on another sheet, and was wondering if its possible to copy the conditional forma...

    elchevez7 | Latest reply: elchevez7 Apr 12, 2017
    0 replies
  • Change of date Closed

    Hello, I Want to change date format mm/dd/yyyy to dd-mm-yyyy in MS Excel 2003 Please solve my problem urgently System Configuration: Windows ...

    karthi | Latest reply: BunoCS Apr 12, 2017
    1 reply
  • Import .pdf ...? Solved/Closed

    Hello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works for...

    RickRoll | Latest reply: RickRoll Apr 12, 2017
    2 replies
  • Use of macro for copy,Edit and Then Paste. Closed

    Dear All, I have a set of data covering 9 columns and 62 rows. (A1:I62). Now I want whole data of column 6 (F) to be changed to another data and so...

    SONIIPANK | Latest reply: SONIIPANK Apr 12, 2017
    0 replies
  • Comparing two spreadsheets using a third for comparison Closed

    Hi, I have two spreadsheets with same columns from different sources. I'm trying to use a 3rd spreadsheet to compare the two & show me any diffs. I...

    akuller | Latest reply: akuller Apr 11, 2017
    0 replies
  • arrow keys are not working Closed

    Hello, Arrow keys are not working in my laptop. System Configuration: Windows / Chrome 57.0.2987.133

    nandeesh n | Latest reply: nandeesh n Apr 11, 2017
    0 replies
  • Comparison Closed

    Hello, I want to create an excel sheet for data entery. There will be a two cases. Case-1:- The value of one cell is equal to value of another ...

    rakesh | Latest reply: rakesh Apr 11, 2017
    0 replies
  • Autopopulating multiple sheets from one main sheet Closed

    Hello, I'm making an quote workbook for an organization and I've run into a problem. On the first sheet "Main sheet" I input all of the transa...

    rwalia07 | Latest reply: rwalia07 Apr 11, 2017
    0 replies
  • Highlight date range if cell containing date falls within that range Closed

    Good day! I have a list of static date ranges and would like to highlight a range if a date occuring in that range populates in a different cell....

    Dispence8 | Latest reply: Zohaib R Apr 10, 2017
    5 replies
  • freezing column and row Closed

    Hello, how do you freeze first column and top row in excel?

    dellosa | Latest reply: vcoolio Apr 10, 2017
    1 reply
  • how to transfer file Closed

    Good morning Everyone, I have a Purchase Request list and l wanted to copy a data to one worksheet to another automatically once it's approved in ...

    JOUCE141989 | Latest reply: JOUCE141989 Apr 10, 2017
    0 replies
  • Change a cell content according with the color of another cell Closed

    Hello, I´m using Excel and need to change the VALUE of a cell (need to appear "-") if the COLOR of another cell is PURPLE. After digging around wit...

    Carlos | Latest reply: ac3mark Apr 9, 2017
    1 reply
  • Pasting and deleting macro Closed

    Hello, I need to create a macro that paste macro buttons from one spread sheet to another spread sheet, but when I try to do this and assign the mac...

    86dustin | Latest reply: ac3mark Apr 9, 2017
    3 replies
  • Nestle fomula nightmare!! Closed

    Sorry - fixing mini typo Hello - any help!! Going bald ripping hair out trying to resolve! I want to return a value "Q1" if a date falls between...

    Zaps11 | Latest reply: Zaps11 Apr 8, 2017
    4 replies
  • Need help on Excel macro Closed

    I need help to create a macro which helps me to get data from 'Sheet1' and paste that number of counts in 'Sheet2' for example, i have a table in s...

    Vaibhav | Latest reply: Zohaib R Apr 8, 2017
    1 reply
  • Highlight date range if date occurs within that range Closed

    I have a list of static date ranges and would like to highlight a range if a date occuring in that range populates in a different cell. How do I accom...

    Dispence8 | Latest reply: Dispence8 Apr 8, 2017
    0 replies
  • EDATE in excel help Closed

    Hello... I have a training for log for a large number of staff for various different courses which have all been completed at various different dates ...

    1Audrey | Latest reply: Zohaib R Apr 8, 2017
    1 reply
  • Excel for Mac date formatting Closed

    Hello, I have two columns one for the month/day and one for the year. When I formatted the month/day column it automatically adds the year in whi...

    roxwhit | Latest reply: Zohaib R Apr 8, 2017
    1 reply
  • Format excel data Closed

    Hello, i need to modify the data in my excel. Right now the data looks something like this: case A start 51 stop 55 ...

    ritika dhingra | Latest reply: Zohaib R Apr 7, 2017
    1 reply
  • Copy rows from one tab to another - if specific criteria in col Closed

    Hello, In a file, I am trying to copy data from one row of a worksheet if specific criteria are met in one column to another worksheet. Ex: ...

    schme73 | Latest reply: vcoolio Apr 7, 2017
    1 reply
  • EDATE Closed

    I have a training for log for a large number of staff for various different courses which have all been completed at various different dates and I wan...

    1Audrey | Latest reply: 1Audrey Apr 7, 2017
    0 replies
  • auto populate data from one sheet to a second Closed

    I am trying to have the information entered in the first 2 columns on sheet 1 transfer to sheet 2 in the same location automatically. There are appro...

    crownline04 | Latest reply: crownline04 Apr 6, 2017
    0 replies
  • Formula Solved/Closed

    I need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a colum...

    ehmetcalf | Latest reply: ehmetcalf Apr 6, 2017
    2 replies
  • Transferring Data from Multiple sheets to one Closed

    Hello, Disclaimer: I am new to macros and VBA, so reading the code is difficult, but I am making it a priority to learn. My problem. I track co...

    susiesarkozy | Latest reply: susiesarkozy Apr 6, 2017
    0 replies
  • Use Excel Template as a Sign In Form Closed

    Hello, I wanted to use an excel file as a sign in sheet. I need user to read the agreement that is presented on screen in an excel file. After read...

    BPatel | Latest reply: BPatel Apr 6, 2017
    0 replies
  • HELP FOR TIME REMINDER IN EXCEL Closed

    Hello, I entered some date in excel and I need to be reminded one day before that expected date !! How do I code it so that I will get a reminder ...

    Jerrychan38 | Latest reply: Jerrychan38 Apr 6, 2017
    3 replies
  • Graduate number in a cell Closed

    Hello, I have this database on Excel that I want to create. One of the columns will have the date of birth (DOB) and another column will have the...

    Femi | Latest reply: Mazzaropi Apr 6, 2017
    1 reply
  • Conditonal Formating Closed

    I have a training spread sheet that is used to track the due date of the training for our field personnel. We also use it to determine if the trainin...

    Lfarrow | Latest reply: Lfarrow Apr 5, 2017
    0 replies
  • software for finanicial Closed

    how can i get a software for account system tally ,quickbook

    abdulkadirmo... | Latest reply: ac3mark Apr 5, 2017
    1 reply
  • countif coloring of cells that were used. Closed

    Hello, I would like to color cells (or a row) that were used for "countif" values. for example, at my work, i have to indicate private calls f...

    Damian | Latest reply: ac3mark Apr 5, 2017
    3 replies
  • copying data from multiple workbooks Closed

    Dear all, Greetings of the day..!!! I m looking for a macro for the below requirement. There are multiple workbooks in a Folder, all workbook...

    Mudhamalle | Latest reply: Mudhamalle Apr 5, 2017
    0 replies
  • I cant get rid of the false function Closed

    Hello, I don't know whats wrong with this formula =IF(C4="Single",K4*1, IF(C4="Twin",K4*2, IF(C4="Quad",K4*4))) It keeps saying false in the ce...

    sc120915 | Latest reply: vcoolio Apr 5, 2017
    1 reply
  • copy data from multiple workbook in one new workbook. Closed

    Hello, I have 10 workbooks and have data on Sheet 2 with same Title from Column "B2:N2". All workbooks are in one folder. I want to create a ma...

    Dev saini | Latest reply: Dev saini Apr 5, 2017
    0 replies
  • Automatically copy contents from multiple shts to a summary sht. Closed

    Hello, I've an appointment sheet for each client of mine with their details. lets say like 50 sheets. I'd like to create a summary sheet from all ...

    Harris | Latest reply: vcoolio Apr 5, 2017
    1 reply
  • date in words Closed

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

    joraram | Latest reply: joraram Apr 5, 2017
    0 replies
  • Excel-copy data in single sheet & populate multiple sheet by PO Closed

    I'm in need of some guidance: Excel- I have one Master sheet with numerous Purchase Order # with multiple products associated with PO#. We want to sep...

    parakaki | Latest reply: parakaki Apr 4, 2017
    0 replies
  • Move dated cells up to the top of a list Closed

    Hello, I have a spreadsheet that I am using for calibration dates. I'm using the traffic light layout for the cells. I would like to know how to...

    Chris87 | Latest reply: Chris87 Apr 4, 2017
    0 replies
  • Compare data pairs Closed

    I do not know if it can be done using excell formuals, but i have a task: i have a table of 3 columns and about 15000 rows of data. I'd like to find...

    romeo.malancu.m | Latest reply: romeo.malancu.m Apr 4, 2017
    0 replies
  • Trying to propagate the status of a project Closed

    Hello! I need help with a timeline project I am working on. I am pretty basic in excel, but can follow instructions and usually fumble my way to succe...

    Meluch17 | Latest reply: Meluch17 Apr 3, 2017
    0 replies