Office Software Forum

Ask a question
Search
Close
Results 451 - 500 of about 16,600
  • Formula/Solution Closed

    Hi, Is there a way for me to link in one spread sheet the Leave Dates that will automatically apply to the specific date in a second/third/forth sp...

    RuthG13 | Excel | Latest reply: ac3mark May 29, 2019
    1 reply
  • Mail.com POP (IMAP) settings outlook Solved/Closed

    I got my mail.com email working using the following settings: Account type: Choose IMAP Incoming mail server: pop.mail.com Outgoing mail server ...

    Adam | Outlook | Latest reply: hernezto May 28, 2019
    23 replies
  • VBA Regex Closed

    i need a help to create regex to use in Excel vba. Actuality 3 regex 1. Only Numerics Valid: 12,12.000, 2343342.123221321398783, 0.9874, -12, -2...

    Sanju_7454 | Excel | Latest reply: Sanju_7454 May 28, 2019
    0 replies
  • Compare two excel file and provide unmatched excel data in separate file Closed

    Hello, I have two excel files with common identification column A in both files. I need macro which will provide unmatched data in separate file. ...

    Rajesh | Excel | Latest reply: Rajesh May 26, 2019
    0 replies
  • use RegEx in vba sub in general sheet Closed

    How to use regex in general vba sheet. i am getting lot of red lines and not able to find the reason for that. I have enabled the Regularexpression...

    Sanju_7454 | Excel | Latest reply: ac3mark May 25, 2019
    4 replies
  • Listboxes with Checkboxes to filter data Closed

    Hello, Greetings! I have a query regarding making dashboard. I have a data sheet where all data is managed. I want slicer with listbox having ...

    Game Start Now | Excel | Latest reply: TrowaD May 23, 2019
    13 replies
  • read special character value Closed

    how to read the cell value in vba if A1 has special character like -------- I used Range("A1").Value , Its throwing an error plz help me

    Sanju_7454 | Excel | Latest reply: ac3mark May 22, 2019
    1 reply
  • VBA code to count invalid Values Closed

    Hi, I have created a vba code to circle the invalid data based on the custom data validation rule being written. I want to count the all those i...

    Sanju_7454 | Excel | Latest reply: ac3mark May 21, 2019
    7 replies
  • Where do you find the "25 character product key" they ask for? Closed

    Just downloaded power point 2010 for my old PC, but I get this message I don't know how to answer... Where do you find the "25 character product key" ...

    Mikehatescom... | PowerPoint | Latest reply: HelpiOS May 20, 2019
    1 reply
  • Automatically update a cell with last modified date and time Solved/Closed

    I am maintaining a Test Environment Catalogue, with various users editing it. It is change controlled in SharePoint, however, I'd like to insert a cel...

    NazCarr | Excel | Latest reply: NazCarr May 16, 2019
    2 replies
  • Repeated copy/paste Macro Closed

    I have basic knowledge of Macros. I need to copy 1Lakh data in such a way that it takes 10k rows and paste in new sheet1 and again it takes next 1...

    Sanju_7454 | Excel | Latest reply: ac3mark May 9, 2019
    4 replies
  • Keeping track of ages Closed

    Hello, I operate a small daycare and need help figuring out a system to help keep track of my group ratios. I haven't been able to find a software...

    celineleblanc | Excel | Latest reply: ac3mark May 8, 2019
    1 reply
  • Please help me connect my workbooks to a master excel worksheet. Closed

    Hello, I have been through every excel video and forum trying to figure out how to connect my Excel workbooks for a tracker I have been working on. I...

    MBEr | Excel | Latest reply: ac3mark May 7, 2019
    2 replies
  • VBA find column by name and sort Solved/Closed

    Hello, I am trying to make a code that should: - Go to the first worksheet - Find the first column with header "sku" - Sort this column ascen...

    SidK | Excel | Latest reply: bOFILL Apr 30, 2019
    4 replies
  • copy x rows from a worksheet and paste x rows into another worksheet n times Solved/Closed

    Hi, I am struggling to create a macro that can copy an excel range of data (A1:B50) from sheet 1 and paste into sheet 2 for 4000 times. Currently, sh...

    christol_1566 | Excel | Latest reply: TrowaD Apr 29, 2019
    20 replies
  • Create new sheets based on Column A data. Solved/Closed

    Hi, Is there a way to create a new tab based on column A? For example: I want to create a new tab for each vehicle, copy and paste all of vehicle ...

    josh07429 | Excel | Latest reply: Jay Apr 26, 2019
    4 replies
  • Import text into corel Closed

    How do i import typed text in ms word to corel draw 9

    De | Word | Latest reply: ac3mark Apr 23, 2019
    1 reply
  • Product key for Office 2010 Closed

    Hello, I need product key for Office 2010.

    shan | Open Office | Latest reply: b,s Apr 22, 2019
    2 replies
  • False error Closed

    Hello, How to remove false error while using this formula *if(c2="A",sumifs(sheet2!AA:AB,sheet2!B:B,sheet1!B:B, sheet2! Sheet1! A:A))*

    LOKESH | Excel | Latest reply: ac3mark Apr 22, 2019
    1 reply
  • Excels with different data Closed

    Hi All, sorry if this is already answered. I have two excel sheet having data of customers. the first report is 'old' one and the second is the '...

    Bharti | Excel | Latest reply: Bharti Apr 19, 2019
    0 replies
  • Finding duplicates between two columns with partial text Closed

    Hello, I am trying to compare a list of names in column A to a list of names in column B. I am trying to highlight the names in column A that matc...

    katthompson333 | Excel | Latest reply: katthompson333 Apr 19, 2019
    0 replies
  • How to put a password on my memory stick? Solved/Closed

    Hello, I am looking for a way to protect my flash disk with a password. In case I lose my flash disk, and somebody else gets access to it, should n...

    francoistexas | Word | Latest reply: d7tdiugougi6r Apr 16, 2019
    31 replies
  • Arrow keys not working in Excel Solved/Closed

    Hello, I am using Excel 2000. I am tring to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. I wa...

    DaisyE | Excel | Latest reply: Nelson Apr 15, 2019
    59 replies
  • Unable to send emails from Outlook Solved/Closed

    Hello, I have a friend who is suddenly unable to send emails. Can receive, however. Error Message is "unknown error" Ox800CCC81. Help would be most...

    Rosa | Outlook | Latest reply: MohammedFarooque Apr 11, 2019
    32 replies
  • How to change date with the change in time Closed

    How to change date with the change in time and how to use if formula for date range

    Akshay_7572 | Excel | Latest reply: NazCarr Apr 9, 2019
    1 reply
  • excel on Mac Closed

    Im trying to setup my friends computer to invoice I have run time 1004 error occurring. Any help please Sub NextInvoice() Range("I13").V...

    ADrossinis | Excel | Latest reply: ac3mark Apr 6, 2019
    1 reply
  • color cell Closed

    Hello, I have this formula to place a date in cell when negative number. =IF(D14

    docheller | Excel | Latest reply: ac3mark Apr 5, 2019
    1 reply
  • I want to change date format in Excel Solved/Closed

    Hello, I want to change date format from SAP system i.e. 20.05.2010. When I apply thru format cell it doesn't work.

    EAQ | Excel | Latest reply: mohammed Apr 2, 2019
    13 replies
  • Need to extract specific XML data from a cell in excel Closed

    Hi, I have the following data in cell A1 of an excel sheet: 39211000011200100100019 i would like to extract the value from this and print it o...

    alvin07 | Excel | Latest reply: SM Apr 1, 2019
    2 replies
  • Automatically data to another sheet by adding new rows Solved/Closed

    Hello, I have created a "request form" - the form is not designed in VBA - it is simply a spreadsheet using Column B, only, and each row has either ...

    NazCarr | Excel | Latest reply: TrowaD Mar 26, 2019
    9 replies
  • Lost product key Closed

    Hi ...... Still have disk but Lost Office 2010 product key, so although its working its missing some things like a proper spell check. I have the p...

  • Creating search and update command buttons in a userform Solved/Closed

    I have created a userform for inputing new records in an Excel spreadsheet. I have written the code for the Save Record and Close Form command button...

    janb | Excel | Latest reply: ShezzyWiggle Mar 24, 2019
    19 replies
  • Update of Copied Excel sheet Closed

    Hello, I want to make copies of excel sheet such that if I delete rows/columns in main sheet they should be deleted in copy too.

    Vinayak | Excel | Latest reply: ac3mark Mar 21, 2019
    2 replies
  • Serial Numbers Based Upon Another Cell Closed

    I have a spreadsheet with owner and tenant information, along with their vehicle information. In the column that indicates if they are an owner, I hav...

    lkazempour | Excel | Latest reply: ac3mark Mar 21, 2019
    1 reply
  • Compare strings Closed

    Hello there, Case: I have lists of customers from 2 different sources, however example. List1 says ABC private limited on row A1, the other list2 say...

    Panstar5 | Excel | Latest reply: Panstar5 Mar 19, 2019
    0 replies
  • Importing Excel Table Closed

    How can I import a table from excel to acces and prevent creating duplicates in the access database if the record exists

  • Is there a way to export data fro table to a pdf form Closed

    I would like to send data from an access table to a pre designed pdf is there a way to

  • Help with filtering not working Closed

    Hello, I am having issues with my excel at work we have about 8 columns an they have filters an when I type in data an click the filter to go to tha...

    Jessnleon17 | Excel | Latest reply: ac3mark Mar 14, 2019
    1 reply
  • Copy a range of Data in Column with a loop Closed

    Dear all, May I ask your help for a macro which allowed me to copy a range (column) 16350 times :-) On D5 to D369 I have a formula which do a rando...

    ChrisZ | Excel | Latest reply: ChrisZ Mar 13, 2019
    2 replies
  • Shows a #value! When using calculated fields on a pivot table Closed

    Hello everyone I would like to input a calculated field in the excel pivot table. I have input an formula as if(ERP (Variable)>0, "Yes", "No"). It...

    Harold | Excel | Latest reply: Harold Mar 11, 2019
    0 replies
  • carrupt damage pdf file not open Closed

    plz solve my pdf recovery data file pdf not open

    manish | PDF | Latest reply: ac3mark Mar 11, 2019
    1 reply
  • User form to search all result and edit selected Closed

    I'm newbie in VBA excel. I want to create usesform to add, search all result and edit selected. Any one have code like this? Thanks

    silencehero | Excel | Latest reply: ac3mark Mar 8, 2019
    1 reply
  • compare 2 sheets with particular columns Solved/Closed

    Hello, hear is the situation, sheet1 is having "item code (ex. 150007) in column A", and "Rack ID in column B (ex. AA001)" & other side in she...

    SunilD | Excel | Latest reply: SunilD Mar 5, 2019
    2 replies
  • Add data to row that already contains data Solved/Closed

    I want to enter data for the same product but it needs to be done on different days, with two different entry forms, so the row will already contain d...

    aileen | Excel | Latest reply: aileen Mar 1, 2019
    2 replies
  • Automatically copy data from main sheet to child sheets. Solved/Closed

    Hello, I know this question was asked in another thread (https://ccm.net/forum/affich-800808-need-to-automatically-copy-data-from-one-sheet-to-ano...

    Fenrir91_9 | Excel | Latest reply: vcoolio Mar 1, 2019
    5 replies
  • how do i make my ranking Closed

    how do i make my ranking result be 1st, 2nd, 3rd instead of 1. 2. 3

  • Montlhy Service Closed

    I have an increasing excel sheet where i keep the service records for customers per customer, per branch and per date (per year, month and exact servi...

    christossol | Excel | Latest reply: TrowaD Feb 26, 2019
    4 replies
  • Need VBA Code or function Closed

    Hello, kindly need assistance in getting VBA code to copy rows to a new sheet based on the cell value with same name sheet. and auto save the...

    mousa | Excel | Latest reply: mousa Feb 24, 2019
    0 replies
  • IF function? Closed

    I am trying to figure out a function, that will give me a result of Yes or No, if the dates are matching or not. This is the function I am using, ...

    bowmankailee | Excel | Latest reply: ac3mark Feb 20, 2019
    4 replies
  • Inserting pictures Closed

    Hello, Please I need help, I want to insert pictures into a particular sheet remotely without opening the sheet. And the picture will be base in ...

    Udomakpan | Excel | Latest reply: Udomakpan Feb 16, 2019
    2 replies