Office Software Forum

Ask a question
Search
Close
Results 1801 - 1850 of about 16,600
  • 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
  • add "only" at last after converting numbers into words ? Closed

    Hello, how to put "only" at last after converting numbers into words ? thank you System Configuration: Windows / Chrome 56.0.2924.87

    Shailesh | Excel | Latest reply: Shailesh Mar 15, 2017
    0 replies
  • Merging Mutiple Sheets column data when if conditions passes Closed

    Hello, I have excel book with multiple sheets. Rows count with data will differ in each sheets. And column C with have two data "Come" & "Out" Wh...

    BA7A1Lak | Excel | Latest reply: BA7A1Lak Mar 14, 2017
    0 replies
  • Insert picture in Excel macro which takes the file name refrence Closed

    Hello Friends, Kindly help me! I am trying to insert a picture in excel macro which takes the file name reference from the D5 cell and insert th...

    V Kanagu | Excel | Latest reply: TrowaD Mar 14, 2017
    23 replies
  • VBA code for deleting rows where a column does not correspond Closed

    Hello I am trying to get a code that will delete lines where the column on one sheet does not correspond to the criteria in another (i.e. the date - ...

    everett18 | Excel | Latest reply: everett18 Mar 14, 2017
    0 replies
  • Formula for text in a cell and then total the amount on text Closed

    Hello im trying to total the shfit allowance on timesheets eg: In cell k7 they will leave blank if not claim shift allowance, but if they are then ce...

    NicoleQA | Excel | Latest reply: Mazzaropi Mar 14, 2017
    1 reply
  • Changing font color Closed

    Hello, I need help, I want to change the font color to be black for cell A, if cell B is "done", else keep the due date in red in cell B. For exmp:...

    Juli | Excel | Latest reply: Juli Mar 14, 2017
    0 replies
  • Create a new Excel file based on data in 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...

    Trey | Excel | Latest reply: Trey Mar 13, 2017
    0 replies
  • Change Value of Subsequent Cells Once A Condition Is Met Closed

    The simplified story: I have a user input "Start Month" that is between 1-12. I have Columns A:M labeled accordingly 1-12. The question: If the us...

    strangerarray | Excel | Latest reply: ac3mark Mar 13, 2017
    1 reply
  • Date change Closed

    The interfaced data date from an EMR system to my system reported as an Excel has the date with Year, month and date, example 2017-01-15. I am trying...

    Kat | Excel | Latest reply: Kat Mar 12, 2017
    0 replies
  • Excel formulla Solved/Closed

    Hello, I want to split cell of available qty in to multiple cell according to requirement. Input Sheet -1 Material PO qty Req. Qty ...

    Jayesh patel | Excel | Latest reply: Jayesh patel Mar 12, 2017
    0 replies
  • VBA To automatically insert subtotals in multiple worksheets Closed

    Good Day, I hope somebody can help me, I have an workbook with a main sheet ""2017 Sales" and 10 worksheets with the name of each individual sales Age...

    vics1000 | Excel | Latest reply: vics1000 Mar 12, 2017
    1 reply
  • Open workbook using following code Closed

    Private Sub CommandButton1_Click() Workbooks("Patch.xlsm").Activate Sheets("Site Name").Select S = Range("A1:A2") D = Range("B1:B2") E = Range("B...

    reza | Excel | Latest reply: x Mar 10, 2017
    1 reply
  • auto insert new row and copy data from cell above Closed

    hello, I have looked but can not seem to find. I need a macro that will insert a new blank row row below and copy cell A10 from above and paste it to...

    Zalast69 | Excel | Latest reply: Zalast69 Mar 9, 2017
    0 replies
  • Creating reminders AND/OR email reminders in Excel 2010 Closed

    Hello, I would like to create a spreadsheet with the following information; Name Address Sender ...

    timothyjester | Excel | Latest reply: timothyjester Mar 9, 2017
    0 replies
  • Add value from column 2 if column 1 equals to "Yes" Closed

    Hello, I want to create a histogram of spenditures and automatically summarize them in a table next to it. So if a value (cell b2) is in the categor...

    DavidPeterson | Excel | Latest reply: DavidPeterson Mar 9, 2017
    0 replies