Office Software Forum - solved topics

Ask a question
Results 201 - 250 of about 2,650
  • Solved
  • Send mail if today is the birthday. Solved/Closed

    Hello, I have a Excel sheet containg profile of some employee like this: Name ID Date of Birth Rahul 335221 15...

    RWomanizer | Excel | Latest reply: bkdroid13 Jun 19, 2019
    11 replies
  • Comparing Two Excel Sheets and copying like data to third sheet Solved/Closed

    Hi, I'm trying to compare two sheets in excel and have matching column data copy the entire row into a new third sheet. Ex: Compare Sheet 1 column...

    coz2992 | Excel | Latest reply: TrowaD Jun 18, 2019
    11 replies
  • Using a Named Field for Autofill Solved/Closed

    I am performing an Autofill using a macro. Is there a way to enter the ranges using a "Named Field" in the macro without having to hardcode them in t...

    excel987 | Excel | Latest reply: excel987 Jun 12, 2019
    2 replies
  • Excel Macro - Set and autofill a range? Solved/Closed

    Hello, I am creating an excel macro to reformat a CSV file. In doing this, I need to select a column (F) and replace the values in that column with a...

    KT | Excel | Latest reply: excel987 Jun 11, 2019
    28 replies
  • Excel autofilter stops filtering Solved/Closed

    Hello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file, which has about 19,000 rows, I di...

    Lucy | Excel | Latest reply: thankful Jun 11, 2019
    45 replies
  • Word 2007 blank page displaying square boxes Solved/Closed

    Hello, Please can anyone help me. I was typing in english and then I wanted to change to chinese. I pressed shift and alt and immediately struck g to...

    xx | Word | Latest reply: Mirela Jun 6, 2019
    20 replies
  • If a cell contains any text then add a value Solved

    I hope someone can help me with this...I've done this before but can't remember how. I have a list of names (for an attendees list) and I need to s...

    cbrizz | Excel | Latest reply: Pharmanumbers Jun 5, 2019
    20 replies
  • Formula in Excel to turn numbers into text Solved/Closed

    Hello, I found formula but sir I want at last as per below. As per formula =words(1234) = one thousand two hundred thirty four But sir I wan...

    ashwin12289 | Excel | Latest reply: venkatesan May 31, 2019
    4 replies
  • POP (IMAP) settings outlook Solved/Closed

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

    Adam | Outlook | Latest reply: hernezto May 28, 2019
    23 replies
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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 (

    Fenrir91_9 | Excel | Latest reply: vcoolio Mar 1, 2019
    5 replies
  • Copying formulas to multiple worksheets Solved/Closed

    Hi, I have a workbook that contains 32 worksheets. 31 identical sheets that are basically days of the month. Last one is a summary sheet. I have t...

    mmikey45 | Excel | Latest reply: subodh Feb 2, 2019
    11 replies
  • Copy data onto sheet only if cell has text Solved/Closed

    Hello, I need to copy formulas and data from a selection of cells in a worksheet (Figures) onto a seperate sheet (summary). I would like the inf...

    danipants | Excel | Latest reply: checjb Jan 29, 2019
    17 replies
  • Conditional format "match range" Solved/Closed

    I am stumped and can't find an answer to this issue for Excel 2010 The best way I can describe this is that I am attempting to build an Excel based...

    Netscur | Office Software | Latest reply: SadBingoDude Jan 24, 2019
    6 replies
  • How to repair a PDF corrupted doc Solved/Closed

    Hi, I am having a problem trying to open a PDF file. Ever time I attempt to open, Adobe Reader loads, but displays error message: There was an error ...

    jbell481 | PDF | Latest reply: Markdc Jan 24, 2019
    3 replies
  • Watermark to some pages not all Solved/Closed

    Hello Office Software Geek, I am currently writing a lengthy document and want to add my name as a watermark to some pages and another name to othe...

    bionik | Word | Latest reply: Catherine Jan 19, 2019
    20 replies
  • I need a pdf to Word 2007 converter Solved/Closed

    can you recommend a reliable pdf to word office 2007 converter? I downloaded pdfsmall converter and when I load the pdf file to be converted it gives...

    Polaron | PDF | Latest reply: subsystems Jan 11, 2019
    3 replies
  • How can I convert a DOCX file to PDF ? Solved/Closed

    DOCX to PDF Converter software - you can convert your files from DOC or DOCX format to PDF format in just a few seconds with no other external compone...

    subsystems | PDF | Latest reply: kieferschild Jan 8, 2019
    1 reply
  • VBA code to open non excel programs Solved/Closed

    Hello, I need vba code to open other documents besides excel doc's e.g open a word file, access file etc.. Can anyone help?? thanks PM

    PM | Excel | Latest reply: Billybob Jan 7, 2019
    10 replies
  • Problem with copy in one sheet Solved/Closed

    Hello, There is a table on sheet1 for example. A B C D E 1 2 3 4 5 In cell A1 I drag the data from sheet2 cell A10 In cell A2 I drag t...

    kekserica | Excel | Latest reply: ac3mark Jan 4, 2019
    26 replies
  • I need VBA that creates a new sheet for every data entered in column D Solved/Closed

    Hi, I need a formula that create a new sheet for every data in "D" column cells and sheet name is like the cell ,also add that cell whole row data ...

    dmatrix00 | Excel | Latest reply: ac3mark Dec 26, 2018
    3 replies
  • How to convert date into words Solved/Closed

    Hello, Hello i want to know how to convert date into words(english) for 05.05.1999 Thanks System Configuration: Windows Vista / Chrome 49.0...

    shahid | Word | Latest reply: 2massive-head Dec 25, 2018
    2 replies
  • Budgeting forumla in Excel Solved/Closed

    Hi! So I'm trying to write a budget for my household. Payments are made from different accounts. I've included an example. If anything in Colu...

    nfez | Excel | Latest reply: nfez Dec 22, 2018
    2 replies
  • Copy rows n times in Excel Solved/Closed

    Hello, I Need to copy from rows from A1:AY39 and need to insert in A41 and the same as be pasted on next 38 Row from A41 and it as to be done for ...

    Sarath | Excel | Latest reply: vcoolio Dec 20, 2018
    8 replies
  • VBA to compare column E from 2 sheets and copy entire row to sheet 3 Solved/Closed

    Hello, I have a worksheet where I want to compare values from sheet 1 and sheet 2 and if values in column E (both sheets) are the same to then co...

    Bryant | Excel | Latest reply: Bryant Dec 14, 2018
    2 replies
  • Excel formula to track accrued vacation Solved/Closed

    Hello, I need help writing a formula in excel to track accrued vacation / personal time. During our employees first year of employment they earn P...

    zonda216 | Excel | Latest reply: TrowaD Dec 13, 2018
    1 reply
  • Copy rows based on a condition Solved/Closed

    Hi How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains TERM. I...

    Blossom83 | Excel | Latest reply: ravichennai86 Dec 12, 2018
    30 replies
  • How to merge data from different Excels Solved/Closed

    Hello, My name is samar. I have a master sheet which cakculates all oaraneters for my team . To calculate this some raw data is needed . I had...

    SAMARMANDKE | Excel | Latest reply: Ratnendra Ashok Dec 9, 2018
    1 reply
  • Recalculation of dates Solved/Closed

    Hello, Hello, I'm trying to write a formula that will recalculate a date based on a fixed number of days. For example I have 2/1/19 in cell A42...

    BlairBiss | Excel | Latest reply: BlairBiss Dec 4, 2018
    4 replies
  • Send to via Access 2016 "wrong password" Solved/Closed

    I have a customer using Access 2016 with a custom database written by someone else. They were using IMAP but are now on 365. Since this move whe...

    kieferschild | Office Software | Latest reply: kieferschild Nov 28, 2018
    3 replies
  • Explanation of formula used on conditional formatting Solved/Closed

    Hi, Could someone please be able to fully explain how the following formula works with regards to conditional formatting? =AND(start_of_range""...

  • Populate separate worksheets with data from main worksheet based on criteria met Solved/Closed

    Hello, I'm making an accounting workbook and I've run into a problem. On the first sheet "Sales Log" I input all of the transactions that the...

    biancacabo | Excel | Latest reply: Jules_St-Germain Nov 12, 2018
    9 replies
  • Paste value on filtered cells Solved/Closed

    Hello, i was trying to "pasted value" on a filtered cell. but it seems to be pasting it to all cells... im using a "=concatenate" on several cell...

    ehlblackstar | Excel | Latest reply: ac3mark Nov 2, 2018
    2 replies
  • Formula I should use Solved/Closed

    I am so confused on what formula should i be using for my work...? Which should be ending up like this...

    ehlblackstar | Excel | Latest reply: ehlblackstar Nov 2, 2018
    0 replies
  • Comparing two columns using partial match logic Solved/Closed

    I need a bit of help please. I have 2 columns of data that I am doing a partial match compare (first 15 positions) using a formula in column AA. ...

    patallen8845 | Excel | Latest reply: patallen8845 Oct 22, 2018
    2 replies
  • 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
  • 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
  • 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
  • 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