Posts by shrimic

    Hi friends,

    I have a small problem with a macro..can somebody please help...

    I have to add a row with all the other rows below it...


    Dram 100 150 200 300
    Nand 50 75 80 90
    Nor 11 22 33 44

    I have to add the Dram row values with the below row values....
    I have to get the output like...

    Dram 100 150 200 300
    Nand 150 225 280 390
    Nor 111 172 233 344

    can somebody help me with this..thank you very much...

    Hi Friends,

    I need to look for a match between Column A of 'DRAM' worksheet and Column A of 'Refer' worksheet and if a match is found then the row containing the match should be stored in a variable 'Cell1' and then my code must look for a string 'WS Group Totals:" in Column B of 'DRAM' sheet and the row containing the string must be stored in a variable Cell2. In the row containing Cell2 the values from Column D till the row end must be multiplied by 10080 and the result must be placed two rows below the last populated row in their respective columns. Once that is done my code must look for the next match of Column A in 'DRAM' and COLUMN A in 'Refer' worksheets and must do the calculation as the same as above. I have written the below code for the purpose but I am repeatedly getting Application or Object defined error...can someone please help me figure out the error...thank you very much..I have attached the original Workbook for your reference...

    Re: Offsetting columns and using appropriate cell values during calculations

    Thanks for your time be very honest I am writing a huge code where the part which I requested for assistance is a small the code I am writing is huge I tried to simplify my problem to exactly to what I had problems in...Actually I had to use D9 value in a huge formula and progressively each E9 and F9...till I reach the end of the line...and this I had to do in a slightly different way for a large number of worksheets with different calculations...If my question was a bit confusing..believe me thats the best I could do to simplify my problem..thanks for your help Sir...

    Hello friends,

    I am trying to code a macro for the following scenario:
    1. Everytime I run the macro, it has to take the value in column "D" 1st row (D1) and multiply it with 100 and then put the result in the cell below the last filled cell in D column and then it has to offset by a column to E and then multiply the value in E1 with 100 and put it in the cell after the last filled cell in column E and then it should do the same above stated steps with column F and H, I till the it reaches the lastfilled cell in row 1...can somebody help me with this...thanks in advance..

    Re: calculate value using cells referenced based on conditions

    ya it can be done more simply as you said but my boss wants to run a macro and all calculations done for him....ya basically what I meant in the confusing part was...if the "WS Groups" fall in the 9 the row , then it should be assigned the cell address D9 and the value in D9 must be assigned to a variable named "Cell3"..

    Hello Friends,
    I am trying to develop a macro which does calculations (using references to cells) based on conditions..
    My problem definition is:
    if there is a match between Column A of DRAM and Reference1 sheets, I must look for the row which has the value "WS Group Totals:" in Column B of DRAM Sheet and assign the Column D cell intersecting the row containing "WS Group Totals" to 'Cell3'. Then I have to look if there is a match between Column A of DRAM and Reference1 sheets and must look for the row in Column A of Reference1 where there is a match and I have to assign the "E" and "H" column intersection of the rows to 'Cell5' and 'Cell6' respectively and then I have to calculate the formula '(((10080*cell6*cell3)/(0.98*cell5)))+Worksheet("DRAM").Range("D19").Value' and assign that value to cell D20 and progressively till the end of row is reached, each time offsetting the 'Cell3' value by a column when 'Cell5' and 'Cell6' values remains the same..Actually there are two Workstation Groups: 'IMP_Plasma_PLAD_B2H6' and 'IMP_PLASMA_PLAD_BF3' for which a match of Column A in DRAM and Reference1 sheets will be found. the results for both of them are needed and placed below one another
    I have written a macro which is partly working. For the 1st worksatation group it is taking the 'Cell5' and 'Cell6' values of 2nd Workstation group. I am not able to figure out where I am erring. I have given my code below and have attached the original worksheet for your reference. I am very new to coding and I am really thankful to any help you can provide....