Hi,
Kind of a newbie to excel work, more familiar with access programming, but
got assigned a project.
I have an imported set of data on "import data" sheet. there is 8 columns
(always 8) and then the rows vary from day to day based on what is expected
to arrive in. In these rows the last field is called batch and the value can
range between 1 and 6.

I am linking all 8 columns to the main sheet "board" but there are
predefined areas of 12 rows allocated to each batch on this board. So static
linking to a set cell wont work because the data changes each day and some
times there is 10 batch 1 records and the next day there is only 8. Then the
links would be off and put batch 2 records in my batch 1 area.
How does one go about setting up code or using criteria to have it look for
batch 1 records and fill in the batch one area with out inserting blank
spaces until the criteria is met? Then move on to the batch 2 area and pull
all the batch 2 records out and put them in their 12 row area? etc...
Thanks in advance.

Steve