R
RompStar
I will try my best to explain this so that people aren't confused,
unlike my previous post, which didn't seem like it was clear.
Ok, I have a Excel spreadsheet..
There are columns A - N in it..
and Rows 0 - 10 are filled with formulas and headers and other info...
Column N has this formula: =NETWORKDAYS(J11,K11)-1
which calculates two date ranges, in J and K columns.
I get that data from a different sheet, and I copy it, position my
mouse
at A11 and paste it, and then all the rows below A10 are filled...
Everyday, I need to clear the rows A11 and down, for a new day,
and I paste the new data from a different sheet.
When I do this, the =NETWORKDAYS=(J11,K11)-1 is lost, because I clear
the rows before the paste operation...
even if I clear the data, I would like the formula to be kept in the N
column.
So goal #1 is to learn that...
Goal #2 is this:
say I paste new data, say 600 new rows... so it would go from
a11 - a611 (columns a - n )
I use this to tell me the data range that I paste:
=MATCH(9.99999999999999E+307,$A$11:$A$65536)
and basically, I would like for column N to somehow automatically
fill that =NETWORKDAYS( down to the last row ) in N based on
how many new rows I pasted in....
maybe a script would do this better, any ideas ?
thank you...
unlike my previous post, which didn't seem like it was clear.
Ok, I have a Excel spreadsheet..
There are columns A - N in it..
and Rows 0 - 10 are filled with formulas and headers and other info...
Column N has this formula: =NETWORKDAYS(J11,K11)-1
which calculates two date ranges, in J and K columns.
I get that data from a different sheet, and I copy it, position my
mouse
at A11 and paste it, and then all the rows below A10 are filled...
Everyday, I need to clear the rows A11 and down, for a new day,
and I paste the new data from a different sheet.
When I do this, the =NETWORKDAYS=(J11,K11)-1 is lost, because I clear
the rows before the paste operation...
even if I clear the data, I would like the formula to be kept in the N
column.
So goal #1 is to learn that...
Goal #2 is this:
say I paste new data, say 600 new rows... so it would go from
a11 - a611 (columns a - n )
I use this to tell me the data range that I paste:
=MATCH(9.99999999999999E+307,$A$11:$A$65536)
and basically, I would like for column N to somehow automatically
fill that =NETWORKDAYS( down to the last row ) in N based on
how many new rows I pasted in....
maybe a script would do this better, any ideas ?
thank you...