Office Software Forum - solved topics

Ask a question
Search
Close
Results 1001 - 1050 of about 2,640
  • Solved
  • 2 macros in one sheet targeting same cells Solved/Closed

    This is probably a really 'newbie' question but in all honesty, I'm new to macros and need some assistance. I have a macro written to automatically...

    chester4207 | Excel | Latest reply: chester4207 Nov 28, 2014
    2 replies
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • IF function formula based on three possible values from adjacent Solved/Closed

    Good morning all, Excel 2007 - I need a formula based on the three possible values from an adjacent cell. 1st value: : if F5 is a date, a simpl...

    TanyaRT | Excel | Latest reply: TanyaRT Nov 17, 2014
    2 replies
  • Conditional Formatting - highlight overdue dates Solved/Closed

    I am a beginner with conditional formatting and researching the net for an answer has left me more confused than when I began! I am working with Ex...

    TanyaRT | Excel | Latest reply: TanyaRT Nov 16, 2014
    2 replies
  • Auto Filter depending on Cell Value Solved/Closed

    Hello, I have data in a table, lets say the table is (A7:M200) and the Headings in this table is (A7:M7). Column 1 (A8:A200) is the accounts numbe...

    Issa | Excel | Latest reply: rizvisa1 Nov 15, 2014
    10 replies
  • How to find out the data in six month record Solved/Closed

    Hello, I have six month excel attendance sheet. which formula can i use to know in which month which of the employee has left and who has joined?...

    subodh | Excel | Latest reply: subodh Nov 15, 2014
    2 replies
  • Corrupt Pptx files. Need to repair them. Please help! Solved/Closed

    Hey guys, there is big mess over here. Here I quote: I made some presentation files for promoting our new business. I showed them to my boss. She wa...

    BallSteven2 | PowerPoint | Latest reply: RolfLinds Nov 14, 2014
    1 reply
  • Nested if then Solved/Closed

    Hello, I would like to have the contents of b1 displayed in m2 if t2=1, the contents of b2 displayed in m2 if t2=2, the contents of c1 displayed in...

    chiflado | Excel | Latest reply: vcoolio Nov 12, 2014
    7 replies
  • Lost password to PST file Solved/Closed

    Hi, I had a .pst file with a password set on MS Outlook 2010. Now I can't remember what the password is. How can I get back my emails? Thanks.

    Lakatos | Outlook | Latest reply: marian41v Nov 10, 2014
    1 reply
  • How to format cells based on the text in another cell Solved/Closed

    Help me! I'm trying to conditionally format multiple cells based on different texts entered in another. For example: I have selected certain cells to...

    Tillda | Excel | Latest reply: Tillda Oct 31, 2014
    2 replies
  • Insert/Remove photos depending up on ref. cell value changing Solved/Closed

    Hello, I designed a Student Profile in excel using LOOKUP function. In this profile, near the Student Name title I created one drop down list of stu...

    jinoob | Excel | Latest reply: KALEEM Oct 29, 2014
    9 replies
  • Excel VBA copy and paste loop with logic condition Solved/Closed

    Hi, I am new to VBA and would appreciate some help with a problem I am trying to solve. I would like a macro that is able to copy information f...

    Yogibearv | Excel | Latest reply: Yogibearv Oct 28, 2014
    6 replies
  • Excel workbook with two sheets Solved/Closed

    Hi, i have an Excel workbook with two sheets and when i enter data in sheet #1 it automatically goes to sheet # 2. How on earth can i stop this fro...

    ibraun | Excel | Latest reply: ibraun Oct 28, 2014
    2 replies
  • Auto Transfer of a filtered item to a different sheet. Solved/Closed

    Hello everyone, I would like to ask for some help regarding some EXEL problems. Example: I want some data from sheet1 E columns to transfer to...

    Mymyname | Excel | Latest reply: Mymyname Oct 23, 2014
    6 replies
  • Can't send email in Outlook 7. Solved/Closed

    I have Outlook7. I can receive email with no problem, however, I can't send email. Anyone know a sure fix to this? I use pop and smtp. Thanks.

    alphonzo05 | Office Software | Latest reply: Ambucias Oct 18, 2014
    7 replies
  • Excel 2007 Using vlookup function in VBA Solved/Closed

    I have a list of name and employee number in sheet 1 in column a and b.. Then what i want is to by simply typing the employee number in sheet 2 column...

    gsyrill | Excel | Latest reply: gsyrill Oct 15, 2014
    2 replies
  • Text String count within a Cell Solved/Closed

    Hello, I have number of records (see below) and want to know if I can use a function to count the number of records that contain a specific te...

  • format a cell with a comment based on a comment in another cell Solved/Closed

    Hi, I need to format a cell with a comment based on a comment in another cell. So cell A1 might ask a question like is the window clean? B2 will...

    stevo5355 | Excel | Latest reply: stevo Oct 12, 2014
    2 replies
  • Macro to copy paste without having all the source books opened Solved/Closed

    Hello Kioskea users. I hope you're all doing great. Today I have a concern that I'm not able to figure out. Any help will be really appreciated. I...

    fabianchpe | Excel | Latest reply: fabianchpe Oct 12, 2014
    2 replies
  • how to convert Date to word in excel Solved/Closed

    how to convert Date to word in excel e.g. 05/01/1992 to change Five January, Ninteen Ninty two

    maheshprajap... | Excel | Latest reply: carminabigue Oct 6, 2014
    1 reply
  • Automatically transfer data from one sheet to another Solved/Closed

    Hello, I have a workbook with 2 worksheets. Sheet 1 has about 400 line items. I would like to be able to select certain line items on Sheet 1 and ...

    sunny49er | Excel | Latest reply: TrowaD Oct 6, 2014
    22 replies
  • Calculate Total Total Hours Per Client Solved/Closed

    Hi, I have a spreadsheet in which employyees time are entered on a daily basis along with the client they worked for. The spreadsheet calculates ...

    ad1959 | Excel | Latest reply: ad1959 Oct 3, 2014
    5 replies
  • How to count date cells for monday of this week Solved/Closed

    Hello, I would like to count the number of cells with date = to MONDAY of this current week and also MONDAY of the following week within a defined...

    doublewitt | Excel | Latest reply: doublewitt Sep 29, 2014
    4 replies
  • Auto generate the seller sales report Solved/Closed

    Hi! I create a sales report and I set up total 6 worksheet Worksheet 1 I named it Price list ... is a Data for my sales report. and I set a co...

    Winndixie | Excel | Latest reply: Winndixie Sep 26, 2014
    8 replies
  • Formula to increment date by seven days. Solved/Closed

    Hello Everyone, In a work sheet, I have an invoice date (say column A) and a due date (say column H) with the due date being seven days after the ...

    vcoolio | Excel | Latest reply: vcoolio Sep 26, 2014
    2 replies
  • Automatically transfering rows from one sheet to another Solved/Closed

    Hi, I was wondering if anyone could help. I've created a spreadsheet to track all contracts complied within our department. I have a "Contract Sta...

    madi9749 | Excel | Latest reply: madi9749 Sep 26, 2014
    4 replies
  • IF function with Date addition Solved/Closed

    Hello, I'm having trouble finding an answer as to how I can add 5 more days in my condition. I have 4 columns: one for an Order date (A2)...

    garycrant | Excel | Latest reply: garycrant Sep 25, 2014
    4 replies
  • Dealing with 'Today()' formula in Excel VBA code Solved/Closed

    Hi Everyone, I have this VBA code in a Excel sheet (specifically in the Module) which does the following: - finds the empty cell in range "B:B" -...

    masinyaka | Excel | Latest reply: masinyaka Sep 25, 2014
    4 replies
  • Excel > Macro for Defined Range Dates Solved/Closed

    Hello, I've a question that I have starting date in Column "E3" Sheet 1 and ending date in Column "F3" Sheet 1. I want a macro that insert dates i...

    Game Start Now | Excel | Latest reply: Game Start Now Sep 23, 2014
    13 replies
  • How to copy data based on criteria met Solved/Closed

    Help! I am totally stuck and this is probably a very simple fix. I have two sheets "Priority Accounts" and "ACN Dashboard". I need to move data i...

    katcrisjul | Excel | Latest reply: TrowaD Sep 22, 2014
    12 replies
  • Having problems with Office Word 2010 can someone help? Solved/Closed

    Hello, I had to re-download Microsoft Office Home and Student 2010. Now whenever I save a Word document I winds up saving it as a WordPad document....

    Newbie56 | Word | Latest reply: Newbie56 Sep 19, 2014
    2 replies
  • Excel 2010 VBA Date Formula Solved/Closed

    Hi, I am trying to get a formula setup so when you click on a cell in excel it automatically enters the date. I am using the formula below which wo...

    Oz_Dex | Excel | Latest reply: dave Sep 17, 2014
    3 replies
  • Copy values in row to columns in spaces Solved/Closed

    Hello, I am a beginner in VBA, and would mcuh appreciate some guidance on transposing data in a row to a column via VBA. My row data is as foll...

    LearnVBA | Excel | Latest reply: LearnVBA Sep 16, 2014
    4 replies
  • Conditional Formatting Solved/Closed

    Suppose I have date in Column A (from A1 to A100) and in Column B (from B1 to B100), Both data are numerical. If the data in Column A is greater than...

    tareqnaser95 | Excel | Latest reply: Osama_bb11 Sep 10, 2014
    2 replies
  • Specific data from one worbook to another (Excel 2010). Solved/Closed

    Hello there, I have two workbooks, one is an accounting spread sheet (named Cash Book) and the other has an Invoice Template (sheet 1) and Invoice...

    vcoolio | Excel | Latest reply: vcoolio Sep 9, 2014
    29 replies
  • excel 2007 custom filter problem Solved/Closed

    Hello, I have been using Excel 2003 to sort phone numbers easily, using the custom filter and 'begins with' for example on numbers starting with 123. ...

    h4 | Excel | Latest reply: mark Sep 8, 2014
    6 replies
  • Microsoft Office product key Solved/Closed

    what is the product key of the app i downloaded?

    erinkrizel | Office Software | Latest reply: Ambucias Sep 4, 2014
    6 replies
  • time calculation Solved/Closed

    Hello, dear all please I need a help for formula to calculate the duration ( hours ) between two dates for example : A1 ---> 1-8-2014 1...

    Osama_bb11 | Excel | Latest reply: Osama_bb11 Sep 3, 2014
    2 replies
  • formula that i can get a total for D7, if D7= D4 + (C6*D7) Solved/Closed

    $1,613.00 (Cell D4) (C6) Hours ___ $175.00 (D6) TOTAL (D7) Can any one tell me a formula that i can get a total for D7, if D7= D4 + (C...

    dmadden | Excel | Latest reply: dmadden Aug 29, 2014
    2 replies
  • If -Then formula needed please... before I head to the roof Solved/Closed

    Using Excel 2007, I need a formula to do the following: if the date shown in a cell is 1/31/14, display 'monthly activity - january, or if the date...

    hotpeppermom | Excel | Latest reply: hotpeppermom Aug 22, 2014
    4 replies
  • Extraction of Excel data by using an Excel column parameter Solved/Closed

    Hi, I have a problem in extracting information from an Excel Sheet 1 (entire database), by using an Excel column parameter (Model No) in Sheet 2. S...

    strikewind | Excel | Latest reply: strikewind Aug 21, 2014
    5 replies
  • Excel Golf Skins Sheet Solved/Closed

    I need a micro that will highlight the cell with the lowest unique value in each individual column. It would not highlight anything if there were m...

    agw2010 | Excel | Latest reply: agw2010 Aug 18, 2014
    2 replies