Excel Forum

Ask a question
Search
Close
Results 2051 - 2100 of about 9,840
  • pop up reminder vba Closed

    hello everyone, i have very little knowledge about excel vba, actually i am making an excel file. i want it have pop...

    dennisda | Latest reply: Rthmanden Sep 13, 2016
    1 reply
  • Excel templates to PDF Closed

    Hello, I am delighted to use the forum for the first time. I encounter an issue with my excel vba function. Not being a coder, I went online l...

    coolworld | Latest reply: coolworld Sep 13, 2016
    0 replies
  • validation code Closed

    Hello, Why can't I get a validation code? Configuration: iPhone / Safari 4.0

    lucyee | Latest reply: BunoCS Sep 13, 2016
    1 reply
  • format a group of cell by referring to a series of number Closed

    Dear Sir, How to format a group of cell by referring to a series of number with different color. The color will change accordingly when the number ...

    ahgogo68 | Latest reply: ahgogo68 Sep 13, 2016
    0 replies
  • cut and paste a range of cells if two cells are duplicates Closed

    I have a spreadsheet of documents that are in revision along with their status and other criteria that change daily. Row B contains the individual do...

    jzoldos | Latest reply: jzoldos Sep 12, 2016
    0 replies
  • Conditional formatting using dates Closed

    Hi, Can anyone help please? I have: a column (E) of cells each containing options from a dropdown list named "MINOR" "MAJOR" "CRITICAL" ...

    cforts | Latest reply: cforts Sep 12, 2016
    0 replies
  • Another copy from Master to specific sheets Closed

    Hello everyone, First post here and I am not, by any means, an excel expert (my husband thinks he is, which is why I'm here, lol). So here is my qu...

    grunt9800 | Latest reply: vcoolio Sep 12, 2016
    12 replies
  • Macro for looping charting data keyed from two columns Closed

    Hello and thank you anyone for reading this. I have a quandary that is beyond my VB skills and am looking for any help possible. I need to find a ...

    jbrazzle | Latest reply: ac3mark Sep 12, 2016
    3 replies
  • Question about Macros Closed

    Hi, I'm looking for help regarding macros/ adjusting a macro. My issue: I'm trying to copy and paste macros from 100s of files to 1 master f...

    S.A.Mathur | Latest reply: S.A.Mathur Sep 12, 2016
    0 replies
  • macro to create new workbook and copy data Solved/Closed

    Hello I am looking for macro to copy rows based on partial cell content of a column. I have an excel spreadsheet called "arc.xlsx" from which I wou...

    sujith | Latest reply: Rthmanden Sep 12, 2016
    26 replies
  • Macro to move data between sheets on condition Closed

    Hello, I am a beginner to using Macros in excel. I understand there are lots of things on here, and the internet in general, telling you how to cre...

    Carrie | Latest reply: vcoolio Sep 12, 2016
    3 replies
  • Need cells to populate with text when I add text to a 3rd cell Closed

    Hi.. Don't know if this is possible, I have searched online in various excell sites including excel sites from office. What I want to do is... ...

    welshcowboy | Latest reply: welshcowboy Sep 12, 2016
    0 replies
  • Using 1 Macro on Multiple Files Closed

    Hi, I'm trying to copy and paste macros from 100s of files to 1 master file in excel. I'm using macros to do this however I have to open or download...

    S.A.M | Latest reply: S.A.M Sep 10, 2016
    0 replies
  • Issue: Linked Worksheets won't autopulate format Closed

    I'm trying to create an excel workbook that keeps track of each of my files which are labeled by the client's last name and file number. Each file on ...

    foreal | Latest reply: foreal Sep 9, 2016
    0 replies
  • How to copy the format from one cell to another Closed

    Hello, I have a table SalesPeople (Code and Name). Every code is unique. I have added a colour on each code and name (each row). Then I have an...

    Thomas | Latest reply: Thomas Sep 9, 2016
    0 replies
  • Excel Date Formula (IF) Closed

    Hello, I'm in need of some assistance with an excel date formula. I'm need to look at 2 cells in the same row which contain dates or may be NULL...

    JackSoup | Latest reply: Mazzaropi Sep 9, 2016
    1 reply
  • Copying Data Closed

    Hello, I presently have stock sheets with details of suppliers, items, quantities held-in stock and on display, price, etc. Whenever I reduce the q...

    EllyGee123 | Latest reply: vcoolio Sep 9, 2016
    1 reply
  • Verify dates in 2 cells < specific date - write Yes or No Closed

    I'm looking for a formula which will look at 2 cells in the same row which contain dates or may be NULL and determine if either of them are greater th...

    JackSoup | Latest reply: JackSoup Sep 8, 2016
    0 replies
  • Accounts receivable aging formula Closed

    I need help with accounts receivable aging formula. A1 IS TODAY'S DATE G4 IS BILLING DUE DATE H4 IS PAYMENT RECEIVED I4 IS DATE RECEIVED K4 ...

    Reese816 | Latest reply: Reese816 Sep 8, 2016
    0 replies
  • Macro for copy the data from several excels to one excel Closed

    Hello, Hi, I need help for write a macro for copying the text data from several excels and paste the same data in the form of columns in other exce...

    Gurunadh | Latest reply: Gurunadh Sep 7, 2016
    0 replies
  • short cut between 2 sheet Closed

    can someone show me a short cut how to transfer a date or number from sheet 1 to sheet 2.

    soccerball | Latest reply: ac3mark Sep 7, 2016
    1 reply
  • Chart out a grid using excel Closed

    How can I build a grid using an existing excel sheet that already has the cell references and the name. This document has four groups each containing ...

    Syb | Latest reply: ac3mark Sep 7, 2016
    1 reply
  • Conditional formating Closed

    i have a row of initials: MM MM MM MM LL LL LL BB XX XX MM CC CC CC, each pair is a column these correspond to booking dates, so if the initial next...

    Mack | Latest reply: xpcman Sep 7, 2016
    1 reply
  • to get notification in outlook from excel Closed

    hi iam using excel for my work and i am trying to manage due dates ie if a due date is arrived it shoud be be notified in outlook as notification with...

    kishkmr88 | Latest reply: xpcman Sep 7, 2016
    1 reply
  • Copy potential data from one sheet to another if condition met Closed

    Hello, I have a very specific formula request, or at least a request for direction on how to write/learn to write it. I have two sheets of data,...

    Kyle | Latest reply: Kyle Sep 7, 2016
    0 replies
  • Conditional formatting between 2 different columns Closed

    Hello, If someone can please help me. I have 2 columns. One column needs to be formatted w/ a specific color within a range of numbers depending o...

    Rob P. | Latest reply: Mazzaropi Sep 7, 2016
    1 reply
  • Command Button to Move Data from One Sheet to Another Closed

    Hello, I have a report with data from column A:AD. I also have a status column. I want to remove data with a specific status from the one sheet ...

    Red | Latest reply: Red Sep 7, 2016
    0 replies
  • Compare values in two columns and return the value from third Solved/Closed

    Hello, I've a table containing four columns. If the values in the first two columns match to particular value (eg. A1="xxxx" and B1="yyy"), I need...

    ramdubai | Latest reply: keshav Sep 7, 2016
    11 replies
  • Monthly to Daily Schedule Automation Help Closed

    Hello, I am posting this again as I believe there were some issues with my original post. Thanksin advance!* I am looking for some assistance o...

    jjkraus | Latest reply: jjkraus Sep 6, 2016
    0 replies
  • Conditional Formatting Closed

    Hello, I have 2 columns. One column needs to be formatted w/ a specific color within a range of numbers depending on the number in the other colu...

    Rob P. | Latest reply: Rob P. Sep 6, 2016
    0 replies
  • Need help configuring for patient data Closed

    Hello, Ok I have a spreadsheet with different patient names. If they are inpatient then there is a column that is blank. Once they are discharged...

    Turtleann | Latest reply: Turtleann Sep 6, 2016
    0 replies
  • Place specfic text in cell based on text in an adjacent cell Solved/Closed

    Hello Folks, Per the preface, I have a cell that has validation rules of "Concur, Non-concur". If the user selects "Non-concur" for that cell, I ...

    RKF-CCM | Latest reply: TrowaD Sep 6, 2016
    5 replies
  • Change format of a cell when another cell is not null Closed

    How do I highlight a cell or row when another cell contains anything? Thanks!

    klor | Latest reply: Mazzaropi Sep 6, 2016
    1 reply
  • every day the date changes Closed

    say for example A1 is 9/4/2016 the next day when ever i open that sheet then the new date appear in A2 as 9/5/2016 the same continues on till the...

    John | Latest reply: John Sep 4, 2016
    0 replies
  • My spellnumber to Thai Baht. Closed

    Hello, I Can change the Number into Spell but the problem is it does not convert in Thai Baht. Present Situation =SpellNumber(58.20) = Fifty Dol...

    Jenny | Latest reply: Jenny Sep 4, 2016
    0 replies
  • Entering Data in a column for prescribed number of times. Closed

    Hello, How to enter a specific word from from one excel sheet into a column in another excel sheet for a number of times mentioned in the first s...

    Prof. Ghonasgi | Latest reply: Prof. Ghonasgi Sep 4, 2016
    0 replies
  • Conditional formating Closed

    Hello, I'm trying to make multiple cells turn red if a single cell has a certain value. So for example is B3 says "abc" cells B3:F21 should turn r...

    Ducky | Latest reply: Mazzaropi Sep 3, 2016
    1 reply
  • VB code for manual entry in range of cells Closed

    Hello, In my work sheets the values in some of the cells in range are determined through formula. When someone wants to change the value manually...

    kt | Latest reply: kt Sep 3, 2016
    0 replies
  • blinking cell Closed

    Use hyperlink addressing in Excel cells, to go to an other cell within same workbook. Can anyone advise how to program VBA to make the targuet cel...

    kaalhodet | Latest reply: kaalhodet Sep 3, 2016
    0 replies
  • Copying unique data that ends with a specific character Closed

    Hello, I want to create a workbook that has a main input worksheet, then automatically copy new data that ends with a specific character to a spec...

    Don | Latest reply: Don Sep 3, 2016
    0 replies
  • using "if" in correlation with "date" Closed

    Hello i'm trying to fill up specific cell on one sheet on a certain date and the content to go on another specific cell on other sheet. EG: on 3rd...

    luk | Latest reply: luk Sep 3, 2016
    0 replies
  • How to disable edit option once data inserted Closed

    Hello, I need help can any one help me on the below query once data entered in excel it shouldn't edit by anyone Configuration: Windows ...

    Siva | Latest reply: Siva Sep 2, 2016
    0 replies
  • need to summarise data Closed

    Dear All, Link to my document. https://drive.google.com/file/d/0B1ApeEMIB_lNVG12aWVmVzdLS2M/view?usp=sharing I need to summarise data as show...

    japlytus | Latest reply: japlytus Sep 1, 2016
    0 replies
  • Find duplicate rows and copy content of one cell to new sheet Closed

    Hello, I'm totally new to macros and excel. I have an excel spreadsheet with huge data in it (over 9lakh rows). There are many entries that are ex...

    pacchiee | Latest reply: pacchiee Sep 1, 2016
    5 replies
  • Macro to add number of rows correspond with number in cell Closed

    Hello, I need a macro that can dictate the number of rows to add after a line based on the number that is in the column. For example: Actually...

    Heidi | Latest reply: Heidi Sep 1, 2016
    0 replies
  • EXCEL - blank or contains zero Closed

    Hello, I am looking for the formula to solve this issue and return my answer in cell D: if the value in cell A is less than or equal to cell B th...

    Iain170 | Latest reply: Iain170 Sep 1, 2016
    0 replies
  • How to send an email automatic when a cell is updated Closed

    Hello guys, I am imports coordinator I have a tracker created in excel worksheet which I use to track our shipments that arrive at port then proce...

    John | Latest reply: xpcman Sep 1, 2016
    1 reply
  • Monthly Calendar/Daily Schedule Automation Closed

    Hello, I am looking for some assistance outputting data from a monthly calendar to individual daily schedules. I inherited this project that initi...

    jjkraus | Latest reply: jjkraus Sep 1, 2016
    0 replies
  • comparing data among excel sheets Closed

    Hello, I have three excel sheets with data regarding product numbers and their respective plants as well as another sheet (4th sheet) which is a t...

    Da Chef | Latest reply: TrowaD Sep 1, 2016
    1 reply
  • Finding the @ character within a text, cell range Closed

    Hello, I can't seem to find anything that's specific to what I'm looking for. I'm trying to find a formula that will tell me the following: ...

    Jaye | Latest reply: TrowaD Sep 1, 2016
    1 reply