Office Software Forum

Ask a question
Search
Close
Results 4451 - 4500 of about 16,600
  • Excel Consolidation Tab Solved/Closed

    Hi all, I am wondering if it is possible to exclude one spreadsheet from being pulled into the master tab. I could name it Data. Can you advice? ...

    nnavarro | Excel | Latest reply: nnavarro Jun 11, 2015
    4 replies
  • Customer Protected Form and Posting my data into Closed

    I have a customer who sends me a Excel bid form that is protected and they want us to enter our price, manufacturer name, catalog number and delivery ...

    Saul.D | Excel | Latest reply: ac3mark Jun 11, 2015
    1 reply
  • Excel Formula to add DAY in cell from DATE Closed

    Hello, Is it possible to have a formula that automatically adds the day to a cell if a date is entered into another cell. For example, Column A...

    Laing | Excel | Latest reply: TrowaD Jun 11, 2015
    1 reply
  • unlocking of the locked file Closed

    Hello, i have a password folder but i do not need that folder to be protected anymore. what do i do to permanently deactivate such password? Co...

    MIGAS | Word | Latest reply: Ambucias Jun 11, 2015
    1 reply
  • If cell A1 has text then cell B2 has today's Date Solved/Closed

    Hello, I'm trying to find a formula that writes, If Cell A1 has text or any value, then B2 should show today's date and time. Can someone help m...

    Sasha | Excel | Latest reply: ac3mark Jun 10, 2015
    1 reply
  • Excel date format change Closed

    Hello, I have use MSoffice-2010,in a excel sheet there is some data with 72 rows.Main issue is when I sent the excel sheet to my friend he got the ...

    George | Excel | Latest reply: kieferschild Jun 10, 2015
    1 reply
  • Programme to automatically populate XL Spread Sheet Closed

    Hi All, Im doing audit for diving equipment. All data will be compiled in 1 excel file with several sheets. 1 - Record of Inspections - NC 2...

    atiqjuwaidi | Excel | Latest reply: atiqjuwaidi Jun 9, 2015
    0 replies
  • Problem with arrow "up" key in excel Closed

    Hello, I am having difficulties when navigating in my spreadsheet. All works fine except the arrow up key. When pressed it moves to the cell above...

    Remko | Excel | Latest reply: Remko Jun 9, 2015
    0 replies
  • Some change in vba code Closed

    Hello, Here is my code that change column color base on another cell color, i want a that change row cell color with Yes value base on another cell c...

    FaizanRoshan | Excel | Latest reply: FaizanRoshan Jun 9, 2015
    0 replies
  • Merge Cells that have to same data in Excel! Closed

    Hello all, I'm new to the 'Corporate Level' of Excel, so I could really use some help. Here's my situation. I was given 3 spreadsheets. The first ...

    MatthewMarklar | Excel | Latest reply: MatthewMarklar Jun 9, 2015
    0 replies
  • Comparing two excel sheets Closed

    Hello, i have 2 excel sheets, each with 2 columns name and email. the scenario is i want to compare both sheets and display those which has the same...

    ExcelNewbie192 | Excel | Latest reply: TrowaD Jun 9, 2015
    1 reply
  • Conditional Formatting in multiple column Closed

    Hello, I have done conditional formatting in column D (if duplicate value found then cell color will be red), now I want the respective row cell t...

    Anand | Excel | Latest reply: Anand Jun 9, 2015
    0 replies
  • Excel - Repeat rows a specified number of times Solved/Closed

    Hello, I'm aware of the post here https://ccm.net/apps-sites/software/1603-how-to-repeat-rows-a-specified-number-of-times-on-excel/ But I wo...

    Riteon | Excel | Latest reply: Riteon Jun 9, 2015
    1 reply
  • how to repeat rows by x number of times Solved/Closed

    Hi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in that row ...

    stressedout | Excel | Latest reply: Riteon Jun 9, 2015
    7 replies
  • Macros to copy multiple data from 1 sheet and saving it on anotr Closed

    Hello, I would like to enter multiple data on sheet 1 and copy and update the data on sheet 2 by running the macros. This should work for foll...

    Gopz | Excel | Latest reply: Gopz Jun 8, 2015
    0 replies
  • Highlight Jobs that are due. Closed

    Not even sure where to begin on this one and not sure it's possible either but thought it's worth a try. I have a document to record date's when jobs ...

    MJones447 | Excel | Latest reply: vcoolio Jun 7, 2015
    1 reply
  • computer master's password Closed

    Hello, since i m new to these things, so can anyone explain to me what does computer master's password means? Configuration: Windows XP / Chrom...

    kapee | Word | Latest reply: Ambucias Jun 7, 2015
    1 reply
  • How to Repair Large Outlook 2007 PST on Windows 7 Solved/Closed

    Hello, User running Windows 7, with Outlook 2007, 20 GB PST. User has two email account, 1 may be an IMAP, 1 may be POP, or both can be POP (I'l...

    coxsilvester | Outlook | Latest reply: paulmay247 Jun 7, 2015
    2 replies
  • add data from a template exel file into a master excel database Closed

    Hi, I Have basically a template which I use for export, as shown in example below My template columns A,B,C layout are like: A ...

    trynix | Excel | Latest reply: trynix Jun 6, 2015
    0 replies
  • excel 2003 question. on conditional formatting using VBA Closed

    Hello, i have been trying to figure out how to make my code stop bugging out on me. any and all help will be greatly appreciated. Option Compare ...

    throesch | Excel | Latest reply: throesch Jun 6, 2015
    1 reply
  • Excel "IF" formula Help! Closed

    Hello, Here is a Microsoft excel question. I have a column with words in it. The words will change depending on what the row next to it say. The col...

    khanster | Excel | Latest reply: khanster Jun 5, 2015
    0 replies
  • ROUNDING FUNCTION Solved/Closed

    Hello, Good day!! For the Excel rounding function normally is 4 down 5 up is it possible that rounding the digit as below request? 115.21...

    Winndixie | Excel | Latest reply: Winndixie Jun 5, 2015
    2 replies
  • How to stop Excel error message for too many data points? Closed

    Hello, When trying to create a chart with information trending over a long period of time I keep receiving this error message: "The maximum nu...

    RyanK | Excel | Latest reply: RyanK Jun 5, 2015
    0 replies
  • Conditional Formatting Closed

    I have a document in excel where I want to change the colour of a number of cells based on information in one. So I'm guessing a formula will be neede...

    MJones447 | Excel | Latest reply: MaxStart Jun 5, 2015
    1 reply
  • . Closed

    Hello, I have data like this.. YTQ5478568 WBH548567 XML8457693 I need like this Y T Q 5 4 7 8 5 6 8 W B H 5 4 8 5 6 7 X M L 8 4 5 7 6 9...

    MohammedTasleem | Excel | Latest reply: MohammedTasleem Jun 5, 2015
    0 replies
  • VBA to refresh all pivot tables Solved/Closed

    Hello, One of my worksheets has about 40 pivot tables. I know that there is a pivot table option to "refresh tables when opening file". But my raw ...

    Fwong | Excel | Latest reply: Fwong Jun 5, 2015
    1 reply
  • Massive Copy/Paste..can it be done? Closed

    I am working between to separate excel files. Basically, I'm hoping there is a way to copy and paste OR ever better a way to auto insert fields to ano...

    BRose7 | Excel | Latest reply: BRose7 Jun 4, 2015
    0 replies
  • Macro to add/remove rows based on highest # in group of cells Solved/Closed

    I am looking for a macro that will look at a predefined group of cells (say A1-A5) and create as many rows based off the highest one on another sheet....

    Joermccartney | Excel | Latest reply: TrowaD Jun 4, 2015
    1 reply
  • Insert row data on Sheet2 based on sheet1 cell value(text) Closed

    Hello, i have two sheets i.e., sheet1,sheet2 in Sheet1 row fields like A B C D E in that D field value like RC based RC value insert whole RC ...

    anilkarthik | Excel | Latest reply: TrowaD Jun 4, 2015
    5 replies
  • Search Multiple Sheets of a Workbook & Copy the Results Closed

    Hey, So I have a problem and I can't seem to find a similar question asked before. I have an excel workbook with 10 sheets. Each sheet is rega...

    mjk3001 | Excel | Latest reply: mjk3001 Jun 4, 2015
    0 replies
  • Excel - a Macro for copying data from different sheets Closed

    Hi, I love your posting. I was just wondering if I could exclude some tabs from being copied. I am pulling information from pivot tables so I hav...

    nnavarro | Excel | Latest reply: nnavarro Jun 4, 2015
    0 replies
  • If text encountered, add rows Closed

    Hello, I would appreciate any help on a worksheet of thousands of lines of data I get and must format every week. Whenever the text "-C0" is enco...

    Amanda | Excel | Latest reply: Amanda Jun 3, 2015
    0 replies
  • How to add a number every two weeks in Excel? Closed

    Hello, I'm trying to come up with a formula that would automatically add a number in a cell every two weeks. Any help is appreciated. Configu...

    dnr | Excel | Latest reply: dnr Jun 3, 2015
    0 replies
  • How to match 2 lists to get the unique entries Closed

    I have two spreadsheets, one containing a complete list of titles in a database and the other containing a subset of that list. I want to find the en...

    bettyindc | Excel | Latest reply: xpcman Jun 3, 2015
    1 reply
  • Calculate Formula based on values for two dates Closed

    Hello, I'd like some help with calculating a formula that uses values corresponding to specific dates. I have a list of daily dates and a value ...

    srsubs | Excel | Latest reply: Mazzaropi Jun 3, 2015
    3 replies
  • Excel date format Closed

    Hello, I take care of a list in excel 2013, in which a group of people continuously feeds data (a sort of archive). One column expects dates in a ce...

    Claudia | Excel | Latest reply: Claudia Jun 3, 2015
    0 replies
  • Corrupted Excel and Word docs Closed

    Hello, I recently bought a new laptop pre-loaded with W8.1. I downloaded MS Office 2007 Home and Student (it was a 3 licence package and this was the ...

    BryantAlt | Excel | Latest reply: BryantAlt Jun 3, 2015
    0 replies
  • Data from one file into running totals in another? Closed

    Hi folks, I have two spreadsheet files. Both contain figures. One is updated daily and cleared daily. One is updated daily and maintained for...

    Kilm | Excel | Latest reply: Kilm Jun 3, 2015
    0 replies
  • How to pull text from column B if cell matches data in column A Closed

    I want my form to know which employee is assigned to the county listed on the form. Basically, if cell F5 says Multnomah, I want the formula to look a...

    Data Rookie | Excel | Latest reply: Data Rookie Jun 2, 2015
    0 replies
  • Conditional Formatting Help Closed

    Hello, I have a spreadsheet which we use for tracking all outgoing shipments. I have the expected delivery date in one column, and the actual deli...

    Lauren | Excel | Latest reply: TrowaD Jun 2, 2015
    1 reply
  • Combining rows Closed

    Hello, My situation is similar to a question that was asked but not exactly the same. This is how my spreadsheet looks now: A 1 1 0 0 1 1 A 0...

    Matt406 | Excel | Latest reply: TrowaD Jun 2, 2015
    1 reply
  • Conditional formatting based on range ofcells in different sheet Closed

    Hi, I'm trying to make the conditional formatting based on as follows: cell in sheet 2 is getting red if anywhere in sheets 1,2 and 3 could be f...

    iveta96 | Excel | Latest reply: TrowaD Jun 1, 2015
    1 reply
  • Replacing a value using lookup table Closed

    Hello, I am looking for help on writing a macro that will perform replacement that will replace the values from A1 to the end of the first row on Shee...

    leewonhee7 | Excel | Latest reply: TrowaD Jun 1, 2015
    1 reply
  • conditional graphbar colors Closed

    Hello, I am trying to create a chart where column B depicts numbers for 2014 and Column c for 2015. 2014 is a line graph and 2015 is a bar graph, ...

    Raj | Excel | Latest reply: Raj Jun 1, 2015
    0 replies
  • Copy specific cells to separate worksheets upon 2 conditions Solved/Closed

    Hello everyone, vcoolio has kindly written me a script to copy and paste specific cells from Sheet1 to Sheet2 if ONE condition is met (ie "Yes" is...

    Fwong | Excel | Latest reply: vcoolio Jun 1, 2015
    3 replies
  • Check if cells are blank or zero help please Closed

    I have a spreadsheet where columns A and B will either contain numbers or be blank. I need to add a formula into column C (for example cell C2 which ...

    angieanguk | Excel | Latest reply: angieanguk Jun 1, 2015
    2 replies
  • Corrupt PowerPoint File Recovery Closed

    Are there any tools available to recover a corrupted PowerPoint file? My wife had spent about a week putting one together and (luckily) when done pres...

    JeffryCarp | PowerPoint | Latest reply: Alice_Phoebe Jun 1, 2015
    2 replies
  • Help creating an automated sheet Closed

    I need to create an excel sheet that will automatically search information on a "raw data" sheet and give results on a different sheet "sheet 1". I w...

    kc_74074 | Excel | Latest reply: kc_74074 May 31, 2015
    2 replies
  • Oulook pop3 Closed

    For over a week now I have not been able to down mail from Yahoo to Outlook. I get the following error, Task 'deleted by moderator - Receiving' rep...

    peterwelk | Outlook | Latest reply: peterwelk May 30, 2015
    0 replies
  • How to Recover My Email Closed

    Hello, How to Reinstall my outlook & how to Recover my Emails Please Urgent Rply Thanks Configuration: Windows XP / Firefox 38.0

    Faizan | Outlook | Latest reply: Ambucias May 30, 2015
    1 reply