Excel Forum

Ask a question
Search
Close
Results 5051 - 5100 of about 9,850
  • Excel 2010-VB Macro formula into many spreadsheets Solved/Closed

    Hello Everyone, I am new in VB programming and I am trying to write a macro in Excel. Basically, I have written a formula in Excel which enable me ...

    AnFey | Latest reply: AnFey Mar 3, 2014
    4 replies
  • automate the sheet in order to calculate costs Closed

    I have an order sheet and 3 reference sheets. I would like to automate the sheet in order to calculate costs and for selling different types of produ...

    Soj17 | Latest reply: Mazzaropi Mar 1, 2014
    1 reply
  • IF function using dates Solved/Closed

    Hi I am trying to write an IF function for an escalation calculation and need some help please. What I want to achieve is to have a date filled ...

    Escalation | Latest reply: Escalation Feb 28, 2014
    2 replies
  • IF function using Dates Closed

    Hi I am trying to write an IF function for an escalation calculation. What I want is to have a date filled into cell B13 (22 February 2014). The I...

    Escalation | Latest reply: Ambucias Feb 28, 2014
    1 reply
  • Data comparison Closed

    I have a database compiled in my office of current students in a college program for a particular semester AND a database from administration with the...

    Foresterdon | Latest reply: Ambucias Feb 27, 2014
    2 replies
  • Macro Syntax Error Closed

    HELLO THERE NEED HELP TO RESOLVE AND MAKE THE BELOW CODE WORK IN EXCEL(MACRO) ActiveCell.FormulaR1C1 = _ "=IF(RC[-2]=""10X"",""Acquisition on do...

    luqman | Latest reply: ac3mark Feb 26, 2014
    1 reply
  • Change the column Closed

    Hello, I have to do the same thing as you but instead of using the column B, I have to use the column A. I tried to change your code but I didn't...

    Syline | Latest reply: ac3mark Feb 26, 2014
    3 replies
  • Excel cmd button to transfer data from source to another. Closed

    Hello, Can someone help me with my problem. Is there a way to create button to transfer data from source sheets to any other sheets in the same wo...

    MC JONES | Latest reply: ac3mark Feb 26, 2014
    1 reply
  • how do i change the result of a formula to normal text or values Solved/Closed

    Hello , i have a formula which calculates my working hours for each day " =C9+(B9>C9)-B9 " ... when i try to sum all the hours resulted from that for...

    kelnasawa | Latest reply: kelnasawa Feb 26, 2014
    8 replies
  • IF Formulas with Dates Closed

    Hi all, I have a large spreadsheet that contains revenue information tied to sales deals. Column A contains the expected deal closing date and c...

    orodriguezjr | Latest reply: orodriguezjr Feb 25, 2014
    2 replies
  • data sorting Closed

    Hi Folks, I need your help in data sorting. Basically I just want to automate the data to be sorted to another table, Names from table1 to table...

    Jearnizck | Latest reply: TrowaD Feb 25, 2014
    2 replies
  • Excel MMYY format in order Solved/Closed

    Hello, I have a data set and a column currently with a selection of dates in MYY and MMYY, eg. 909 (Sep 2009) 1011 (Oct 2011) 1212 (Dec 2012...

    nickkyh | Latest reply: nickkyh Feb 24, 2014
    5 replies
  • Macro adding a row and numbering it in Excel Closed

    Hi, Please could someone help I am trying to record a macro that will add a row below and number A2 with a number say 1, 2, 3 etc. I also need to...

    scully693 | Latest reply: venkat1926 Feb 21, 2014
    1 reply
  • Date format Closed

    Hi, can i have solution for this question how to change date format this case to 21/11/13 to this 21-Nov-13. Thank you............

    Ranjithv | Latest reply: Kevin@Radstock Feb 20, 2014
    4 replies
  • Macro Closed

    Hi, I want to setup a Macro to cary these 2 rows and coloms when I hit the Macro button in excel. Can any one help me. I am staeting with E7:F7. T...

    sjcland | Latest reply: sjcland Feb 20, 2014
    2 replies
  • Excel formula help Solved/Closed

    Hello, I would like to request some assistance with a formula I have been trying to figure out. I know it's a simple one, but it evades my mind. ...

    jgates | Latest reply: ac3mark Feb 19, 2014
    5 replies
  • Apply conditional formatting rule if value is true? Closed

    Hello all! I have been searching for this answer for many days now, and I am getting quite frustrated. I'm not sure if it will work or not, but here i...

    apierson0 | Latest reply: apierson0 Feb 19, 2014
    2 replies
  • Track Office Log IN and Log out timings Closed

    Hi Team, Thanks for providing me an opportunity to be a part of the wonderful Team. I would need a Macro to track the shift timings of the emplo...

    sygururaj | Latest reply: ac3mark Feb 19, 2014
    6 replies
  • how do i change the result of a formula into normal text ? Closed

    Hello , i have a formula which calculates my working hours for each day " =C9+(B9>C9)-B9 " ... when i try to sum all the hours resulted from that f...

    kelnasawa | Latest reply: kelnasawa Feb 18, 2014
    0 replies
  • if cost is 18.66 what would be 0.6% of it (calculation method) Solved/Closed

    and if basic pay 65000rs what would be the 2.5% of it(calculation method)

    nooblord | Latest reply: nooblord Feb 17, 2014
    5 replies
  • Copy Data from one sheet and putting it below a particular Cell Closed

    I have a excel with 3 sheets . My requirement is to pull data from sheet1 ,sheet2 and put it into sheet3. There would be two headings in sheet 3 1...

    ajita | Latest reply: TrowaD Feb 17, 2014
    1 reply
  • Moving Information from 1 set to another based on an IF Closed

    I have two worksheets. 1 is Proposals 2 is Projects When a row in Proposals is given a Project #(a cell in that row) I need the cells in that row to ...

    JDI12 | Latest reply: TrowaD Feb 17, 2014
    1 reply
  • How to move data from one sheet to another Closed

    I have an excel spreadsheet, and I need a macro , in sheet1 I have several values of 7 numbers in a cell, example 1|2|3|4|5|6|7| up to 93|94|95|96|97|...

    maximbebi | Latest reply: TrowaD Feb 17, 2014
    1 reply
  • how to formula the table Closed

    Table 0 to 1000 value is 2 1001 to 2000 value is 3 2001 to 3000 value is 4 3001 to 4000 value is 5 4001 to 5000 value i...

    ernanivalmon... | Latest reply: BunoCS Feb 17, 2014
    1 reply
  • Conditional Formatting with dates Closed

    Hello, Your help would be greatly appreciated I have a cell with a date in it (A1). I want that cell to change colour if the following criteria is ...

    scarey3 | Latest reply: venkat1926 Feb 16, 2014
    1 reply
  • Date issues Closed

    Hello, i have the following problem with excel 2010 on windows 7 pro. i select col A and format it to Date yyyy-MM-dd i enter 2014-01-08 in A...

    DemetriRsa | Latest reply: ac3mark Feb 16, 2014
    7 replies
  • Data import from a Notepad Closed

    Hello everybody. Hope you are doing well. please help me in the following situation. Suppose i have a notepad file where there are some company rec...

    mahfuz19 | Latest reply: ac3mark Feb 16, 2014
    1 reply
  • need macro help Closed

    Hello; thanks for viewing this question.... I need help creating a macro, with detailed instructions on how to put it into excel and actually make ...

    bbrown123 | Latest reply: venkat1926 Feb 14, 2014
    3 replies
  • formulas Solved/Closed

    sum a column if two other columns contain a specific text each so sum (if (A1:A20=1 and B1:B20 = "A", C1:c20)

    Gmooney | Latest reply: Gmooney Feb 14, 2014
    2 replies
  • Copy data from current work to another Solved/Closed

    Hi All, Please can you help me with the VBA code which copies columns from current active workbook to another closed workbook at the end of rows.....

    Sushil Gaikwad | Latest reply: Sush Feb 14, 2014
    2 replies
  • Excel column linking query Closed

    Hi, I would like to know how to link one column with another therefore having the second column recognise it at the same. eg Typing a name in colu...

    hollie2014 | Latest reply: venkat1926 Feb 13, 2014
    1 reply
  • Excel 2007 - Conditional Format Using Calendar Months Closed

    I'm have a workbsheet that has a bunch of dates that show when people have completed their annual training. What I'm trying to do is take the train...

    Boondagger | Latest reply: ac3mark Feb 13, 2014
    1 reply
  • Conditional formatting from another cell by range Solved/Closed

    Hey, I need helpppppppp i want to change the color of a cell based on the range value of another cell eg. i need a1 to be red if b1 is < 70%, Y...

    riboss | Latest reply: ac3mark Feb 13, 2014
    1 reply
  • put the value from various excel sheets using lookup : Closed

    In Sheet1, A B C D ...

    SUMAN4KGP | Latest reply: SUMAN4KGP Feb 13, 2014
    0 replies
  • #value Closed

    Hi, am trying to correct a formula. Each time am using this formula: =IFERROR(VLOOKUP(B15;'Liste des Prix Net'!$A$1:$B$8;2;0);(P15/Q15)*(L15/1000)...

    boule11 | Latest reply: TrowaD Feb 11, 2014
    4 replies
  • Auto sheets .... with common data? Closed

    Hello, I would like to have a new sheet generated on open of workbook with sheet name generated in sequence (i.e. main sheet has common data the...

    diribarren | Latest reply: TrowaD Feb 11, 2014
    3 replies
  • How to Attach a work book Closed

    Hi Sirs, I was asked from a forum member to attach the sample file When I failed to attach as desired. Pl help me regards ansharma

    ansharma | Latest reply: TrowaD Feb 11, 2014
    1 reply
  • Excel Formula Solved/Closed

    I need a formula to compute one equation if one criteria OR another criteria is met, and a different equation depending on another criteria If nu...

    meesh97 | Latest reply: meesh97 Feb 10, 2014
    2 replies
  • Copying simple form data into new databse Closed

    Hello, I'd like to create a simple form that I can then copy into a spreadsheet and will update another workbook for data. My form is very straight...

    rosysnozzy | Latest reply: TrowaD Feb 10, 2014
    1 reply
  • Compare and return the oldest date Closed

    I have a shared workbook comprised of a full report sheet and sheets for individual employees that is being used as a weekly report. Employees enter ...

    McEgirl-J | Latest reply: TrowaD Feb 10, 2014
    1 reply
  • Excel IF help Closed

    Hello, I am looking for a function I think an IF statement for some accounts. I want to say IF ( The value in column B="Tom") THEN (Add the v...

    murock | Latest reply: TrowaD Feb 10, 2014
    1 reply
  • Comparision of Excel sheets Closed

    I just want to ask for your help by providing me codes / references to compare the data in two worksheet, which it means to compare the data in sheet ...

    pws | Latest reply: TrowaD Feb 10, 2014
    5 replies
  • Changing cell color dependent on date in a different cell Closed

    Please help. I created an spreadsheet in Excel 2010 for new hires form tracking. I now would like to have cells change colors to remind me that certai...

    NCnMD | Latest reply: ac3mark Feb 9, 2014
    4 replies
  • code to move a row based on fix values and paste it Solved/Closed

    Hello Gurus, This is my 1st question and I m a beginner in macros .I wanted a code to move a row based on a fix values and paste it in the same shee...

    sonkar | Latest reply: sonkar Feb 8, 2014
    2 replies
  • simple macro Solved/Closed

    I am trying to create a Macro to filling in a series of columns starting with the current cell. simply if cell A1 is selected and you hit the ...

    warnerjs | Latest reply: warnerjs Feb 7, 2014
    2 replies
  • Merging multilple cells based on certain criteria Closed

    Hello, I am stumped on how to attempt this. I have read through some posts but here but I'm quite a novice at Excel so not sure what way to go. ...

    mark17022 | Latest reply: mark17022 Feb 7, 2014
    0 replies
  • fill amount from a cell if date is before end of month Solved/Closed

    Can someone please help. I'm trying to track outstanding bills due by the end of month as in the following example: If date in cell B5 (due date) i...

    hawkwms | Latest reply: hawkwms Feb 6, 2014
    4 replies
  • Excel Referencing Closed

    Hi Experts, I am having the following columns in the excel AA BB CC REQ_3.1_1 REQ_4.1.1_2 ...

    ExcelLearner | Latest reply: venkat1926 Feb 5, 2014
    2 replies
  • convert number to words in excel Closed

    ----------------------------------------------------------------------------------- there is some problem while we convert number to words ............

    mdsarfarazalam | Latest reply: ac3mark Feb 3, 2014
    1 reply
  • Macro to copy the same values between 2 sheets to a new one Closed

    Hello all, I'm not very familiar with macros in Excel and I hope to find a solution. I need a macro that works with 5 sheets (sheet1,2,3,4 and 5)...

    hassameen | Latest reply: venkat1926 Feb 2, 2014
    1 reply