Office Software Forum

Ask a question
Search
Close
Results 2151 - 2200 of about 16,600
  • Building a new spreadsheet using information from another Solved/Closed

    Hello everyone, I'm new to the forum and VBA and would like to thank you in advance for your assistance. I have received a spreadsheet that contains...

    wtmayoza | Excel | Latest reply: wtmayoza Dec 13, 2016
    4 replies
  • Change Date Format Closed

    Hello, I need to analyse some dates, only problem is that they are displayed as: Fri, 19 Aug 2011 19:28:17 -0000 Excel won't recognise them as dat...

    borsa | Excel | Latest reply: borsa Dec 12, 2016
    0 replies
  • Excel function Closed

    Hello, Am looking for a formula which can be used to find the fund name from the subject line For eg. xyz capital market ltd-fund name Subject lin...

    Karthik | Excel | Latest reply: Karthik Dec 9, 2016
    0 replies
  • Conditional data copying Closed

    Hello, I require assistance in allocating employee codes to a specific PC. Those Employee codes are available in Pivots and i have to change date a...

    pkawale | Excel | Latest reply: pkawale Dec 9, 2016
    0 replies
  • Need macro code to make a report with 5 files on daily things Closed

    Hello, Please, can any one help me on this task, it would be great pleasure , I need a macro code to make a report with data in 5 different files o...

    Shiva | Excel | Latest reply: Shiva Dec 9, 2016
    0 replies
  • Need macro code to make a report with 5 files on daily basis Closed

    Hello, Need macro code to make a report with 5 files on daily basis such as open tickets report and resolved tickets....into a master file to track ...

    Shiva | Excel | Latest reply: Shiva Dec 9, 2016
    0 replies
  • Conditional Formating on a drop down list Closed

    Hello, I would like to change the result of a option in a drop downlist based on a result from another cell. A1=Optional B1=Green (option in the dr...

    Emma | Excel | Latest reply: ac3mark Dec 8, 2016
    3 replies
  • lost password Closed

    Hello, in lost my email password how can i recoveer it Configuration: Windows / Chrome 54.0.2840.99

    nelsonmarwa | Word | Latest reply: xpcman Dec 8, 2016
    1 reply
  • need formular for Closed

    hell, in column a i have a list of employee names......column h their sales I want to sort by list of eployee names and add their sales and put in c...

  • TALLY Closed

    hello... I have 2 Laptops one works under windows 7 & another s OS is windows 10. tally erp 9 was working fine in OS 7, but in windows 10 though tall...

    POORNENDUKALA | Office Software | Latest reply: kieferschild Dec 8, 2016
    1 reply
  • Run macro automatically Solved/Closed

    Hello, I wrote a macro and I want to run it automatically if one special cell change but have problem, because contents cell change by formula in oth...

    mkg | Excel | Latest reply: Guest Dec 8, 2016
    4 replies
  • Auto tranfer data from one sheet to multiple other sheets. Closed

    Hello. Im a beginner in Excel, and I´m going to make day sheets for crew working on a production using Excel. The different crews will need differen...

    Dav999 | Excel | Latest reply: vcoolio Dec 8, 2016
    1 reply
  • how to change cell name through to color Closed

    hi i am unable to change cell name according to another cell color is negative for exp: if cell a1 is red color so cell b1 showing "c" if cell a1 ...

    sachin | Excel | Latest reply: sachin Dec 8, 2016
    0 replies
  • Sum if Closed

    Hello, I am trying to create a formula to calculate my time cards at work I have afternoon shift, night shift, Saturday, Sunday etc etc. On a Frid...

    Justinw523 | Excel | Latest reply: Justinw523 Dec 7, 2016
    0 replies
  • Microsoft office word office open xml file hmc 10 cannot be open Closed

    the office open xml file hmc 10 cannot be opened because there are problems with the contents how to fix this error. I tryed lots of solutions to fix ...

    5308 | Word | Latest reply: Ambucias Dec 7, 2016
    29 replies
  • (Heading)If cell contains text, format cell+5 cells to the right Closed

    Hello, I have a worksheet which has several different sub-headings, occurring at different rows and columns in the sheet. I want to format the row o...

    piecevcake | Excel | Latest reply: piecevcake Dec 7, 2016
    0 replies
  • Create different excel files with different collums information Closed

    Hello, 1st Excel spreadsheet with 10 rows and 10 column of data. 2nd Excel spreadsheet with a layout with merged boxes, colors, names etc. Can I cr...

    imindaugass | Excel | Latest reply: imindaugass Dec 7, 2016
    0 replies
  • i cannot run Private Sub Worksheet_Change(ByVal Target As Range) Closed

    Hello, i am trying to run the below code, Private Sub Worksheet_Change(ByVal Target As Range) Dim selectedValue As String Dim templateValues As S...

    reddy | Excel | Latest reply: reddy Dec 7, 2016
    0 replies
  • calendar Closed

    Hello, how to make a 2017 calendar Configuration: Windows / Chrome 54.0.2840.99

    sarah | Word | Latest reply: sarah Dec 6, 2016
    0 replies
  • Excel not changing time format to 24 hr format Closed

    Hello, I have exported ddata from ServiceNow into an Excel spreadsheet. The Created field shows as mm\dd\yyyy hh:mm:ss. I need to separate the fie...

    mmeas | Excel | Latest reply: mmeas Dec 6, 2016
    0 replies
  • Excel VBA Closed

    Hey all, Firstly - apologies, I haven't even got a base code - because frankly I am hopeless..... What I want to achieve - I will be running a weekl...

    LukeBOP | Excel | Latest reply: LukeBOP Dec 6, 2016
    0 replies
  • Macro to write doi(Digital Objec information on the excel sheet Closed

    Dear All, I have a list of DOIs on a excel sheet and I want to write details (Journal name, vol no, issue no, page numbers) on the same sheet - just ...

    wv1 | Excel | Latest reply: wv1 Dec 6, 2016
    0 replies
  • Macro copy and paste in next blank cell Solved/Closed

    Hi guys, I need some helping in excel macro. I have two sheets in a workbook. Sheet1 is for summary and Sheet2 is for the raw data. I need to update/...

    fhernnet | Excel | Latest reply: pratheepM7 Dec 6, 2016
    10 replies
  • Lenovo Laptop - Arrow keys Closed

    Hello, I can toggle between cells on my LENOVO laptop, I DO NOT have a scroll lock button wither. HELP Configuration: Windows / Chrome 55.0.2883.75

    jpino812 | Excel | Latest reply: TrowaD Dec 6, 2016
    1 reply
  • Macro for concatenating and moving data Closed

    Hi guys. I have been given a task at work and am after some assistance, or at least a point in the right direction if possible please.  I need to...

    psymson | Excel | Latest reply: psymson Dec 5, 2016
    2 replies
  • macro to extract specifc data Closed

    So ive been tasked with creating a customer database. Our intranet has our customers listed by there name and then a email and phone number. Sad part ...

    robogp | Excel | Latest reply: robogp Dec 4, 2016
    0 replies
  • Transfering data from one sheet to another Closed

    Hi all, Nice to be here! I have to transfer data from one sheet to another whenever the status of the case is closed. I have created the dropdown li...

    Bonval | Excel | Latest reply: vcoolio Dec 4, 2016
    1 reply
  • automatically copy the values from the active row from sheet Solved/Closed

    Hello, Struggling already for a couple of days.... so a help would be more than welcomed Need to write a macro in Excel which would: automaticall...

    BeanP | Excel | Latest reply: vcoolio Dec 4, 2016
    6 replies
  • Can't log in to my email using my phone Closed

    Hello, For almost a week now, I have not able to log in to my email account using my phone. they keep telling me that they failed to authenticate. ...

    Meroveeamini | Office Software | Latest reply: Ambucias Dec 4, 2016
    1 reply
  • HOW TO FIX 'CANNOT ATTACH A FILE IN OUTLOOK' Solved/Closed

    Hi team I find your website very helpful so I am returning the help - After searching the web and trying to resolve the above problem for hours, I fo...

    Trisha6543 | Outlook | Latest reply: Ambucias Dec 4, 2016
    1 reply
  • Date Formats Closed

    In Excel, why do I set date format to custom mm/dd/yy yet have to enter the date as yy/mm/dd for it to appear correctly on the worksheet. I used ...

    DJL | Excel | Latest reply: yg_be Dec 3, 2016
    1 reply
  • Automatically transfer information from Sheet 1 to Sheet 2 Closed

    Hi, How can I automatically transfer data from a cell in Column A in Sheet 1 to Column A in Sheet 2? Once data is copied over into Column A in Sheet...

    Lani1302 | Excel | Latest reply: yg_be Dec 2, 2016
    1 reply
  • Column Differences Closed

    Hi. Thanks for welcoming me to this forum. I have a problem and I am hoping someone here can help me. The problem is as follows: I have 2 worksheet...

    cocodemer75 | Excel | Latest reply: yg_be Dec 2, 2016
    1 reply
  • building a macro that allows to pull different year data Closed

    I am trying to do the following in excel: I have one master sheet where I have the following columns (name, score, weighting), and the following row...

    eve_atl | Excel | Latest reply: yg_be Dec 1, 2016
    1 reply
  • Macro to copy entire row to next workbook Solved/Closed

    Hello, Configuration: Windows 7 / Firefox 50.0 I have the following macro to copy entire row when the column has a capital X. I would like...

    jymie | Excel | Latest reply: ac3mark Dec 1, 2016
    10 replies
  • Macros / VBA - Sending Rows to New Sheet Closed

    Hi All-- New to programming, trying to make an efficient Excel program to use to sort and send certain data to certain sections of a separate sheet. ...

    etjarks | Excel | Latest reply: etjarks Dec 1, 2016
    0 replies
  • Column differences Closed

    Hi. I have 2 worksheets. There are around 36000 rows of products on each sheet, although the sheets are not an exact match ie there are some product...

    cocodemer75 | Excel | Latest reply: cocodemer75 Dec 1, 2016
    0 replies
  • Transfering data from one sheet to another Closed

    Hello! I am running my own business. There are many ways my below query help me in my business. I buy raw material for my business like Nickel, Zin...

    sauravghai20 | Excel | Latest reply: TrowaD Dec 1, 2016
    11 replies
  • Auto Populate Master datasheet Closed

    Hello, I am trying to build a master data worksheet that initially contains about 5000 records that updates from the data entered into 7 separated w...

    Charlie | Excel | Latest reply: Charlie Dec 1, 2016
    0 replies
  • Email Notifications from the Work Book Closed

    Dear Any one help me on the below I had a workbook with 3 to 4 sheets in it. if some is changing or updating in anyone of the sheet. i need to get t...

    jahmed.mls | Excel | Latest reply: jahmed.mls Dec 1, 2016
    0 replies
  • Compare Value Randomly Closed

    Hello, Hello, I have 4 columns: vendor_url reprice_sku Item ID URL for Item ID URL1 2...

    klieger | Excel | Latest reply: klieger Nov 30, 2016
    0 replies
  • Adding a specific number of rows between data change in excel Closed

    Hello, please advise on the code for adding a certain number of rows in the excel data at a change in value. I want to add 12 blank rows between th...

    AT | Excel | Latest reply: yg_be Nov 30, 2016
    1 reply
  • embarrassing Closed

    Data is automatically (or unintentionally) are copied from one worksheet to another taking up time and memory. How can I prevent Excel do this? Is the...

    kodosalbion | Excel | Latest reply: kodosalbion Nov 30, 2016
    0 replies
  • A and B column query to provide Sum of column C Solved/Closed

    Hello and thank you for your help. Please use this scenario for reference: - A B C 1 abc x 1 2 abc y 2...

    Rian Crabtree | Excel | Latest reply: yg_be Nov 29, 2016
    1 reply
  • search, find & display Solved/Closed

    Hello, I have been manually filling out the week no's, in a budget sheet, but want to try and auto populate. I have a table with dates and Week No...

    noob | Excel | Latest reply: learningenquirer Nov 29, 2016
    5 replies
  • VBA Help - Copying Rows into a new sheet, based on 3 Characters Closed

    Hello Friends, I am looking to build a VBA Macro that extracts the entire row of information based on the first three letters of Column C (Postal). ...

    kgan4 | Excel | Latest reply: yg_be Nov 29, 2016
    7 replies
  • How to Insert Video into PowerPoint? Closed

    I want to spruce up my PowerPoint presentations with some local videoo, but I have no idea how to make that. Any suggestions?

    Gloriaivy | PowerPoint | Latest reply: cody-peter Nov 29, 2016
    1 reply
  • Copy past using VBA Closed

    I am in Excel trying to copy data from from one worksheet to another. The idea is new data would be added to the next row each time data is added. Eac...

    ntmn8r | Excel | Latest reply: cody-peter Nov 29, 2016
    6 replies
  • I want to validate the data format Closed

    Hi I need to verify/validate the data in a column, it should be "AAAA-16-0001" format. If the data is not in the specified format, i need to have a...

    yuva69 | Excel | Latest reply: yg_be Nov 29, 2016
    3 replies
  • automatilcally transfer to data to other spreadsheet Closed

    Hello, I have one master sheet and 12 monthly sheets, I want to transfer the data from Master sheet to all the respective monthly sheet, automatical...

    aziz5289 | Excel | Latest reply: aziz5289 Nov 29, 2016
    0 replies