Office Software Forum

Ask a question
Search
Close
Results 1751 - 1800 of about 16,500
  • Macro for copying and pasting (related to answered question) Closed

    Hello, You recently provided this answer to a question (see below). I'd like to do almost exactly what you recommend, except my spreadsheet has si...

    kk | Excel | Latest reply: kk Mar 29, 2017
    0 replies
  • VBA date Closed

    Hello, please can anyone help me? With the below code i'm trying to format the cell color when an date in a cell reaches the system date or a set ...

    lynng | Excel | Latest reply: lynng Mar 29, 2017
    0 replies
  • PDF file alwasy opening in Word Solved/Closed

    Hello, What to do to disable my attachment file in pdf to open in Word application?

    Lou | Word | Latest reply: blkdolphin Mar 28, 2017
    5 replies
  • how to calculate values using COUNTIF Closed

    I have 2 sheets sheet1 is a Summary sheet and sheet2 is data sheet sheet 2 has columns from A TO R, in that column G is Severity (heading) wit...

    narsing18 | Excel | Latest reply: ibrahim Mar 28, 2017
    1 reply
  • Trying to create a multi-column formula. Solved/Closed

    Hello, I need help making a formula. I will do my best to describe. The letters (A-I) refer to separate columns. A-B=C to be divided by D the res...

    oduana777 | Excel | Latest reply: TrowaD Mar 28, 2017
    9 replies
  • formula for multi answers Closed

    Hello, I'm not yet a member, first time user, however interested to be registered as soon. Hi looking for the right formula for the following....

    mandyl | Excel | Latest reply: mandyl Mar 28, 2017
    0 replies
  • Paste Values copied in alternate rows in a single column Closed

    Hello, I need to paste some data from 1 column to another column but in alternate rows. for Example:- Data to be copied is as below. Cell Valu...

    Vikasgohel | Excel | Latest reply: Vikasgohel Mar 28, 2017
    0 replies
  • Autopopulate from master sheet? Closed

    Hello, I've been making, essentially, copies of my and my husbands pay stubs. Currently I'm just copy pasting an "empty pay stub form" and manuall...

    Liakami | Excel | Latest reply: Liakami Mar 28, 2017
    0 replies
  • copy and insert rows Closed

    Hi, Everyone! I just need help I need a formula or a macro code that everytime I will manually type something on column a,b,c it will be also ge...

    Serenitylai | Excel | Latest reply: Serenitylai Mar 28, 2017
    0 replies
  • Changing current font color based on other cell's value? Closed

    Hello! I would like to change the default font color when entering text in Column B based on the text in a different cell. BUT, I would like to ret...

    Brittonica | Excel | Latest reply: Brittonica Mar 27, 2017
    0 replies
  • Removing FALSE from return Closed

    Hello, I have this formula that returns FALSE, can someone tell me how to remove this? Thanks, Ed =IF(Tama!E8,+(Tama!C8))

    Ed | Excel | Latest reply: Ed Mar 27, 2017
    0 replies
  • Date with condition Closed

    Hello, What could be the answer and how If function play Three or more condition applying in date formula? Problem A=Employment Type, B=Join...

    Sharif Jaman | Excel | Latest reply: Sharif Jaman Mar 27, 2017
    0 replies
  • Update sheet - may be by using a macro Closed

    Hello, I am trying to make a kind of template file which will be used by different users, most of them even more simple excel users than me :-) The ...

    Obonden | Excel | Latest reply: Obonden Mar 26, 2017
    0 replies
  • VBA/Copy Paste Closed

    Hello, I have a dataset with 300 rows and 10 columns. the first 4 columns have the metadata and then 6 columns with different values. what I want t...

    Ezzath | Excel | Latest reply: Ezzath Mar 26, 2017
    0 replies
  • Sum product and countif Closed

    Hi, I'm trying to calculate the number of each type item on the column B that has the condition X on the column A and wich numbers on the column C ...

    nunnoduarte | Excel | Latest reply: nunnoduarte Mar 25, 2017
    0 replies
  • Move cells based on their values Closed

    Hi, I did this a few years ago once but I can't remember how I got it to work. I have 2 sheets named BOQ and V.O. The BOQ sheet has a list of items ...

    Neiljnb | Excel | Latest reply: Neiljnb Mar 25, 2017
    0 replies
  • Update sheet by macro Closed

    Once a month I want to import data from an external workbook to my excel sheet (let's call it "Master") and change some of the content in Master, both...

    Obonden | Excel | Latest reply: Obonden Mar 25, 2017
    0 replies
  • Paste two columns under each other for multiple columns Closed

    Hello, I am new to VBA coding and trying to get things sorted for an excel document (work purpose). Unfortunately I am stuck in a [articular step un...

    su | Excel | Latest reply: su Mar 24, 2017
    0 replies
  • Paste 2 columns under each other for multiple columns with the s Closed

    Hello, I am looking for a code to paste series of 2 columns under each other. Ex: Sheet1 1 Col 1 Col 2 Col 3 Col 4 2 ABC DEF GHI JKL 3 MON PQR...

    su | Excel | Latest reply: su Mar 24, 2017
    0 replies
  • Help with Excel Closed

    Hello, I have two excel files. one is a staging inventory and the second one is the a delivery file. The inventory files has all assets number, seri...

    Thinker782 | Excel | Latest reply: Thinker782 Mar 24, 2017
    0 replies
  • VBA Paste based on Date Criteria Closed

    Hello, I would be very grateful for some assistance with this spreadsheet I am attempting to create. I've Googled what I am trying to do several tim...

    tomwilliams | Excel | Latest reply: tomwilliams Mar 24, 2017
    0 replies
  • Possible to copy/paste row based on dates? Closed

    Greetings, I would like to automatically copy rows from one worksheet into another based on dates contained in each sheet. The rows containing the da...

    Shawn0 | Excel | Latest reply: Shawn0 Mar 24, 2017
    0 replies
  • Paint cell based on another cell value with Macro Closed

    Hello, I want to paint one cell, based on value of another cell using Macro. And i want Macro to do that for entire column. Example: COLUMN A ...

    Donald | Excel | Latest reply: Donald Mar 24, 2017
    0 replies
  • VBA Paste below row with Dates Criteria Closed

    Hopefully someone can help me. I've Googled this several times and couldn't quite get the answer I'm looking for. I have data that I load and sort e...

    tomwilliams | Excel | Latest reply: tomwilliams Mar 23, 2017
    0 replies
  • downloading for PC Closed

    Hello, how can i download a free microsoft office 2007 from the web? its for PC System Configuration: Windows / Firefox 52.0

    issamshamoun | Office Software | Latest reply: issamshamoun Mar 23, 2017
    0 replies
  • Two excel sheets copy new data input on one sheet to new row on Closed

    Hello, I have an excel spreadsheet that I have to update periodically overwriting old data. I have another sheet where I need to update the same inf...

    WintersJ73 | Excel | Latest reply: maheshmahi Mar 22, 2017
    1 reply
  • i am mahi solve it Closed

    Hello, =IF(ISERROR(SEARCH("*keyword*",A1,1)),"","keyword") it is only for one cell it perfectly ok for multiple cell its not ok this formula how...

    mahi mahi | Excel | Latest reply: mahi mahi Mar 22, 2017
    0 replies
  • Need To extract data from a column to another worksheet. Closed

    Hello, I need code to extract all data containing a name from a column on sheet1 and copy it to Sheet2 and remove all blanks. The name is pulled fo...

    smv1 | Excel | Latest reply: vcoolio Mar 22, 2017
    3 replies
  • Excel problem Solved/Closed

    Hello, I want a formula in which, If I enter the number in cell, the name of that number should appear in adjacent cell. Ex: Emp No Name 1 ...

    John | Excel | Latest reply: Mazzaropi Mar 22, 2017
    3 replies
  • Populate a work schedule based on a matrix on a separate sheet Closed

    I am trying to populate a work schedule on one sheet of a workbook based on a date matrix on a separate sheet of the workbook. I have a list of nam...

    GuamDave | Excel | Latest reply: GuamDave Mar 22, 2017
    0 replies
  • How to solve Date Format dd/mm/yyyy Closed

    Hello, How to solve Date Format dd/mm/yyyy

    Mohini | Excel | Latest reply: Mohini Mar 22, 2017
    0 replies
  • recover user id of irctc Solved/Closed

    Hello, recover irctc user id , i forgot it , so help me Configuration: Windows / Chrome 53.0.2785.101

    niranjan1608 | Word | Latest reply: rishabhj2019 Mar 22, 2017
    2 replies
  • Help with Index Match or VLOOKUP Closed

    Hello, I have a worksheet with about 2000 rows. In column C and Column J i have a common Key. In Column K I have data that i want to write to Colu...

    mwilke | Excel | Latest reply: Mazzaropi Mar 21, 2017
    1 reply
  • EXCEL: If number in 2 sheets match, transfer row to third sheet Closed

    Hello! I have a question. I'm going to try to be as clear as possible. I have sheet 1 that contains all customers who are NOT on paperless billing. ...

    whitneyiei | Excel | Latest reply: whitneyiei Mar 21, 2017
    0 replies
  • password detail Closed

    how can i get the password of ms word installed in my system it keeps telling requesting for password dont know how to go about it can someone please ...

    homey101 | Word | Latest reply: Ambucias Mar 21, 2017
    1 reply
  • Need help with storing data Closed

    Hello Guys I am new to ccm.net and excel. My question is, how can i save one excel data to another .. Let me explain in detail... I want to make a ...

    muhammed361 | Excel | Latest reply: muhammed361 Mar 21, 2017
    0 replies
  • inches and feet and degrees Closed

    Hello :) I have a same invoice which I need everyday to be printed out for me but it need to be upgraded each time with different information and date...

    Yulia | Excel | Latest reply: Yulia Mar 20, 2017
    0 replies
  • VBA; Copy data between workbooks where sheet name is same Closed

    I have raw data (.xls) and using a macro I can tidy this up (adding header, text to number etc.) I then rename the sheet for the corresponding month a...

    K2299 | Excel | Latest reply: K2299 Mar 20, 2017
    0 replies
  • Copy sheet, change sheet name, change cell number, etc Closed

    Hello, I am completely new to macros, so please forgive me upfront. Through online tutorials I was able to add a macro button and copy the sheet. H...

    jsoko | Excel | Latest reply: jsoko Mar 20, 2017
    0 replies
  • Excel find word in series of cells and add Solved/Closed

    Hello, My colleague wants to has a spreadsheet with many columns and rows. The spreadsheet setup is something like this: Cells under column A ha...

    Payroll | Word | Latest reply: matt Mar 17, 2017
    3 replies
  • Highlight one value in a dropdown menu of three responses Solved/Closed

    Hello, I have a template where we are asking for responses with a drop down that includes Y, N, and N/A. We want to highlight all N answers in yell...

    MeganN | Excel | Latest reply: MeganNolf Mar 17, 2017
    2 replies
  • Create new excel files based on the data in a column Closed

    Hello, I've spent hours searching and trying different macros with no avail. I'm not new to excel, but new to macros and coding. I have a spreadshee...

    ExcelTrey | Excel | Latest reply: vcoolio Mar 17, 2017
    1 reply
  • Code to move rows into another sheet based on certain values Solved/Closed

    I'm having trouble figuring out how to do something! I have a sheet (Sheet1) with customer details on it (columns A-D will have data in). I want to be...

    nathaliecannell | Excel | Latest reply: vcoolio Mar 17, 2017
    1 reply
  • Count only cells containing 2 given words Closed

    Dear friends, I simply get mad trying and trying again to find the right function that may help me to count out of an array only the cells that conta...

    BruNL_2017 | Excel | Latest reply: BruNL_2017 Mar 17, 2017
    4 replies
  • Copy Data from Sheet 1 to Sheet 2 Closed

    I need to copy data from sheet 1 to sheet 2 based on a Keyword or search criteria. However, the data is available in hierarchical format. I need a pr...

    chavaravikanth | Excel | Latest reply: chavaravikanth Mar 17, 2017
    0 replies
  • my document was in pdf when i was trying to convert to word it b Closed

    Hello, my document was in pdf when i was trying to convert to word it became unreadable what can i do ? in Windows 7 System Configuration: Windows ...

    abegaze Beyene | Word | Latest reply: Ambucias Mar 16, 2017
    1 reply
  • Cell to populate if other column has any text Closed

    Hello, I'm struggling to find a formula to populate one column's cell based on another column's cell having at least one character of text. e.g. A1...

    therock90 | Excel | Latest reply: Mazzaropi Mar 16, 2017
    1 reply
  • Change cell text based on another cell's color Closed

    Hello, I need to prompt a cell to write text based on another's cell color in excel but not using VB. Can you help? System Configuration: Windows /...

    CarmelS | Excel | Latest reply: Mazzaropi Mar 16, 2017
    1 reply
  • Paste Values copied in alternate rows in a single column Closed

    Hello, I need to paste some data from 1 column to another column but in alternate rows. for Example:- Data to be copied is as below. Cell Val...

    Vikasgohel | Excel | Latest reply: Vikasgohel Mar 16, 2017
    0 replies
  • vba code Closed

    Hello, I need to compare 2 excel worksheets. sheet1 - col A, B, C sheet 2 - col A, B, C Compare Col A and B of sheet 1 and 2 --> if they match th...

    Sudha | Excel | Latest reply: Sudha Mar 15, 2017
    0 replies