1. 1

    Exce VBA Code for Copy and Pasting Mutiple Rows and then modifing values in Cells keeping formual in place

    Hi I have a spreadsheet which contains mutiple different rows I want to duplicate all the rows multiple times using a value in the duplicate colum The Kick Off Date contains the formula =DATE(YEAR(G2),MONTH(G2),DAY(G2)+F2) and End Date contain the formula =DATE(YEAR(C2),MONTH(C2),DAY(C2)+D2)...
  2. J

    Creating a SUMIF function for changeable data

    Hi all, I wonder if you can help please? I'm currently trying to create an SUMIFS function across static data in various columns, however the function will kick out next month as one of the columns is likely to change. Currently I have the below =SUMIFS(F:F,D:D,"PAY",E:E,"EUR",B:B,"Company")...
  3. M

    Can a Function kick off a sub routine or write to other cells?

    Don't think it can kick off a subroutine but is it possible for the function to write to other offet cells, i.e. I put =someFunction(22) in A1 would that function be able to write data to A2 as well?
  4. S

    using numbers from cells in formula

    HI Ok, so lets say i use =COUNTA('MY SELECTIONS'!A1:A100)-1 no problem but lets say the 1 was in cell z1 and the 100 was in cell z2. can it be done and if so how, im goint to kick myself its easy. thanks for looking Dave
  5. M

    file locked for editing , can I kick the other user out if its my file?

    file locked for editing , can I kick the other user out if its my file? I have made an excel file where other people have to go in and update it. This process takes 2 secs but some people forget and stay in it over lunch etc causing a great annoyance. Is there anyway I can "kick" them out my...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...