pasting nonblank values into new workbook

Hi all!

I have a very tedious by-hand method in excel that I'd like to create a code for. I have no experience with macros but some experience with scripting. I'm mentioning this because every time I use a "code" listed in the forum I'm not really sure if I'm putting it in the right place so any hints on the correct way to use macros would be helpful as well.

Here's the process:
I have a 10 column worksheet, each with 3 sections (the sections are defined by the range of rows)
Each column contains blank and nonblank cells (the nonblanks being just numerical values)
I would like to define each section (which does not vary column to column), then paste only the nonblank values (the location of which do vary), each into a separate worksheet in a new workbook (so 30 sheets total)

Is this possible? I've looked over many codes and haven't found anything. I wish I knew macros better because then I could just piece a few together, but it's pretty foreign to me. Thanks for your help!

Hi,

could u plz provide the sample workbook then its more easy work on u r request.

Thanks - Naveed

okay here they are. in the "blanks" sheet in 5020_mbgjr_AM.xls there are 10 columns, A-J. in the template_MBGjr_Dur_.xls there are 30 empty worksheets (Sheet1-Sheet30). what I need to do is copy the NONBLANK values only from the "blanks" sheet and paste them into sheets in the other workbook, like this:

A2:A128 (in wb1, 5020) to Sheet1 (in wb2, template)
A129:A255 to Sheet5
A256:A382 to Sheet9
B2:B128 to Sheet2
B129:B255 to Sheet6
B256:B382 to Sheet10
C2:C128 to Sheet3
C129:C255 to Sheet7
C256:C382 to Sheet11
D2:D128 to Sheet4
D129:D255 to Sheet8
D256:D382 to Sheet12
E2:E128 to Sheet13
E129:E255 to Sheet19
E256:E382 to Sheet25
F2:F128 to Sheet15
F129:F255 to Sheet21
F256:F382 to Sheet27
G2:G128 to Sheet17
G129:G255 to Sheet23
G256:G382 to Sheet29
H2:H128 to Sheet14
H129:H255 to Sheet20
H256:H382 to Sheet26
I2:I128 to Sheet16
I129:I255 to Sheet22
I256:I382 to Sheet28
J2:J128 to Sheet18
J129:J255 to Sheet24
JB256:J382 to Sheet30

I know there doesn't seem to be a ton of rhyme or reason to this pattern, but I didn't create the set-up nor can I change it because external analyses depend on this ordering.

Thanks so much for the help! I'm really at a loss here so I appreciate it greatly!

-Aggie