Sorry, I know this question isn't even entertaining for you guys...I've
tried my best to figure it out but I still need just a little help!

I have a table in a spreadsheet (see attached 'exceltable.jpg') that
needs to be copied into other worksheets but only the table rows
containing values (Range B26:H28 in the image). Of course the range is
changing for different orders and such...

So how do I get excel to insert the correct amount of rows into the
different worksheets in between rows 13 and 14 (see attaced
'exceltable002.jpg') and paste the range with values into the newly
created rows???? So it ends up looking like the attached
exceltable003.jpg


+-------------------------------------------------------------------+
|Filename: exceltable003.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=5224 |
+-------------------------------------------------------------------+

--
grahamhurlburt
------------------------------------------------------------------------
grahamhurlburt's Profile: http://www.excelforum.com/member.php...o&userid=29878
View this thread: http://www.excelforum.com/showthread...hreadid=572851