Office Software Forum

Ask a question
Search
Close
Results 5301 - 5350 of about 16,600
  • Help me on this formula to shorten Closed

    Hello, please help me out to shorten this formula.. =IF(B53="SP1",2,IF(B53="SP2",2,IF(B53="SP3",2,IF(B53="SP4",2,IF(B53="SP5",2,0)))))+IF(B54="...

    mathewmunna | Excel | Latest reply: Mazzaropi Nov 28, 2014
    1 reply
  • How can we find data in different Excel sheets by VBA? Solved/Closed

    Hi.I have 2 workbooks named DB1 and DB2.The first one involves 12 sheets sorted by months names for example:"Apr-14" ,each sheet contains a table wit...

    polarstorm | Excel | Latest reply: polarstorm Nov 27, 2014
    0 replies
  • Create a new sheet using data in one column copying data Closed

    Does any one know how to create a macro which takes the following data: A B C D 1 Rabbit Carro...

    LEJN | Excel | Latest reply: LEJN Nov 27, 2014
    0 replies
  • Copy rows from activesheet and create and paste in new sheet. Closed

    Hey guys I have a workbook with +-5000 rows of rooms in different buildings. I want use the column BUILDING_CODE and copy all the rooms that have ...

    heyxarno | Excel | Latest reply: heyxarno Nov 27, 2014
    2 replies
  • Copy template .xlsx file based upon unique cell values Closed

    Dear All, Need you help for copying template .xlsx files based upon the unique cell values present in another excel file called file1.xlsx-->values i...

    ShailShin | Excel | Latest reply: ShailShin Nov 27, 2014
    0 replies
  • Conditional formating to check text in another shell + numeric Solved/Closed

    I have some text in A column ( say xxx, yyy) and numeric value in Column B . Now i want to highlight the shell in column B with 4 condition . 1....

    Karthikeyan1207 | Excel | Latest reply: vcoolio Nov 27, 2014
    3 replies
  • customize multiple workbooks Closed

    I am currently working on attempting to consolidate excel workbooks in that I am looking for a way to input in one workbook and have it transfer to 2 ...

    katybird88 | Excel | Latest reply: katybird88 Nov 26, 2014
    0 replies
  • How do i copy database information to excel? Closed

    How do i copy information from a database to an excel sheet?

    bezacharity | Excel | Latest reply: Mazzaropi Nov 26, 2014
    2 replies
  • help me to count 2 cells Solved/Closed

    helo, please help me to count 2 celles A1 Is either 0 or 2, A2 is either 0 or 2 IF A1+A2=0 A3 should be 6, IF A1+A2=2 A3 Should be 3 if A1+A2...

    mathewmunna | Excel | Latest reply: mathewmunna Nov 26, 2014
    2 replies
  • lock cells in Excel Solved/Closed

    After setting up VB to lock cells in Excel I now need to lock additional cells. I currently have the following script (kindly given by rizvisa1) which...

    MartynP | Excel | Latest reply: MartynP Nov 26, 2014
    2 replies
  • csv to xml in macro Closed

    how to convert one csv file to xml using macro No description PLMN-PLMN/BSC-393337/BCF-1012...

    sunita1983 | Excel | Latest reply: sunita1983 Nov 26, 2014
    0 replies
  • help me to count different charecters on 2 cells Closed

    Hello, Please help me to count different charecters like xpa, spa, spb xpb.. if any of this exist in the cell it should count. if xpa is in A1 spa ...

    mathewmunna | Excel | Latest reply: mathewmunna Nov 26, 2014
    0 replies
  • Help - how to conditionally copy columns to multiple worksheets Closed

    Hi, Newbie member searching for a solution to what is probably a straight forward problem. I am new to Vba so have little understanding but am famili...

    thewelshwizz | Excel | Latest reply: thewelshwizz Nov 25, 2014
    0 replies
  • Needs some help with a formula Solved/Closed

    Hello, Configuration: Windows XP / Firefox 33.0 Okay, here is a problem I've been dealing with for over an hour now. This should be easy, but ...

    dgcasey | Excel | Latest reply: dgcasey Nov 25, 2014
    5 replies
  • An outlook express store file is damaged. Closed

    Hello everyone. Can you help me! Whenever i open express outlook error is showing up and i cant receive or send mails. It's written that outlook expr...

    lary1234 | Outlook | Latest reply: ac3mark Nov 25, 2014
    1 reply
  • Copy row from sheet 1 to sheet 2 if value is x Closed

    Hello, I've searched around and can't really find anything that answers my question or I can understand. I'm quite able with excel but not great w...

    Liamd | Excel | Latest reply: Liamd Nov 25, 2014
    0 replies
  • Excel Help with Macro Closed

    I have an excel workbook with 4 Sheets. Sheet 1 (summary) is a ledger. Sheet 2 = Bob Sheet 3 = Bill Sheet 4 = Bart Column D in the ledger ...

    millek31 | Excel | Latest reply: ac3mark Nov 24, 2014
    7 replies
  • Macro program for sum Closed

    Hello, I need to find out a formula for sum for the following conditions if (and(cell b1="text", cell b5="text",cell b10="text",cell b16="text")s...

    rihan | Excel | Latest reply: rihan Nov 24, 2014
    0 replies
  • Date Formating Closed

    I have a huge file with date format in column "e" 3/8/45 and I want to change it to 8-Mar-1945. Also birth date is in col. e15 and the death date is...

    Shotwell | Excel | Latest reply: Shotwell Nov 24, 2014
    0 replies
  • Numbers & Symbol ü (New Challenge) Solved/Closed

    i need a formula to automatically check mark i.e(ü) mark a cell(eg:A1) if another cell (eg:H1)contains number:1 Condition is H1 may contain any numbe...

    mathewmunna | Excel | Latest reply: mathew Nov 23, 2014
    5 replies
  • Copy Data On Condition From One Sheet To Another Closed

    Hello, I have 15-16 sheets.. AND I ENTER data in sheet1 & sheet2 .. i want a code that can copy data from sheet1 / sheet2 to sheet3 or any other s...

    Shkhaslam | Excel | Latest reply: rizvisa1 Nov 22, 2014
    1 reply
  • Message Boxes Closed

    Hello everyone, Does anyone know if it is possible to format a basic message box (just font and colour)? Or is it a case of "what you see is what y...

    vcoolio | Excel | Latest reply: vcoolio Nov 22, 2014
    2 replies
  • printing the same worksheet changing a cell with data populated Closed

    How do you print the same worksheet repeatedly, changing a cell with data populated from a table?

    BeanCounter | Excel | Latest reply: rizvisa1 Nov 22, 2014
    1 reply
  • Copy data from one sheet to other sheet. Closed

    Hi guys! I have a problem coping data from one row within a specific range, example A2, B2, C2, D2, E2 and so on up to P2, and copy that data to diffr...

    glukos | Excel | Latest reply: rizvisa1 Nov 22, 2014
    1 reply
  • Excel Auto Create Sheet and Populate Closed

    Hey Everyone, I'm looking to create the following; I have a list of employees who will be working on an event. The event is broken up into stages,...

    stephenruggieri | Excel | Latest reply: rizvisa1 Nov 22, 2014
    1 reply
  • Copy data from mutiple workbooks and paste below each other Closed

    Hello, I need to copy data from multiple workbooks and paste in another workbook below each other. This is the first part. I need to copy data...

    Fay | Excel | Latest reply: rizvisa1 Nov 22, 2014
    1 reply
  • Total up boldly formatted cells Closed

    Good evening much appreciated volunteers I am using an Excel 2007 spreadsheet to keep track of costs associated with a holiday. I have bolded al...

    TanyaRT | Excel | Latest reply: rizvisa1 Nov 22, 2014
    4 replies
  • How to date tabs in sequential order using Macro Closed

    Hello, Not too long ago I came across a helpful Marco that dated each Excel worksheet tab in sequential order with the Month and Date (i.e. Nov 1 ...

    Vanessa | Excel | Latest reply: vcoolio Nov 22, 2014
    1 reply
  • help on making student report card Closed

    Hello, hello i was thinking about making student report card system in excel, no of student is around 40 in one class ...........please tell me ...

    raj | Excel | Latest reply: venkat1926 Nov 22, 2014
    2 replies
  • Comparing worksheets in excel Closed

    Hello, I have 2 sets of data in Sheet1 and Sheet2 in excel. Both sheets have the same 7 columns and I want to compare the data in Sheet1 and Sheet...

    Hannah | Excel | Latest reply: vcoolio Nov 21, 2014
    1 reply
  • Sending emails is not working on out look can receive though !! Closed

    Hi really hope you can help as 3 days of not being able to use my email and I'm going to have such a back log. I use sky email but through out look...

    Clare21 | Outlook | Latest reply: ac3mark Nov 21, 2014
    1 reply
  • Copy a row to another sheet if a value is x Closed

    Hello, I'm searched around and can't really find anything that answers my question or I can understand. I'm quite able with excel but not great w...

    Liam | Excel | Latest reply: Liam Nov 21, 2014
    0 replies
  • Split a Range of data in Column A across subsequent columns Closed

    Hi, I have more than 1000 (it will go beyond 4000 somtimes) order numbers in column A that I would like to split across the subsequent columns star...

    FetchItNow | Excel | Latest reply: FetchItNow Nov 21, 2014
    0 replies
  • Automatically transfer data from one worksheet to another Closed

    Hello, I have an Excel workbook with two worksheets in it. The first worksheet is rows of data organized by Region, Client, Date, Product, Rep, etc...

    vamus21 | Excel | Latest reply: vcoolio Nov 21, 2014
    1 reply
  • Namning sheets after namnes in a column. Closed

    Searched for hours trying to solve this problem.., I have a list of students in my workbook and want to automaticly change the following sheets in my ...

    glukos | Excel | Latest reply: venkat1926 Nov 20, 2014
    1 reply
  • copy data from multi tabs of multiple files to one file with res Closed

    Need help in copying data from multiple files. Below is the situation. 1. I have total 70 identical file with different data in that. 2. All 70 ...

    molletica | Excel | Latest reply: molletica Nov 19, 2014
    5 replies
  • Excel Loop Lookup Closed

    I am trying to do a lookup on following sheet (4 columns Store, Part, K or R, New K or R): Store Part K or R New K or R 1 ABC R 2 ABC K 3 ABC ...

    InvDR | Excel | Latest reply: Mazzaropi Nov 19, 2014
    1 reply
  • Compare Columns and return a value from third column Closed

    Hello, I need to compare 2 columns and fill data from a third column. Here is the scenario. A B C D 1 1 X =X 2 3...

    bedge | Excel | Latest reply: Mazzaropi Nov 19, 2014
    1 reply
  • Lock cell in Excel worksheet with VB Solved/Closed

    I have an worksheet that I need to lock the cell based on the value of another cell. I have managed to create VB which will do this for one row but n...

    MartynP | Excel | Latest reply: Martynp Nov 19, 2014
    5 replies
  • Insert Multi Rows Between Existing Data Solved/Closed

    Hello, I am trying to create a macro that will insert a set amount of blank rows into a existing spreadsheet after each entry. The amount of rows ...

    froggy6703 | Excel | Latest reply: SWAJI Nov 19, 2014
    20 replies
  • how to change mm/dd/yyyy to dd/mm/yyyy format in excel Closed

    Hello, Configuration: Windows XP / Chrome 38.0.2125.111 how to change mm/dd/yyyy to dd/mm/yyyy format in excel

    briz | Excel | Latest reply: rizvisa1 Nov 19, 2014
    2 replies
  • Namning sheets after namnes in a column Closed

    Searched for hours trying to solve this problem.., I have a list of students in my workbook and want to automaticly change the following sheets in my ...

    glukos | Excel | Latest reply: glukos Nov 19, 2014
    0 replies
  • Copy and Paste row 5- row 9 n number of times Closed

    Hello, I am trying to save size of my Workbook from blowing of, which has lots of vlookup's and other formulas. So, i am trying to copy row 5-...

    vic | Excel | Latest reply: venkat1926 Nov 19, 2014
    1 reply
  • Excel Auto Create Sheet and Populate Closed

    Hey Everyone, I'm looking to create the following; I have a list of employees who will be working on an event. The event is broken up into stages, ...

    stephenruggieri | Excel | Latest reply: stephenruggieri Nov 18, 2014
    0 replies
  • Copy and insert rows and number of times Solved/Closed

    Hello, I have a sheet with over 800 rows. I need to copy each row and insert/repeat each entry 4 times below the preceding row. Example: Bef...

    Pabs | Excel | Latest reply: Duck Nov 18, 2014
    22 replies
  • Pulling Informations from Excel Spreadsheet Closed

    Hello - can anyone please help me? I have a spreadsheet that has the information from a Realtor office. It has all the information from each sale ...

    mahrens66 | Excel | Latest reply: mahrens66 Nov 18, 2014
    6 replies
  • copy the data in sheet 1 of excel A to sheet 1 of excel B Closed

    Hello, I want to copy the data in sheet 1 of spreadsheet A to sheet 1 of spreadsheet B on clicking the update button in spreadsheet B Ex: Sh...

    Nithin | Excel | Latest reply: Nithin Nov 18, 2014
    0 replies
  • PowerPoint navigation problem Closed

    Hi I am using PowerPoint to create elearning content and was wondering if anyone knew of a way to incorporate a navigation bar that would allow stud...

    deskmonkey | PowerPoint | Latest reply: deskmonkey Nov 18, 2014
    0 replies
  • [Excel] - Copy Value and Save As Macro Closed

    Hello, I'm trying to write a macro to copy a single value (ID number) from column C in a table on Sheet1 into cell A2 in Sheet2, and save a copy o...

    Harriet | Excel | Latest reply: Harriet Nov 17, 2014
    0 replies
  • Excel help\ Closed

    I am trying to fill a column with values from other columns that have an A or B next to them. In column a I have an amount and the next column be the...

    reils | Excel | Latest reply: reils Nov 17, 2014
    0 replies