Office Software Forum

Ask a question
Search
Close
Results 3501 - 3550 of about 16,600
  • Embedding images in looped sub for different worksheets Closed

    Hi there, I've been using a macro at work that inserts images into one column, based on the values of cells in another column. This has served me ...

    luzaroon | Excel | Latest reply: luzaroon Jan 20, 2016
    0 replies
  • I need to copy a cell from sheet 1 to sheet 2 if a refrence happ Closed

    Hello, I want to know how to make a formula for below example if G2 at sheet 1 equal yes copy F2 at sheet 1 to A2 at sheet 2 and if G2 at sheet ...

    ekaelraie | Excel | Latest reply: ekaelraie Jan 20, 2016
    0 replies
  • Macros Query - Run a formula that changes by current work week Closed

    Hello, I am fairly new to Macros and I'm basically trying to run a formula that will change each week by work week. The formula I want to use i...

    brenx1 | Excel | Latest reply: brenx1 Jan 19, 2016
    0 replies
  • improving a macro Closed

    Hello, If someone out there can help me with a macro, I would greatly appreciate it and you will be in my debt until the cows come home. The ma...

    Major.Bull | Excel | Latest reply: Major.Bull Jan 19, 2016
    0 replies
  • How to Combine 2 Formulas in one box? Closed

    Hello, I would gladly appreciate any advice on how to finish or redo my formula. I have most of my formula but I can not figure out how to do the la...

    stargazer | Excel | Latest reply: stargazer Jan 19, 2016
    2 replies
  • Creating a timeline with Excel Closed

    Hello, another newbie here. I'm trying to create a single Excel data worksheet that is used to calculate timelines and due dates on additional work...

    ForePeaks | Excel | Latest reply: ForePeaks Jan 18, 2016
    0 replies
  • Corrupted files/ won't open with Windows 10 Closed

    Hello, I am unable to open some excel files since going over to Windows 10. I have tried some of the suggestions found on the internet but no solut...

    Dibble | Excel | Latest reply: Dibble Jan 18, 2016
    0 replies
  • automatically copy the row into the appropriate sheet Closed

    Hi everyone. I've set up an excel 2010 workbook to log maintenance repairs through the hotel. sheet 1 is an ongoing log of 5 columns. A= location ...

    cam64 | Excel | Latest reply: vcoolio Jan 18, 2016
    1 reply
  • Do I combine 2 Formulas? Closed

    Hello, I have most of my formula but I can not figure out how to do the last part. here is what I need (60-A1)*0.00055 so I have that set up under ...

    stargazer | Excel | Latest reply: stargazer Jan 16, 2016
    0 replies
  • how to set no of copies to 5 in print preview Closed

    Hello, I would like to request that how to set no of copies to 5 in print preview through macro with showing print dialog of MS-Office 2013 Tha...

    smuneeb | Excel | Latest reply: smuneeb Jan 16, 2016
    0 replies
  • Macro to copy and paste rows until blank comes Closed

    Hello, Can anyone help me to write macro code for the below condition. I have data sheet which updates on a daily basis and no. Of rows with r...

    Emmanuel | Excel | Latest reply: Emmanuel Jan 16, 2016
    0 replies
  • Excel Filter/Macro Solved/Closed

    Hello, Thank you in advance for any time/help you can offer! I'm working on a contact list in Excel and I need to be able to filter my contacts i...

    LSKM | Excel | Latest reply: vcoolio Jan 15, 2016
    4 replies
  • Run-time error with copy-and-insert rows macro Closed

    Hi, I am using the following macro to copy and insert rows in an Excel spreadsheet, based on a user inputted value. I place the cursor in the desire...

    Greg | Excel | Latest reply: Greg Jan 15, 2016
    12 replies
  • How to automate copying cells from one workbook to another. Closed

    I need a VBA, macro or some way to be able to load cells from one workbook to another. The first workbook has the cells I need on one row, I need to c...

    smoothsa | Excel | Latest reply: smoothsa Jan 15, 2016
    0 replies
  • can't open Microsoft office Closed

    Hello, i just install the business in box app to see an example of a document. but then there's something wrong with the Microsoft office. i fou...

  • Colours for dates that are on 2 & 3 month cycles Closed

    Hello, In my current role, I have a number of people that I have to assess. I would like to be able to do the below so i can easily identify who i...

    akers | Excel | Latest reply: ac3mark Jan 14, 2016
    1 reply
  • Columns & Rows Help Solved/Closed

    Hello all, In short, here is what I need help doing: I would like to take 15 items in one column and transfer them into a row in another spread...

    futurepsych92 | Excel | Latest reply: futurepsych92 Jan 14, 2016
    5 replies
  • Formula for if cell contains word, assign value for multiple Closed

    Hello, I am looking for a formula to help me assign a value for multiple words and values. If column A has the contains Apple, assign X. IF i...

    hdiesel | Excel | Latest reply: ac3mark Jan 14, 2016
    1 reply
  • Highlight Dates for 3 or 2 month cycles Closed

    Hi, I manage a number of staff and have to assess them. I want to be able to do the below so i can easily identify who is close to the time limit. ...

    akers | Excel | Latest reply: akers Jan 14, 2016
    0 replies
  • Excel Filter Question Closed

    Hello, I'm working on a contact list in Excel and I need to be able to filter my contacts in a few different ways. Each contact is in a row and ea...

    LSKM | Excel | Latest reply: LSKM Jan 14, 2016
    0 replies
  • Excel conditional formatting Closed

    Hi All, I need your help with conditional formatting please? I've a project timeline on a week and month calendar form. I've applied conditiona...

    Danieeeella | Excel | Latest reply: TrowaD Jan 14, 2016
    3 replies
  • forget password of Excel file Closed

    Hi, All friends I have forget password for my excel files to open, can any one help me to open this file. I have attached picture of problem. ...

    musharafpk | Excel | Latest reply: musharafpk Jan 14, 2016
    0 replies
  • get last used column address using current region property Closed

    Greetings, I have attached an image a look like of my input file. In this, I need to get the address of the highlighted portion. I have used 1 as t...

    Poojapriya | Excel | Latest reply: Poojapriya Jan 14, 2016
    0 replies
  • 25% of a cell if text in another? Closed

    Hello, I was wondering if someone could help me with the formula for 25% of a cell if another cell has text in it to give me the sum total of a ra...

    ojitos | Excel | Latest reply: ojitos Jan 13, 2016
    0 replies
  • Excel data transfer between separate spread sheets Closed

    Hi guys, I have a table in the spreadsheet that I want to transfer data from to another spreadsheet. The thing is that even though not every field ...

    dynamit3 | Excel | Latest reply: dynamit3 Jan 13, 2016
    0 replies
  • Need to search an excel spreadsheet column Closed

    but hoping I'm wrong? Need to search an excel spreadsheet column (say column D) for all rows with the text "3 Pounds" If the text is found in a cel...

    heyhere | Excel | Latest reply: heyhere Jan 13, 2016
    1 reply
  • conditional formatting Closed

    Hello, I need a help from you . Am trying to give three color condition in a pivot table and slicers report. We have sheet with Pivot table ...

    Sriram | Excel | Latest reply: Sriram Jan 13, 2016
    0 replies
  • Bringing similar names of different spelling together Closed

    Hello, I have 2 similar files. each has several columns of information. each row for one person. 80-90 % of the rows in 2 files are the same person...

    Hafez Gorgani | Excel | Latest reply: Hafez Gorgani Jan 13, 2016
    0 replies
  • formula if you have credit in one column, debit in next column Solved/Closed

    Hello, what is the formula if you have credit in one column, debit in next column and balance in 3rd column. Many thanks R Horner Configurat...

    Jack | Excel | Latest reply: Jackthelad Jan 13, 2016
    4 replies
  • Macros Invoicing drop down list Closed

    Hello, Hope everyone it doing well. I am looking for some help with Excel 2010. I have a template that I use to invoice my customers. My customer ...

    snorklemanjd | Excel | Latest reply: ac3mark Jan 12, 2016
    1 reply
  • Excel right and left arrows not working properly Closed

    Hello, I spilled Coke on my laptop this afternoon and while frantically trying to remove it I pressed something that has inserted some kind of pr...

    Renatta | Excel | Latest reply: Renatta Jan 12, 2016
    0 replies
  • how excel displays ascending order of data in other spreadsheet Closed

    hello, I try to prepare data of students details with random serial no.s in one excel spreadsheet. How I link it to display ascending order i.e.sma...

    akshay@kumar | Excel | Latest reply: TrowaD Jan 12, 2016
    1 reply
  • Data subsets and duplicates Closed

    Hello, I have been trying to find the answer in a few forums but haven't found quite what I'm looking for. I have a column (A) of around 2000 n...

    ResearchFellow | Excel | Latest reply: TrowaD Jan 12, 2016
    1 reply
  • need a cell to change colour if another cell has an 'x Closed

    hello, i need a cell to change colour if another cell has an 'x' in it. so if cell r14 has an x in it cell r13 turns green can anyone help? tha...

    Martin | Excel | Latest reply: vcoolio Jan 12, 2016
    1 reply
  • Excel conditional formatting w/date range and containing text Closed

    Hello, I need to make a conditional format based on the date in a cell being between 30-60 days past today's date and only if another cell contain...

    debbie | Excel | Latest reply: Dani Jan 12, 2016
    2 replies
  • how to link my mail iD Closed

    Dear Sir/Maám actually our company is secured our intra so please give istruction how to open my mail id thanks,

    pradhan4612 | Office Software | Latest reply: BunoCS Jan 12, 2016
    1 reply
  • Date format not changing! Closed

    I exported some data from a CRM system and the date exported like: Dec 9 2015, 3:00 PM I need to change this to: 12/9/2015 I've tried chan...

    jena206 | Excel | Latest reply: jena206 Jan 11, 2016
    0 replies
  • Excel date formula won't change Closed

    Hello, I exported some data from a CRM system and the date exported like: Dec 9 2015, 3:00 PM I need to change this to: 12/9/2015 I've tried...

    Jen | Excel | Latest reply: Jen Jan 11, 2016
    0 replies
  • conditional Formatting cell in a column vs a cell in other col. Closed

    Hello, I am comparing two cells in two different columns. I will do this for the 124 rows. if column G cell let's say G7 is larger than B7 then G...

    jjpcpanama | Excel | Latest reply: jjpcpanama Jan 11, 2016
    0 replies
  • Help with Sumif function please.. Closed

    Could someone please help me?? I need to sum the values of a range of cells that contain certain text (product codes) into another cell. For example...

    sterjohn | Excel | Latest reply: aquarelle Jan 9, 2016
    1 reply
  • if condition Closed

    if a2=mathura then result plm a2=agra and b2

    AMIT | Excel | Latest reply: aquarelle Jan 9, 2016
    1 reply
  • How to re/name a cell if another cell contains X Solved/Closed

    Hello, Apologies if this is a simple question but having some trouble figuring it out. I have say 1000 rows of data and I need to label them all...

    Alexzandeur | Excel | Latest reply: vcoolio Jan 8, 2016
    5 replies
  • Screen is locked - its not scroll lock Closed

    Hello, My screen wont move up or down, neither from cell to cell. Its not the scroll lock function. Anybody know what function I activated by mi...

    Carien | Excel | Latest reply: Carien Jan 8, 2016
    0 replies
  • Data arrangement Closed

    Hello, I have 2 sheets in an Excel workbook. I am trying to code certain cells in a pre-made template on Sheet 1 to automatically sync with my dat...

    apple78 | Excel | Latest reply: vcoolio Jan 8, 2016
    1 reply
  • Define a default path for macro enabled template file (saving) Closed

    Greetings, I have created a macro enabled template file named test.xltm. Double click on the file opens a file named test1. on choosing save as res...

    maya | Excel | Latest reply: maya Jan 7, 2016
    0 replies
  • fill in automatically Closed

    Hello, I have two colum in excel sheet colum A1 contain big list of job titles each one of it have a code for example: Job Title name ...

    iSaeed11 | Excel | Latest reply: iSaeed11 Jan 7, 2016
    2 replies
  • Daimary Closed

    Please accept me.

    Gwmbwr | Word | Latest reply: Ambucias Jan 6, 2016
    1 reply
  • Macro Help Closed

    Hello All, In short, this is the issue I am facing: I have created a macro to copy and paste data from one spreadsheet to another. Specifically,...

    futurepsych92 | Excel | Latest reply: futurepsych92 Jan 6, 2016
    2 replies
  • copy data from 2 sheets in 1 workbook to new workbook Closed

    Hello, I am new to macros in Excel and could use any help. I want to copy the basic name and customer info from 1 sheet(1) and create a new workb...

    DoubleDDD | Excel | Latest reply: DoubleDDD Jan 6, 2016
    2 replies
  • Can I get the Autofilter to work automatically without Closed

    I have the following which is filter my data based on a cell: Private Sub Worksheet_selectionchange(ByVal Target As Range) If (Intersect(Target...

    Matt | Excel | Latest reply: Matt Jan 6, 2016
    3 replies