Office Software Forum

Ask a question
Search
Close
Results 601 - 650 of about 16,600
  • Generate simplified data from RAW data Closed

    Hello guys, i need help to create some magic from excel. I am a marketer for a F&B, and right now i am in the mid of trying to generate some preci...

    damonlin | Excel | Latest reply: TrowaD Oct 16, 2018
    1 reply
  • Price of MS Office Word Closed

    Hello, What is the price of the microsoft word 2013 after the initial 1-month trial?

  • Copy rows to rows on another worksheet if " ✔ " Solved/Closed

    Hi everyone, Ultimate greenhorn here. I have just recently discovered the " Conditional Formatting " as well as VBA function on excel a week ago and...

    CassYCS | Excel | Latest reply: vcoolio Oct 12, 2018
    19 replies
  • unlocked Closed

    Hello type:RM-436 ic: 661U-RM436 Model Nokia 7210c /FCC id: ppirm-436 made in Hungary 359310/2/459243/8

    audimusty | Office Software | Latest reply: audimusty Oct 11, 2018
    0 replies
  • Auto populate weekday from a separate date entry Closed

    Hello, I am wanting to do two things: 1. In the first column I want to add in the date, in the second column I want it to automatically insert ...

    feebee1 | Excel | Latest reply: TrowaD Oct 8, 2018
    1 reply
  • Pass fail result including absent is fail Closed

    One student passed in 5 papers out of 6 papers but 1 paper absent in this exam.actually this student is fail.How to calculate the result in excel

    CHVENKATAIAH | Excel | Latest reply: CHVENKATAIAH Oct 7, 2018
    0 replies
  • If, Time, Text, Blank Cell Closed

    Hi, I have multi shifts as under; 6 to 14 = 8 7 to 14 = 7 14 to 22 =8 22 to 06 = 8 22 to 7 = 9 I am using =IF(E3>=D3,E3-D3,24-D3+E3)...

    mkalim.ashraf | Excel | Latest reply: mkalim.ashraf Oct 5, 2018
    0 replies
  • Create a macro for a data set Closed

    m trying to create a macro for below data, the series of data will be in below format. Bahrain United Arab Emirates Oman Qatar

    vincitydaimo | Excel | Latest reply: vincitydaimo Oct 4, 2018
    0 replies
  • Excel calculator issue Closed

    Hello, I am trying to create an excel calculator to calculate the holidays a certain employee has accrued depending on a set of conditions. I want...

    sg111 | Excel | Latest reply: sg111 Oct 3, 2018
    0 replies
  • VBA command button Solved/Closed

    Hi Everyone, I need help creating the following: I want to create a CommandButton that when clicked it will check column "CB" for "YES" and will...

    Srojassg | Excel | Latest reply: vcoolio Oct 2, 2018
    10 replies
  • VBA - Button saves TextBox data in dif. Workbook Closed

    Hi Everyone, I need some help creating a code that will allow me to save data input into a TextBox to a different Workbook called "FoundData.xlsm"...

    Srojassg | Excel | Latest reply: ac3mark Oct 1, 2018
    1 reply
  • Count total quantity by date into month Solved/Closed

    Hello, Good Day~ Kindly help to correct the formula for below, I had wrote a formula that to calculate the quantity by month to the order date ...

    Winndixie | Excel | Latest reply: ac3mark Sep 28, 2018
    3 replies
  • How to use conditional formatting 30 day notice Closed

    I have an excel document that I have set up some conditional formatting and use of icon sets. The only issue I am having, is programming the 30 day a...

    clenk4304 | Excel | Latest reply: ac3mark Sep 26, 2018
    1 reply
  • Not implemented error message in Outlook 2013 Closed

    Hello, When I try to send an Email to my client suddenly an error message display: “Not Implemented Error Message in Outlook 2013”. There is issue...

    amandanewnham | Outlook | Latest reply: ac3mark Sep 24, 2018
    3 replies
  • Lookup or match Closed

    Hi, I have a column in which I have a value I need to look up, then in same column anther value I need to find then return value in column that has an...

    aysherryan | Excel | Latest reply: ac3mark Sep 21, 2018
    3 replies
  • Copying specific cells Closed

    Hello, I am trying to use a command button to copy information from specific cells in sheet 1 to a excel form I made in sheet 2. The cells are not...

    andrewrp1 | Excel | Latest reply: ac3mark Sep 20, 2018
    1 reply
  • Saving multiple Excel files based on a list Solved/Closed

    Hi, I'm totally new to writing macros in excel but I thought I'd give it a go. I've seen similar threads but I can't find the answer to my problem....

    KenthH | Excel | Latest reply: KenthH Sep 20, 2018
    4 replies
  • Count Qty by mth to the order date Closed

    Hello, I need a formula that helps me calculate the quantity by month to the order date and also by venue and type. I have tried to use a Pivot Ta...

    Winndixie | Excel | Latest reply: Winndixie Sep 20, 2018
    0 replies
  • VBA code to copy and paste data multiple times Closed

    Hello, is it possible to parse a column and find a value in it, and copy and paste a particular range based on that value in the previous range? t...

    lakshminair | Excel | Latest reply: ac3mark Sep 19, 2018
    1 reply
  • Insert blank rows in table range Closed

    Am trying to create a macro for below data, the series of data will be in below format. Bahrain United Arab Emirates Oman Qatar Dammam - KSA Riy...

    Surya4vba | Excel | Latest reply: ac3mark Sep 19, 2018
    3 replies
  • VBA: Determine Conditions for Copy/Paste Process Closed

    Hi guys, first time poster here :) I would need some help defining my copy/paste process. The situation is as follows: - I need to search for s...

    PlutoQX | Excel | Latest reply: PlutoQX Sep 17, 2018
    2 replies
  • Copy defined columns data from several Worksheets Closed

    Hi, I need a VBA code to copy the predefined columns (5-6 Columns) data in new excel and also need Refresh code to erase all data it has captured p...

    Venkatesh10 | Excel | Latest reply: Venkatesh10 Sep 16, 2018
    0 replies
  • Help with inventory tracking Closed

    Hello, We're using excel to monitor our inventory. We all have pretty basic excel knowledge. We'd like to be able to track our stock levels with...

    Canberra | Excel | Latest reply: Canberra Sep 16, 2018
    0 replies
  • Excel text to date conversion Closed

    I have column having values like Wed Feb 07 13:39:40 PST 2018; i want to convert to new column as standard date time format. Any clues ?

    jayantsb | Excel | Latest reply: aysherryan Sep 15, 2018
    1 reply
  • Copy Value from new Workbook to existing Workbook Closed

    Hello, I have new workbook file which is generated every month (every 1st date of the month). The Workbook Name will hava a format like "Historica...

    classermild | Excel | Latest reply: ac3mark Sep 14, 2018
    1 reply
  • Help me convert a date format in Excel Closed

    Hello, I need to add the REPLACE, or anything else that convert a date inserted with dots into a date format with slashes, to a long IF formul...

    marco1982 | Excel | Latest reply: ac3mark Sep 14, 2018
    1 reply
  • Scroll bar for single cell Closed

    Is it possible to add a scroll bar on a single cell which contains too much text ?

    CassYCS | Excel | Latest reply: CassYCS Sep 12, 2018
    0 replies
  • Picture directory Closed

    Same kind of scenario where I need to pull in a picture from a server folder into my spreadsheet from an ID number for a person. Sheet 1 has my ra...

    SL_ice | Excel | Latest reply: TrowaD Sep 11, 2018
    1 reply
  • Powerpoint support for the lyrics on tablet Solved/Closed

    I am a singer and I would like to use my Surface tablet as a support for the lyrics. I can get it to work correctly, but only horizontal. I would lik...

    goudse | PowerPoint | Latest reply: Ambucias Sep 10, 2018
    6 replies
  • Excel Macro Program Closed

    Dear friends and experts. Greetings for the day !!! Can someone please share with me some ideas on my problem on Excel VB. Thanks in advance for you...

    Dave_M | Excel | Latest reply: ac3mark Sep 10, 2018
    3 replies
  • Only IDs visible in Excel Import from Access Closed

    Hello, I have set up a VBA import to Excel from Access (using code I found during a number of searches online: (https://www.mrexcel.com/board/thre...

  • Need macro to copy paste @ variable Closed

    Hello, Let us say i have a standard distribution of hours in a row as per below example. A1 A2 A3 A4 A5 A6 Jan Feb Mar Apr M...

    MDAVE | Excel | Latest reply: MDAVE Sep 7, 2018
    0 replies
  • Universally change font color - NitroPro Closed

    I received a PDF in which the font was all grey, making it difficult to read. I'd like to convert it all to black, but seem to be able to only do this...

    GNM9143 | PDF | Latest reply: GNM9143 Sep 6, 2018
    0 replies
  • Macro Auto Run at specific time Closed

    Hi, I am new to excel macros and I have an excel with auto mailer macro. This excel will be updated regulary by team members. Now I want to schedule t...

    spryresh | Excel | Latest reply: spryresh Sep 6, 2018
    0 replies
  • Excel VBA Code for Min(SumIf() - SumIf()) Closed

    Dear Members of CCM Forum, I thank you all for your great and tireless effort to help the world. I have been using the excel formula: =MIN(SUMIF...

    Wetaka | Excel | Latest reply: TrowaD Sep 4, 2018
    1 reply
  • COPY ROW BY ROW based on pattern matching Closed

    i have the following data in sheet 1 A B C D E F day Pe M...

    vinod | Excel | Latest reply: TrowaD Sep 4, 2018
    1 reply
  • Difference between delete and clear Solved/Closed

    Could some one explain both function ("Delete" and "Clear" in Excel) ?

    aysherryan | Excel | Latest reply: vcoolio Sep 3, 2018
    1 reply
  • VBA Macro - Scan worksheet for specific value Closed

    Hello, Looking to create a VBA macro on Excel which scans a worksheet on the document for a specific value(s) and then tally up the results and ex...

    eagletondl | Excel | Latest reply: TrowaD Sep 3, 2018
    1 reply
  • Office 2000 upgrade Closed

    Hello, I have an old issue of Office ie 2000 which I purchased a few years back, do I now have to pay for the updated versions? System Configur...

  • If a column has a value add to another column? Solved/Closed

    Heya, i hope someone can help me with this. I currently have a very large formula sheet made up so i can input a value and add it too my total along w...

    The4Elements | Excel | Latest reply: The4Elements Aug 30, 2018
    4 replies
  • Create rows based on input in columns Closed

    Hello, I have a below table: And I would like to create the following automatically: Is there any easy way to create it? Thanks a lo...

    ssuzzzie | Excel | Latest reply: Ssuzzzie Aug 29, 2018
    2 replies
  • Copy and paste a record in same table - Access/VBA Solved/Closed

    Hello, This might be more complex than the title suggests... I have a task tracker that records; tasks, date recorded, frequency (d,ww,m,q,yyyy...

  • If value is >= 10 then send Outlook mail Closed

    Hello, I m now learning vba now but cant solve my issue at work What I want to do is ...in one of my excel worksheet , in column G, for any cel...

    klechan | Excel | Latest reply: klechan Aug 29, 2018
    0 replies
  • Excel IF statement Closed

    Hello, I am trying to use the IF function with a date in the logic test cell; If the logice test cell has "Yes" then I want the todays date to sho...

    mkalkoske | Excel | Latest reply: ac3mark Aug 28, 2018
    1 reply
  • How to change format from mm/dd/year to dd-mmm-yea Closed

    hello Seniors, please solve my query: I need to change format of data in my excel sheet, for instance data is in the format of mm/dd/year while I ...

    laibamahsud1 | Excel | Latest reply: ac3mark Aug 28, 2018
    1 reply
  • Conditional formatting Closed

    Hello, I want to change the font color for lines that have been updated. If a new position or new step is entered, the font colour of the entire ro...

    Veronique | Excel | Latest reply: TrowaD Aug 28, 2018
    2 replies
  • Separating records by relocating cells Closed

    Hello All, I need to automate the following process: I've an excel worksheet that is (columns x rows) 19 x 260 size, arranged as follows; I...

    Heahn | Excel | Latest reply: TrowaD Aug 28, 2018
    1 reply
  • Adding days to dates Closed

    Hello, I was hoping someone could help with this, I am creating a spreadsheet and am having problems with the following: Column D shows Date E...

    mlip | Excel | Latest reply: TrowaD Aug 28, 2018
    1 reply
  • join the formula Closed

    =IF(ISBLANK(C17),"",IF($L$14="INTER STATE SALE",(M33)))&IF($L$14="STATE SALE",(I33+K33))

    santhoshdarls | Excel | Latest reply: santhoshdarls Aug 26, 2018
    0 replies
  • Adding days to a date based on drop down menu Solved/Closed

    Column D shows Date Enrolled, Column E shows Experience (options are more than 1 year or Less than 1 year) I would like column F to add 35 days if "Le...

    mlip | Excel | Latest reply: mlip Aug 25, 2018
    0 replies