Office Software Forum

Ask a question
Search
Close
Results 3451 - 3500 of about 16,600
  • If one cell G4 has value 12345 then cell F4 will have.... Solved/Closed

    I need help with a basic excel formula. Please :) If cell G4 equals 12345 then cell F4 equals USXX but also if cell G4 equals 54321 then cell F4 w...

    NeedExcelHel... | Excel | Latest reply: ac3mark Jan 26, 2016
    3 replies
  • data export Closed

    Hello, I made a questionnaire generator for various kinds of products according to an advice from this forum. The original topic is here: https://...

    pefler | Excel | Latest reply: pefler Jan 26, 2016
    0 replies
  • How do i Convert a value in a cell to english string? Closed

    Hello, Would like to know is there anyway that I can convert the value in a cell to english string? eg "1,220.76" in a cell and convert it to a...

    Derek | Excel | Latest reply: Derek Jan 25, 2016
    0 replies
  • Insert data to the empty cell below Closed

    Hi, I need a macro to insert data from one cell to another below (empty cell/the same column) for ex: I need to insert data from A1 to A2 then data...

    Olga_Niva | Excel | Latest reply: Olga_Niva Jan 25, 2016
    0 replies
  • Fill in blank rows Closed

    Is there any formula or Macro that I can use to fill in blank rows from the last cell above that has data in it. For example, I have a spreadsheet wi...

    jerrym19808 | Excel | Latest reply: jerrym19808 Jan 25, 2016
    0 replies
  • Auto Copy Row from one Sheet to another via Info in first Cell Solved/Closed

    Hello everyone, hope you all had a great New Year. I am in the process of exporting a BOM out of Inventor and then opening it with Excel. Once I ha...

    DK97008 | Excel | Latest reply: TrowaD Jan 25, 2016
    10 replies
  • Copy Data from main sheet to next first 5 consecutive Sheets Closed

    Hello, I would like to request a macro that copies data from any Main Sheet (Sheet Name could be in Numeric) Main Sheet range is specified i.e. B1...

    smuneeb | Excel | Latest reply: smuneeb Jan 24, 2016
    0 replies
  • Creating A Summary Sheet Closed

    Hello, I have a worksheet that is recording customer interactions, and I would like to create a seperate sheet to summarize all the customers that ...

    BuckeyeJR | Excel | Latest reply: vcoolio Jan 23, 2016
    1 reply
  • Desktop Publisher Closed

    Hi, I have just installed Open Office in my Dell Optiplex 755 and I wanted to work on a booklet - it seems not working well with me. Any idea plea...

    Mkisige | Open Office | Latest reply: Ambucias Jan 23, 2016
    1 reply
  • if Font color is red then.... Closed

    Hello, I would like to request that if the font color of cell A is red then how to apply the conditional to cell B that it changes to as per our r...

    smuneeb | Excel | Latest reply: smuneeb Jan 23, 2016
    0 replies
  • Look up a word, then input a word from cell adjacent Closed

    Hello, Im looking for a way; in excel, to search for a word, find the word then take a value from the cell directly adjacent to that cell. For examp...

    Help | Excel | Latest reply: Help Jan 23, 2016
    0 replies
  • Copy value from sheet 2 to next blank cell in sheet 1 Closed

    Hello, I have a worksheet that works out golf handicaps from the score entered, what I need is a macro that copies the score from sheet2 A1 to the n...

    Loc | Excel | Latest reply: Loc Jan 23, 2016
    0 replies
  • Button to copy sum to next row on another sheet Closed

    Hi, I think i have almost go this (pretty new with vba). On first sheet 'comparison' i have a few variables which can be changed then the sum of...

    Stokesy13 | Excel | Latest reply: vcoolio Jan 22, 2016
    3 replies
  • excel 2103 Closed

    Hello, I am having trouble I have 1 workday starting on 2/19 and ending on 2/19 the value comes back as 0 when I enter the workday formula how do ...

    mimi | Excel | Latest reply: mimi Jan 22, 2016
    0 replies
  • Barcode Help!! Closed

    Hello, I am making a barcode system and I want to be able to display the information given in the barcode in the cells next to it. For example I a...

    Devyn | Excel | Latest reply: ac3mark Jan 22, 2016
    2 replies
  • Auto Populate record from one sheet to another Closed

    I'm working on a commissions spreadsheet for my company. There is a separate tab for each sales rep as well as the Sales Director. For every record ...

    newhgl1 | Excel | Latest reply: newhgl1 Jan 22, 2016
    0 replies
  • How do I exclude a value when using COUNTA? Closed

    Hello, I am currently using the following formula to count cells that are not empty =COUNTA (D4:D17) However in this range there are certain...

    Dan | Excel | Latest reply: RayH Jan 22, 2016
    1 reply
  • automatically send lines of data to sheets from a master Closed

    Hello, i have a master sheet of over 2000 entries, one of the columns is "category" based on this category i want to send the whole line of data t...

    finch13 | Excel | Latest reply: finch13 Jan 22, 2016
    0 replies
  • Cant get vba code to work as desired... Closed

    Hi, Looking for a solution to the following issue with some vba code I was kindly given. 1) I have a scenario where if a user leaves one or more...

    fingermouse | Excel | Latest reply: fingermouse Jan 22, 2016
    0 replies
  • Automatic transfer of data Closed

    Dear CCM, I have a sheet with combined values for different units and I manually sort into the different units manually by copying and pasting into ...

    Ibtom | Excel | Latest reply: vcoolio Jan 22, 2016
    1 reply
  • excel Closed

    Hello, if the column a and column b are equal, i want to put "-"(minus sign) before the data of column b for further technical purpose. eg. it lo...

    Bkp | Excel | Latest reply: vcoolio Jan 22, 2016
    1 reply
  • How to compare data between two excel files Closed

    Hello, I want to know the easiest way to compare data between two different Excel files.Both the files are same in structure but data can be diffe...

    Sumit | Excel | Latest reply: Sumit Jan 22, 2016
    0 replies
  • VBA: Creating new Sheets based on copy, Nameing them the Cells Closed

    Ok, i am gonna try to be so clear i can. on Sheet 1 (Start Sida) i have a list from cells A9 to A500 with names. atm only A9-A52 have names in them. ...

    Zodiacswe | Excel | Latest reply: vcoolio Jan 22, 2016
    1 reply
  • Average a range of data with leaving out one value each time Closed

    Hello, I'm trying to write a macro to calculate the onset time of LRP. I need to average 30 columns with leaving out one column each time. For exa...

    ZOUjojo | Excel | Latest reply: ZOUjojo Jan 22, 2016
    0 replies
  • How to copy values in sheet 1 to sheet2 based on column name Closed

    Hi, please help with the query here. I have set of data in sheet 1 and sheet 2. Sheet 2 is the source data. Sheet 1 contains the data after it's confi...

    ashjey29 | Excel | Latest reply: ashjey29 Jan 22, 2016
    0 replies
  • Need the number of rows with exact criteria from 2 columns Closed

    Hello, I'm trying to create a formula that tells me how many rows fit the specific criteria. I have my data on my first tab. The first crucial infor...

    MiaScales | Excel | Latest reply: MiaScales Jan 21, 2016
    0 replies
  • how can I multiply a numeric value and alphabetic value in exce? Closed

    Hello,plz answer as soon as possible

    gurpreet | Excel | Latest reply: ac3mark Jan 21, 2016
    1 reply
  • Difficult Query Closed

    Hello, I would like to request for a difficult query that may be not solvable logically. If user enter az123456789 or az-123456789 it always co...

    smuneeb | Excel | Latest reply: TrowaD Jan 21, 2016
    4 replies
  • autofill a column according to values in another column Closed

    Hello, I need to autofill a column according to certain data in another column It goes like this Column B contains various data including a ...

    shanks | Excel | Latest reply: shanks Jan 21, 2016
    0 replies
  • Automatically transfer data from one worksheet to various others Closed

    Hi, I am trying to figure out how to automatically transfer data from one excel worksheet to another worksheet but only when a specific cell(s) ar...

    621carrots | Excel | Latest reply: vcoolio Jan 21, 2016
    1 reply
  • Automatically transfering data after generating new worksheets Closed

    Hello, It has been a while since I have worked with code and would appreciate any help. I have one code already working which is gathering all ...

    Ricky | Excel | Latest reply: vcoolio Jan 21, 2016
    3 replies
  • How to automatically create workbook Closed

    Hi, I have a table (contain a list of problem in production line) in a workbook. I want that, whenever I add a line in the table to register a probl...

    digun | Excel | Latest reply: digun Jan 21, 2016
    0 replies
  • Search and copy.. Closed

    I have two Work Books open and I have filters on both WBs.. Let's say I have filters for Name, Birth Date, Address, and Phone# for both WBs. Is it pos...

    ja981m | Excel | Latest reply: ac3mark Jan 20, 2016
    3 replies
  • Macro to rename tabs based on cell reference on another sheet Closed

    Hello, I am attempting to rename 5 sheets in a workbook based on values from a sheet titled Raw Data Information. The first sheet should be named bas...

    jlcorte14 | Excel | Latest reply: ac3mark Jan 20, 2016
    1 reply
  • When I transfer my pst file, not all of my files/folders transfe Closed

    Hello, I am copying over my pst file into an exchange database, I have been able to transfer over all files except two. These two files come up wi...

    Booker85 | Outlook | Latest reply: ac3mark Jan 20, 2016
    1 reply
  • countdown in excel Closed

    Hi, I'm a bit of a formula novice in excel. I have been googling, but not sure if I'm typing in the right questions, or if what I want to do is eve...

    sarahwinter | Excel | Latest reply: ac3mark Jan 20, 2016
    1 reply
  • Macro to rename sheets based on cell value in another sheet Solved/Closed

    I am attempting to rename 5 sheets in a workbook based on values from a sheet titled Raw Data Information. The first sheet should be named based on '...

    jlcorte14 | Excel | Latest reply: jlcorte14 Jan 20, 2016
    0 replies
  • 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