copying formulas

Hello VBA Gurus, I would like to create a new row with a command button and then have VBA codes copy the formatting and certain formulas from the row above into the newly inserted row. I would like to only copy formulas from certain column ranges (i.e. A:B; D:L, U:AA) and leave the rest blank...

I need help!! I have a rolling schedule where I want to calculate the networkdays, we are now coming up to company close offs and I am trying to add our close off dates by adding the "holiday dates" function I currently have the holiday dates filled in on another page of the workbook and have...

Hi All, I have 4 sheets name A, B, C and D. The D worksheet is a summary sheet that pulls in data from A, B and C. e.g. =A!A4 =A!C4 There are approx 50 of these references to Cell A. Is there an easy way to copy the same formulas but reference Sheet B and C without having to retype them...

I have a data set which I want to group easily into blocks. This is the formula I have:- =COUNTIFS(Sheet1!I:I,">=0"(or A5),Sheet1!I:I,"<1"(or A6)) I want to keep the range the same and copy the formula down incrementing the blocks each time so it counts 0-1,1-2,2-3 etc., etc. So the next...

I have a range of cells I would like to insert the below formula into. The range is “G5:G10000” keeping in mind the formula needs to change for each row as it would if you copied and pasted it down a column. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...