Excel Forum - solved topics

Ask a question
Results 1351 - 1400 of about 1,720
  • Solved
  • Adding new data sets to multiple worksheets Solved/Closed

    Hello, I am creating a spreadsheet database for data to determine the best vendor to use. I have multiple vendors on different worksheets and the...

    Aaron | Latest reply: Aaron Mar 4, 2011
    2 replies
  • Macro To Copy Rows From One Worksheet To Anot Solved/Closed

    Hi , I'd like to know if there's a macro that can be run to check one worksheet. In this worksheet there is a column where the value should be "true"...

    Gowind | Latest reply: Gowind Mar 4, 2011
    9 replies
  • One Button To Execute Two Macros Solved/Closed

    Hello, I got one macro in Sheet1 and another macro in sheet2 under the same workbook.I want to assign a button in sheet1 so it can execute both the ...

    azmiismail | Latest reply: azmiismail Mar 3, 2011
    4 replies
  • Excel formula A+B=C with the following except Solved/Closed

    Hello, I really could use some help please. I am working on an 2010 excel spreadsheet. Would anyone know if there is a formula to do the following....

    Scott | Latest reply: Scott Mar 3, 2011
    2 replies
  • Use Excel VBA to create an e-mail w reminder Solved/Closed

    Hello, I create a file in Excel that does some calculations based on a small database and some user input. I then added a button to open an e-mail...

    BrunoD | Latest reply: Bruno Mar 2, 2011
    2 replies
  • Macro to highlight a row if cells match value Solved/Closed

    Hello, I sorry but I am very new to macros and trying to create one in Office 2003. I need to bold a row if for example column E is greater than a...

    sgriffis | Latest reply: sgriffis Feb 22, 2011
    2 replies
  • Count if macro on multiple criteria Solved/Closed

    Hello, Could someone please help me out with a count-if macro on multiple criteria. I have attached a sample file in the below link http://ww1....

    waseem | Latest reply: Wasem Feb 22, 2011
    4 replies
  • help with excel Solved/Closed

    Hello, i have two speadsheets. the first sheet contains a total column EX: in C4 =SUM(E4+G4+I4+K4+M4) Value of C4 = (339816) on the ...

    markzasz | Latest reply: RWomanizer Feb 21, 2011
    1 reply
  • macro not saving file in excel format Solved/Closed

    Hello, I have a coding like this: filename = Range("B3").Value Workbooks.Add Set newwb = ActiveWorkbook ChDir "D:\P3\Jan-11\B2B" ...

    RWomanizer | Latest reply: RWomanizer Feb 21, 2011
    4 replies
  • If then excel entry Solved/Closed

    Hello, In excel, I have a row where hours worked is entered. Directly underneath that row is another row where allotted break time needs to be ...

    Jen | Latest reply: Jen Feb 18, 2011
    2 replies
  • Conditional formatting in excel 2007 Solved/Closed

    Hello, I am trying to apply conditional formatting to a calculated cell (For ex A). Criteria: If Cell A value = Cell B or " - " then ...

    NS | Latest reply: Toast Feb 16, 2011
    17 replies
  • Select and copy only nonblank cells Solved/Closed

    Hello, many thanks in advance for any responses I get here, I have toiled in vain on this for hours now. At first it was acceptable to simply c...

    shootingfish | Latest reply: Ambucias Feb 15, 2011
    5 replies
  • Date Diff in excel 2010 Solved/Closed

    Hello, So I want to figure out how to write a formula for a difference in days on a "visit log". I want excel to look in multiple cells. (basicall...

    Mark | Latest reply: Mark Feb 14, 2011
    2 replies
  • How to name excel sheets on values in columns Solved/Closed

    Hello, I have a list of people names in a column in one sheet with additional cells in each row for adding data. I want to create separate excel s...

    eskagsms | Latest reply: eskagsms Feb 14, 2011
    8 replies
  • How to insert rows dynamically with in group Solved/Closed

    Hi, currently I am creating a macro, in to that I have data for row and columns. now I want to count the product in column A, with formula =counta (...

    alveeru | Latest reply: rizvisa1 Feb 9, 2011
    1 reply
  • Macro to class interval Solved/Closed

    Hello, I have a workbook of employee data and at dth column i have ages of employee. in eth column i have to define age interval like. 18-25...

    rahul | Latest reply: TrowaD Feb 7, 2011
    1 reply
  • Excel less than but greater than Solved/Closed

    Hello, How would I get into L2 if J2=>10 then "lates", if J2=

    Welshjessy | Latest reply: Welshjessy Feb 3, 2011
    2 replies
  • Excel if function Solved/Closed

    Hello, Could someone please help me with the following problem. I want to know how to do a if function in vba to search for a value (output), a...

    PM | Latest reply: PM Jan 20, 2011
    4 replies
  • ms excel Solved/Closed

    Hello, I want to use ms excel but i am not getting any option of ms excel in my computer how can i use ms excel when i don't have it.......? ...

    sania | Latest reply: jack4rall Jan 10, 2011
    1 reply
  • Button to color sertain numbers (Excel) Solved/Closed

    Hello, Im looking for a way to make a button color all numers equal to the the number on the button.. as an eksample, lets say i have a row of...

    Alstrom | Latest reply: Alstrom Jan 7, 2011
    2 replies
  • import excel data into mysql database Solved/Closed

    Hello, This is Nischala .Can any one suggest me wheather we can import excel sheet data into mysql database using .net application(vb.net or asp....

    nischala | Latest reply: Er.mayank khandelwal Jan 5, 2011
    4 replies
  • IF-Then statement to copy rows Solved/Closed

    Hello, I am wondering if there is a way to copy a specific row from one worksheet to another in the same workbook based on an IF-Then statement. ...

    froggy6703 | Latest reply: froggy6703 Jan 4, 2011
    5 replies
  • Excel Macro Assistance Solved/Closed

    Hello, I have a macro running a process of performing a couple of formulas in a workbook that uses VLookup. Every week I have to re-edit the r...

    dhunter | Latest reply: Helper Jan 2, 2011
    8 replies
  • Converting date in VBA Excel Solved/Closed

    Hello, I have a spreadsheet that has: Column A: Year Column B: Month Column C: Day Is there a way to convert these 3 columns into the actu...

    Roger | Latest reply: Roger Dec 28, 2010
    4 replies
  • MS Excel 2007 IF Function problems.? Solved/Closed

    Hello, I need immediate assistance. basically i am trying to use the IF function to display less than 18 "no", more than 18 "yes". but if 23.5/...

    Twisted | Latest reply: Twisted Dec 23, 2010
    3 replies
  • Excel Macro Copy data to next sheet using < Solved/Closed

    Hello, I'm looking some time now around this forum and ditn't find what i'm looking for. So i'm just gonna ask it here and hopefully someof your s...

    Gino | Latest reply: TrowaD Dec 21, 2010
    1 reply
  • Macro to fill down in a range Solved/Closed

    Hello, Thanks to all who provide help on this site. I'm new to writing macros so hopefully you might be able to steer me in the right direction wi...

    lee | Latest reply: lee Dec 21, 2010
    2 replies
  • excel copy and paste Solved/Closed

    Hello, I have been given a list of 200 codes but they are in the wrong order. for example it goes 12378945610. so i want to swap the 456 and the 789...

    GeorgeAWSOME | Latest reply: RayH Dec 15, 2010
    5 replies
  • Excel - Check rows for data, copy to new Solved/Closed

    Heya folks! I've been reading the answers to similar questions and I plan to try and patch something together, but I thought I'd put a (more) specifi...

    Fuzzy | Latest reply: Wayne Dec 15, 2010
    4 replies
  • Lookup or find in excel help Solved/Closed

    Hello, I have 2 data sheets sheet one contains my Master list of items by number Row 1 Column 1: 453658 Row 2 Column 1: 839565 Etc my secon...

    Paul | Latest reply: Paul Dec 14, 2010
    2 replies
  • MS Excel, Stripping Out Char(10) Data Solved/Closed

    Hello, I working in Excel with VBA and have 5 or 6 rows of data located within 1 cell. The user has decided to use Alt-Enter whilst entering the da...

    Kieron | Latest reply: Gene Dec 13, 2010
    8 replies
  • can ping but can't use browser in normal mode Solved/Closed

    Hello, I also have the problem where I was unable to connect to the internet via any browser, but I can ping my router. I noticed that turning off...

    LL | Latest reply: Brain Drained ;-) Dec 9, 2010
    1 reply
  • Excel work sheet how to i open Solved/Closed

    Hello, When i am trying to open an exel sheet saved from windows 7 platforms, i am unable to open in windows xp plantform. the file that i was co...

    satishkumar | Latest reply: RayH Dec 9, 2010
    2 replies
  • Copy rows n times and then fill a series Solved/Closed

    Hello, This is variation of a question that has been answered previously. Does anybody know how I can repeat rows in a spreadsheet by n number of...

    Gaoyou60 | Latest reply: Gaoyou60 Dec 8, 2010
    2 replies
  • Pie chart in excel Solved/Closed

    hi there im trying to make a pie chart in excel but i don't really know where to start...can someone help me thanx!

    mrslash | Latest reply: yoman Dec 1, 2010
    4 replies
  • How to interchange the columns in notepad Solved/Closed

    Hello, I have data in three columns. I want to inter change the values of first two columns without changing the third one in notepad or in word p...

    dhrupad | Latest reply: dhrupad Dec 1, 2010
    2 replies
  • Excel Sum Greater than but Less Than Solved/Closed

    Hello, I am trying to get a cell to show the answer if - The date in B5 minus the date in B10 is less than 60 but more than 30 then F10 should sh...

    Ian | Latest reply: Alli Nov 29, 2010
    4 replies
  • Comditional Formatting Relative Recording VBA Solved/Closed

    Hello, I want to compare a cell to its adjacent cell on the left. If the value of the selected cell is higher I'd like to colour it green, if it's...

    bernei | Latest reply: bernei Nov 26, 2010
    4 replies
  • tecno free browsing Solved/Closed

    Hello, pls help to find free browsing configuration setting for my tecno T570 dis is my phone no 07036713275 I will compeciate u with something ...

    oladotun | Latest reply: Ambucias Nov 25, 2010
    7 replies
  • no address bar on my browser Solved/Closed

    Hello, i dont know how to get my toolbar back up on my screen can you help me its a windows xp

    d | Latest reply: canadianpen Nov 22, 2010
    5 replies
  • copy data one excel sheet to other sheet Solved/Closed

    Hello, any one help meee please im running that macro and getting data from one sheet to other one issue i have when i run that macro the window ...

    farrukh | Latest reply: Fawad Nov 22, 2010
    3 replies
  • Simple Macro Error Help Solved/Closed

    Hello, I am using Excel 2007 on Windows XP I am trying to write my first macro that will simply place the following formula into a cell. The ...

    Mike | Latest reply: RayH Nov 16, 2010
    1 reply
  • Deleteing Rows in excel Solved/Closed

    Hello, I work with a lot of files every day and the number of data in column A is different from the rest of the column. The number of data ar...

    Cindy | Latest reply: Cindy Nov 16, 2010
    2 replies
  • Excel comparison of partial or wild card data Solved/Closed

    Hello, I have two columns in Excel that I want to compare. The data in work sheet 1, column A has values that are tabbed. This data has the adjac...

    Trish | Latest reply: Trish Nov 15, 2010
    2 replies
  • Sheet-1 + Sheet-2 Solved/Closed

    Hello, i have a problem plz solve it and tell me solution i want to count some cells which are Sheet-1 and in Sheet-2. Example: (Sheet-1) A1+A...

    Naveed | Latest reply: pejhip Nov 15, 2010
    5 replies
  • Counting in Excel Solved/Closed

    Hello, In the U column shows "Good" and "Bad" answer that resulted from a formual that I used. How can I count the the toal number of Good a...

    Sam | Latest reply: Sam Nov 15, 2010
    1 reply
  • Excel help with what if Solved/Closed

    Hello, I have all the states in column A and I need to result to display in column B. I need Column B to show "Yes" if column A has: MT, ID, ...

    Tammy | Latest reply: Tammy Nov 15, 2010
    1 reply
  • Conditional Formatting (more than 3) in Excel Solved/Closed

    Hello, i am trying to apply more than three options to excel that changes the background colour of the cell. my range is R7:R1000 i need a VBA ...

    allanabanana | Latest reply: Waynef Nov 14, 2010
    37 replies
  • Excel Question Solved/Closed

    Hello, I have one worksheet with with all of my emails (both good and bad) D2:D3843 and another worksheet A2:A1061 with all good emails and I need...

    Jason | Latest reply: Gio Nov 4, 2010
    3 replies
  • Class Result In Excel Solved/Closed

    Hello, I have worksheet of class result.In column A there are names of students. In column B i have marks. I want a formula which tell me the name...

    mbbs | Latest reply: . Nov 3, 2010
    2 replies