Office Software Forum

Ask a question
Search
Close
Results 2901 - 2950 of about 16,600
  • Cell updated when if condition is changed (macro) Closed

    Hello, Can anyone help me with a simple thing I cannot get done ? Using a macro, I want the value (integer) of a cell to be changed depending o...

    Jerry | Excel | Latest reply: TrowaD Jun 16, 2016
    3 replies
  • Macro to send an email when a cell value changes to an email Closed

    Hello, I use Office 2013 for everything. I am trying to write a macro that will send an email from outlook to an email address in a given cell ...

    Colin | Excel | Latest reply: Colin Jun 16, 2016
    0 replies
  • convert date of birth into words Closed

    if I write 11.07.1982 in A2 ,how to get the appearance like this Eleventh July Nineteen Eighty Two Thanks

    pandianjothi | Excel | Latest reply: Ambucias Jun 16, 2016
    1 reply
  • data transfer from all sheets to 1 Closed

    Hello, please help me.. i am trying to make a production report & for that i have to copy data from numerous sheets to 1 sheet & then calculate. s...

    amar | Excel | Latest reply: vcoolio Jun 16, 2016
    1 reply
  • is it possible to use 5'-2 1/2" in a formula instead of decimals Closed

    Hello, please a need some help. is it possible to use 5'-2 1/2" in a formula instead of decimals or converting it into inches with a decimal? Any ad...

    lynng | Excel | Latest reply: lynng Jun 15, 2016
    2 replies
  • date sort Closed

    Hello, I have an Excel spreadsheet with training expiration dates. How do I sort/select for "dates on or before [another date]"? I know it can be ...

    Notatechie | Excel | Latest reply: Notatechie Jun 15, 2016
    0 replies
  • Replacements Closed

    Hello, Is there a way to replace certain text with other certain text? for example... if I enter this column contains apple - red orange - ora...

    PJ | Excel | Latest reply: PJ Jun 15, 2016
    0 replies
  • Ms Office Closed

    Hello, I need this software

    Hafiz | Word | Latest reply: Ambucias Jun 15, 2016
    1 reply
  • Automatic Email Sending Macro Closed

    Pls, I need a VBA macro that can send a mail to a specified email address. when a command button is clicked in the Excel environment, a mail message i...

    Wingie | Excel | Latest reply: Wingie Jun 15, 2016
    0 replies
  • Write text in adjacent cells if one cell value is ___? Solved/Closed

    Hello, My knowledge of excel is very basic, but I am interested to know if I can find an easier way to enter information. I'm a tea manufacture...

    teaguru | Excel | Latest reply: teaguru Jun 14, 2016
    2 replies
  • Excel Macro for a very customized group by function Closed

    Hello, I would like to generate a report like the attached with this mail. The requirement is - In the Sample Data, Source tab contains data for pro...

    Indranil | Excel | Latest reply: Indranil Jun 14, 2016
    0 replies
  • How to convert Date of Birth to word in Excel Closed

    Dear sir, I have placed my date of birth 25/04/1977 in one cell in excel and I need the result as "Twenty fifth April Nineteen Seventy Seven "as in...

    kjustind | Excel | Latest reply: JDK Jun 14, 2016
    2 replies
  • Word docs converted to notepad after Win 10 upgrade. Closed

    We had important info stored on word documents on desktop. Somehow when computer upgraded to windows 10 those documents got converted to notepad and ...

    suedebriar | Word | Latest reply: Ambucias Jun 13, 2016
    1 reply
  • VBA Formula; Automatically update multiple workbooks from MASTER Closed

    Hello, I am trying to help a friend with his restaurants. There is a MASTER list with all the food/drink items. There are 7 locations. Each...

    Jr | Excel | Latest reply: TrowaD Jun 13, 2016
    1 reply
  • Duplicate row Closed

    Hello, How would the formula look like for the following: Sheet 1 has 100 rows Sheet 1 has 6 columns Row 1 has headings Formula would go o...

    Hector | Excel | Latest reply: TrowaD Jun 13, 2016
    1 reply
  • compare the values of two worksheets Closed

    Hello, I want to compare the values of two worksheets say sheet1 and sheet2 (col1) and want to add all the values col2 of both sheets in anoth...

    tkp123 | Excel | Latest reply: TrowaD Jun 13, 2016
    1 reply
  • unable to move arrow keys in excel Closed

    Hello, am unable to move arrow keys in excel, please help me

    steve | Excel | Latest reply: TrowaD Jun 13, 2016
    1 reply
  • Cell Format based on conditional formatting Closed

    Hello, Can anyone help me figure out if excel 2010 allows for cell formatting based on text? I have two columns, and in Col A, I have text that re...

    Pat-t | Excel | Latest reply: TrowaD Jun 13, 2016
    1 reply
  • Date and If function Closed

    Hello, Thank you for your time! I want excel to determine the date on multiple conditions. If the given date in A1 is 29-Nov-1980 and one of t...

    Arun | Excel | Latest reply: RayH Jun 13, 2016
    1 reply
  • Convert A Single Row to Column, with an undefined number of rows Closed

    Hello, Hopefully somebody can help, I have a number of files where I need to convert the single row too columns, however the issue I have is the n...

    AlanS | Excel | Latest reply: AlanS Jun 12, 2016
    0 replies
  • Add "x" years to date when it has certain words Closed

    Hello, I need help trying to add 5 or 10 years to a date if another column has this "word" or that "word"... Hopefully I explained myself corre...

    TheAnalyst | Excel | Latest reply: RayH Jun 11, 2016
    4 replies
  • Help! Need to copy only some columns in rows that have X condtn Solved/Closed

    OK, Full disclosure, I am a Novice Excel user at best.....I have a Google Sheet Workbook that contains Google Form Responses (the Sheet name that thes...

    TallPoppy | Excel | Latest reply: vcoolio Jun 11, 2016
    5 replies
  • Searching out Phrases in What-If Scenarios Closed

    Hello, I am having a hard time figuring out this What-If formula. I have my employees make notes in Cell A. So A1 might read "The customer came in...

    tylernicoll | Excel | Latest reply: ac3mark Jun 10, 2016
    5 replies
  • Use of '@' in formulae Solved

    Hi, I have received a spreadsheet with cells in column E containing the following formula [@[Retail Price]]/[@[Pack Size]]*100 Where the "Reta...

    Quarterp | Excel | Latest reply: Quarterp Jun 10, 2016
    6 replies
  • How do i change date format in (dd.mm.yyyy) Solved/Closed

    Hello, How do I change the date format from (dd/mm/yyyy) format to (dd.mm.yyyy) format? And how can I get today's date in dot format (dd.mm.yyy...

  • Open Office Closed

    I have Windows o.S. in computer. Will be able to install Open Office Keeeping Windows OS?

    shri | Open Office | Latest reply: BunoCS Jun 9, 2016
    1 reply
  • Is this possible (IF with dates) Closed

    Hello, I need some help with what to input into Excel for a function I'd like to see. What I'm looking at doing is: Lookup all dates on "s...

    Solrax | Excel | Latest reply: ac3mark Jun 8, 2016
    3 replies
  • IF function using dates Closed

    Hello, I'm trying to write a function that will use an divisions data and turn it into manageable data. They record in their spreadsheet an en...

    Joy | Excel | Latest reply: ac3mark Jun 8, 2016
    1 reply
  • need to extract data from a cell in a macro enabled sheet Closed

    Hello, I created an invoice for my business with a macro to run so that every time I click on a certain cell it will save that sheet into a new work...

    Katie | Excel | Latest reply: ac3mark Jun 8, 2016
    1 reply
  • conditional Formating question Solved/Closed

    Hi I need help with changing the color of a cell based on the Text values in the cells below it. So say B1 is the cell i want to change. B2-B7 has ...

    sforde | Excel | Latest reply: sforde Jun 8, 2016
    2 replies
  • IF formula with dates Solved/Closed

    Hi, I would like to set an IF formula which flags me if someone has been working with us as temp for more than 12 weeks... so I have start date and en...

    CeskyWater | Excel | Latest reply: CeskyWater Jun 8, 2016
    2 replies
  • Copy rows from one worksheet to another based on criteria Closed

    Hello, I have an excel document for our clients based on the type of service they have. I would like to be able to copy and paste the entire row f...

    Jsmir | Excel | Latest reply: Jsmir Jun 8, 2016
    0 replies
  • Excel formula question. Closed

    I have these cells info. CBSA ; RCMP EC ; FO ; HCAN ; NATRES ; ND CRA ; PSC ; PWGSC ND ; PWGSC ACOA ; CFIA ; CRA ; CSC ; FO ; HRSDC ; PWGSC ...

    marengl1 | Excel | Latest reply: RayH Jun 8, 2016
    5 replies
  • Copy row from one sheet to other based on 2 conditions Closed

    Hello, Any assistance would be very much appreciated I'm just getting into macros and coding. I'm trying to copy a list from sheet 4 and input the...

    TB12 | Excel | Latest reply: kadrleyn Jun 8, 2016
    1 reply
  • Search 4 worksheets, copy rows to 5th Closed

    Hello, I am using Excel 2010. I am new to the forum and have a very basic knowledge of VBA. I am trying write a macro that takes info provided...

    Frank H. | Excel | Latest reply: ac3mark Jun 7, 2016
    1 reply
  • Moving data Closed

    Hello, this is driving me mad and im sure its simple. i have 2 sheets in 1 workbook. if column F on sheet 1 contains the word "YES" i need it to ...

    novice | Excel | Latest reply: novice Jun 7, 2016
    3 replies
  • How do you make a VBA function in removing a specific value in a Closed

    How do you make a VBA function in removing a specific value in a cell. Example: remove "#, " and ", #" #, 1, 2, 3 1, 2, #, 3 1, 2, 3, # Res...

    KaeBee | Excel | Latest reply: RayH Jun 7, 2016
    3 replies
  • EXCEL, If column terms match text In range b equal to or less th Closed

    Ive been racking my brain, the attached photo illustrates roughly what Im trying to do, top and bottom images illustrates a collection if 12k pictures...

    erawkz | Excel | Latest reply: RayH Jun 6, 2016
    3 replies
  • Comparing Two Excel File. Closed

    Hello, I have to compare two Excel files for data consistency. Both the file have equal number of column with equal records on it. My job is to find ...

    Rajpkr | Excel | Latest reply: Rajpkr Jun 5, 2016
    0 replies
  • Complex Macro Set-up Question Closed

    Hello, I need to set up a macro that takes data from 6 different excel files and deposits parts of them in a new file, in different order. Efecti...

    SamNoble | Excel | Latest reply: SamNoble Jun 5, 2016
    0 replies
  • Copy answers from 1 sheet to another based on condition - VB Closed

    I want to copy description mentioned in particular cell only when the adjacent cell (i.e. adjacent column cell) says 'YES' . I want to copy this descr...

    Ritika.gup | Excel | Latest reply: Ritika.gup Jun 5, 2016
    2 replies
  • Auto. transfer rows of data to a new sheet based on 1 variable Closed

    Hello, I'm currently working with some data that needs to be broken for better viewing purposes and presenting to non-data minded people. It's goi...

    JCoop | Excel | Latest reply: vcoolio Jun 3, 2016
    1 reply
  • Creating master spreadsheet for mailing information Solved/Closed

    Hi there, So I am creating a workbook, for work, for our marketing, and I need help. We are completely revamping what has been done before and I wa...

    Notsonerdy | Excel | Latest reply: vcoolio Jun 3, 2016
    12 replies
  • Macro only for Alphabetic Sheets Solved/Closed

    Hello, I would like to request for a Macro which will run only for those sheets where Names started with Alphabets from A to Z Thanks & Regards...

    smuneeb | Excel | Latest reply: smuneeb Jun 3, 2016
    2 replies
  • Compare and Combine two sheets into one Closed

    Thank you in advance! I have one excel spreadsheet with rows of customer contact information and the account they are associated with. I have an...

    colleenlit | Excel | Latest reply: mattgdunn Jun 2, 2016
    1 reply
  • VBA Coding Vlookup to single workbook from different tabs Closed

    Hello, I am trying to pull data through Vlookup to master sheet from different worksheet which is having a different tabs for different client. ...

    Shivani | Excel | Latest reply: mattgdunn Jun 2, 2016
    1 reply
  • macro for conditionally moving info from one worksheet to others Closed

    Hello and thank you up front for reading my question. This feels complicated but i have only minimal experience with macros and VBA. We start wi...

    scavengertype | Excel | Latest reply: scavengertype Jun 2, 2016
    0 replies
  • Comparing data Closed

    I have two sheets with data, for example product name, quantities sold and price. All product names on sheet 1 may not be there on sheet 2. So what i ...

    Surabhee | Excel | Latest reply: mattgdunn Jun 2, 2016
    1 reply
  • Two lists of Names that are jumbled up Closed

    Hello, How are you all? I have two lists of names, one has all the names (A) e.g. Michael Luis Stevens, the other does not or the name is jumbl...

    Johnnysopals | Excel | Latest reply: mattgdunn Jun 2, 2016
    1 reply
  • Excel VBA to open a EULA script when opening a spesific workbook Solved/Closed

    Hi Everyone I am busy designing a training pack with formulas in a excel workbook using MS Excel 2013 and have it already password protected using vb...

    DataRV | Excel | Latest reply: vcoolio Jun 2, 2016
    3 replies