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 with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...