A
abxy
Ok, I've created a worksheet with some alternating shaded rows using
conditional formatting and formula is: =MOD(ROW(),2). and I've
customized some cells (the same cells on every row) with formulas to do
some needed calculations when I paste data onto the worksheet from
notepad or Word, no biggie. Now here's where the problem comes in,
Everyday, there's a different amount of data, some days it's only 10
lines, some days it's 105 lines of data. Therefore i've had to make an
excess of these alternating shaded rows, and after I paste in the data,
delete the unused rows, or select everything i want printed and set
that as the print area. Is there anyway I make it so that when I paste
in the data, my alternating shaded rows(complete with my cells that i
have formulas in) will continue in there pattern to accomadate for the
number of lines of data pasted in? A bonus would be if i could make it
so that the very last row (the row after the last line of data pasted
in) is a different type of row that will sum up the vaules in the rows
pasted.
Thanks in advance
conditional formatting and formula is: =MOD(ROW(),2). and I've
customized some cells (the same cells on every row) with formulas to do
some needed calculations when I paste data onto the worksheet from
notepad or Word, no biggie. Now here's where the problem comes in,
Everyday, there's a different amount of data, some days it's only 10
lines, some days it's 105 lines of data. Therefore i've had to make an
excess of these alternating shaded rows, and after I paste in the data,
delete the unused rows, or select everything i want printed and set
that as the print area. Is there anyway I make it so that when I paste
in the data, my alternating shaded rows(complete with my cells that i
have formulas in) will continue in there pattern to accomadate for the
number of lines of data pasted in? A bonus would be if i could make it
so that the very last row (the row after the last line of data pasted
in) is a different type of row that will sum up the vaules in the rows
pasted.
Thanks in advance