Office Software Forum

Ask a question
Search
Close
Results 1351 - 1400 of about 16,600
  • Copy hyperlink in another sheet when using vlookup Closed

    Hello guya please help. I have little knowledge in vba. i have an employee details in sheet 1 and i have a vlookup fromula in sheet 2 to show th...

    eunice3301 | Excel | Latest reply: eunice3301 Aug 20, 2017
    0 replies
  • Randbetween function error Closed

    Hello, Iam using randbetween function. Since is it automatically changing the value, I want to copy and paste value if one condition is satisfied....

  • Macro that copies format in Sheet 1 to multiple sheets Closed

    Hello guys, I need help with the creation of a Macro that is doing my head... Let me try to resume so it is super clear for everyone : SHEET ...

    MisterAds | Excel | Latest reply: MisterAds Aug 19, 2017
    0 replies
  • Search for input criteria, return designated cells. Solved/Closed

    Hey all, I am trying to write a VBA command/macro that essentially takes a criteria input from the destination worksheet, searches and matches the ...

    crlarus | Excel | Latest reply: vcoolio Aug 19, 2017
    12 replies
  • Inserting and formating date with userform Closed

    Hello, I am trying to Insert a date with a Textbox in a Userform. It should have this format: Friday, 18.08.2017. This entered Date is used...

    Scencea | Excel | Latest reply: ac3mark Aug 18, 2017
    1 reply
  • Adobe Acrobat Reader 0:104 error message Closed

    Hello, I re-installed Acrobat DC on a user's machine yesterday after encountering error messages. It worked. Adobe then updated and the error me...

    chaimsimcha | PDF | Latest reply: chaimsimcha Aug 18, 2017
    0 replies
  • MS Outlook can't access my mail Closed

    I like to use MS Outlook 2007. For me it is the best. But some hours ago something bad happened with .pst file. All my email aren't accessed. I have t...

    PaulaRamirez24 | Outlook | Latest reply: Ambucias Aug 18, 2017
    1 reply
  • Free MS Office Download Closed

    I just bought an HP Pav laptop and I have noticed that no MS Office is installed. Do you know where I can download the full version for free, I badly ...

    themorgan | Office Software | Latest reply: Ambucias Aug 18, 2017
    1 reply
  • Copying dates to another worksheet. Solved/Closed

    Hello, I found this script from vcoolio, thanks for that! Sub Advise() Dim x As Integer Dim lRow As LonglRow = Range("E" & Rows.Count...

    Scencea | Excel | Latest reply: vcoolio Aug 17, 2017
    12 replies
  • How to convert numeric into words in Excel Closed

    What is the formula to convert numeric in words?

    Sanjeev.me | Excel | Latest reply: ac3mark Aug 17, 2017
    1 reply
  • Excel formula - Add days to date based on drop down selection Solved/Closed

    I want to add days to a date based on options selected from a drop down list. For example, if cell C5 reflects "New Hire" or "Post New Hire", I want ...

    Sabernethy | Excel | Latest reply: Mazzaropi Aug 17, 2017
    3 replies
  • Comparing Two Excel Sheets and copying like data to third sheet Closed

    Hi, In your below coding, I can copy paste the alike data from sheet 1 only, I need to copy paste both from sheet 1 and sheet 2 line by line matchi...

    jvignesh07 | Excel | Latest reply: ac3mark Aug 16, 2017
    1 reply
  • I AM FACING PROBLEM AFTER DOWNLOAD THE MS OFFICE 2010 Closed

    hi ,, I am having a problem after download the ms office 2010.. it is not opening .. please tell me the solution .. ASAP

  • VBA: Cell Range Closed

    Hello, I am a beginner with VBA and I have a question that might sounds stupid to some. I have created a function of IfElseIf and I want to run it...

    shellboy | Excel | Latest reply: ac3mark Aug 16, 2017
    3 replies
  • Search for text , cut and paste into new work sheet Closed

    Hi , can anyone help me with the below vba code : Logic Find text If next row starts with number Then - cut 1 row above text and 3 rows below ...

    JoeRooney | Excel | Latest reply: JoeRooney Aug 16, 2017
    1 reply
  • Dropdown menu disappears quickly before you can even choose Closed

    My excel has been acting weird lately. All dropdown menu disappears quickly before you can even choose your choices. This happens in Data Filter fun...

    rsa10 | Excel | Latest reply: rsa10 Aug 16, 2017
    0 replies
  • Transfer data from one sheet to another Closed

    Hello, i have started an inventory sheet on excel what I want to do is take the list of inventory and when it is sold, have it transfer to the second ...

    Thanks for t... | Excel | Latest reply: themorgan Aug 15, 2017
    2 replies
  • How to compare two excel sheets and combine matching data Closed

    Hello, I'm looking for a macro that will match data in column A from sheet 1 to the data in column A from sheet 2 and copy the corresponding rows f...

    jfitz | Excel | Latest reply: vcoolio Aug 15, 2017
    1 reply
  • Trouble sending email from Outlook Closed

    Hello I am trying to send email from my out look and it won't allow me. System Configuration: Windows / Chrome 60.0.3112.90

    semleen Jano | Outlook | Latest reply: semleen Jano Aug 14, 2017
    0 replies
  • Generate new workbooks based on column value from multiple works Closed

    I am a beginner in VBA. Basically I need a code that generates a new workbook for each specific column value in multiple sheets. The key in each sheet...

    TheBeginner | Excel | Latest reply: TheBeginner Aug 14, 2017
    0 replies
  • How to auto-populate values from certain cells into a new sheet Solved/Closed

    Hello guys, Hope everyones doing okay. I've been working on a billing sheet for a company with multiple product codes and rates etc to be pulled f...

    Roadknee | Excel | Latest reply: vcoolio Aug 12, 2017
    18 replies
  • Copy and Paste entire row if a specific cell agrees with if cond Closed

    Hello guys! I have been writing a vba code for a while and I cant find the mistake that I am making... I have a big table and I am comparing the va...

    PeriGr | Excel | Latest reply: PeriGr Aug 12, 2017
    13 replies
  • Date entered wrongly Closed

    Hello, I entered dates as 'Apr 24' wherein I meant 24th of April..Excel has taken it to be '01 April 2024'..how do I correct all such entries, if ...

    ANJU BIDASARIA | Excel | Latest reply: ac3mark Aug 11, 2017
    1 reply
  • How to highlight a row when I enter a date in column I Closed

    Hello, I am trying to highlight a row when I enter a date in column I. How is this achieved?

    renapearl | Excel | Latest reply: ac3mark Aug 11, 2017
    1 reply
  • Copy Specific number of rows and insert n time after 3 rows Closed

    Hello, Please help I want to Select & copy 35 rows data and after 3 rows I want to insert the copied rows n number of times. I need the Row widt...

    manishercv | Excel | Latest reply: ac3mark Aug 11, 2017
    1 reply
  • Transfer data Closed

    I have an excel spread sheet that has columns for last name, first name, office locations, and date. I may have 10 items listed in the column locatio...

    Jojo537 | Excel | Latest reply: Jojo537 Aug 11, 2017
    0 replies
  • Highlight only one column which has greater value Solved/Closed

    Hello, i am inputting numbers in column A , B , C and D so i wanna highlight only one column which has greater value from others. is there any pos...

    Awais Munir | Excel | Latest reply: Mazzaropi Aug 11, 2017
    3 replies
  • Office 2007 files will not open Solved/Closed

    Hi.. I am Dipu Michael from India. I am using the software office2007 in windows7.For the checking purpose I installed 0ffice 2003 in my system. Afte...

    dipumichael | Office Software | Latest reply: xpcman Aug 10, 2017
    1 reply
  • Using macro beta Closed

    Hello All, Looking for a help here. Below is the data I am putting for understanding-- Column- A B C D E F G Row 1 - ...

    Deepak | Excel | Latest reply: Deepak Aug 10, 2017
    0 replies
  • Spellling error in Excel Closed

    Hi Friends 1st, i want to say sorry for my broken english 2nd Did any one noticed what is resulf if you have only 00.50 Cent and your Spell num co...

    Siddique91 | Excel | Latest reply: Siddique91 Aug 10, 2017
    0 replies
  • Multiple data types in Excel Closed

    Hello, I had a group of members contains in 4 fields and all these are enter into one simple format (example certificates) which is seperate works...

    Sateesh | Excel | Latest reply: Sateesh Aug 10, 2017
    0 replies
  • Date conversion in Excel Closed

    Hello, how to convert birth date in word in MIcrosoft excel

    Nasim Shaikh | Excel | Latest reply: xpcman Aug 9, 2017
    1 reply
  • Consolidate data from multiple sheets to one sheet. Closed

    Hello, I have a workbook containing customer data (name, contact #s, addresses, etc.). The workbook is broken down into sheets according to which ...

    Chelseybell | Excel | Latest reply: vcoolio Aug 9, 2017
    3 replies
  • Microsoft publisher 2010 ask product key, Closed

    I downloaded microsoft Publiser 2010 but now they ask product key, where can I find

  • Unprotect VBA project with a macro Closed

    How can I unprotect a Excel Book VbaProject with code VBA (I know the protection password)

    isabel_duque | Excel | Latest reply: isabel_duque Aug 8, 2017
    0 replies
  • Auto update hyperlink on the other sheet Closed

    Hello guys =) Please help... I have a sheet with names and IDs which are in hyperlink and the same data i have also in the other sheet. If the I...

    eunice3301 | Excel | Latest reply: eunice3301 Aug 8, 2017
    3 replies
  • Automate transfer data from masterfile to another sheet Closed

    Dear All, Hope you guys are doing well. I am not an expect in excel, I really hope you guys can provide me some sort helps/advise/how to automat...

    CanCanKen | Excel | Latest reply: CanCanKen Aug 7, 2017
    0 replies
  • Transfer rows to another sheet via color or letters of row Closed

    the Excel sheet has information pertaining to record numbers. I check numeric record from a database and see if they are correct. if the information i...

    RobertVbarrise | Excel | Latest reply: RobertVbarrise Aug 7, 2017
    0 replies
  • Formula cell value change Closed

    Hello, I have 2 columns..... say A & B If I type "Approved" in Column B1, then A1 should automatically change to "COMPLETED" If I type any ...

    max | Excel | Latest reply: max Aug 6, 2017
    0 replies
  • Replace 2007 Office Word Closed

    Hello, I have received an e-mail that my Office 2007 is being retired and I will need a new key. My computer is a Microsoft 10 system. Do you have a...

    Gene | Word | Latest reply: xpcman Aug 6, 2017
    2 replies
  • Reminder by cell flashing /blinking Closed

    Hello, Hi! I have a trouble call log. This is what I want to do.... Have a cell (or row of cells) flash or blink at a specific time from when...

    pooter | Excel | Latest reply: pooter Aug 5, 2017
    0 replies
  • Excel if statement with multiple text values in a column Closed

    Hello, I am using excel 2017. I am trying to use this if statement to give me a value of 1 or 0. =IF((CQ2="Computer");1;0) The problem i...

    hnew16 | Excel | Latest reply: Mazzaropi Aug 5, 2017
    1 reply
  • Changing format of date in Excel Closed

    Hello, Good morning, please I have a question. Question: Want to make use of a function such that with a date ( e.g 2/1/2017 formatted to b...

    Big Joe | Excel | Latest reply: Big Joe Aug 5, 2017
    0 replies
  • Excel 2016 filters do not work Closed

    Hello, My filter stopped working in 2016. It is completely inactive - doesn't show any other option only the one it froze on. In the menu the filt...

    PetraT | Excel | Latest reply: ac3mark Aug 4, 2017
    1 reply
  • Auto populate cells to one sheet from sub-sheets in Excel Closed

    Hello, I am currently working with a spreadsheet that already has 7 worksheets total with a table on each. 6 of them have identical Table Columns ...

  • VBA code to range of days Closed

    Hello, Please help guys... I have a code below: Sub Auto_Open() Dim r As Long For r = 2 To 53 If Range("I" & r).Value = Range("I...

    eunice3301 | Excel | Latest reply: ac3mark Aug 3, 2017
    4 replies
  • Enter current time in a cell by clicking it Solved/Closed

    Hello, I'm trying to minimize the effort to input data in a sheet I've built for recording time for dispatched workers I need to find a way to fil...

  • Powerpoint stop working Closed

    i have downloaded Microsoft office 2010 but unfortunately, power point is not working please help me

    shab86 | PowerPoint | Latest reply: Ambucias Aug 2, 2017
    1 reply
  • Copy full row in Excel Closed

    Hello, I want ti copy full row for example B2:H2 if cell L1 is having text "unlisted". Please help

    Shobhit | Excel | Latest reply: Shobhit Aug 2, 2017
    0 replies
  • Conditional formatting Closed

    Hello, If I have a value on one cell "D3"of let's say "2" and in cell F3 a value of let's say "1" then I want cell G3 to say a text, let's say "Good"...

    KingFloyd | Excel | Latest reply: Mazzaropi Aug 1, 2017
    3 replies