Look up question from changing range with criteria

[Steve in MN]

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

 

[Joel]

You have 4 different method to choose.

1) You can use formula in sheet one which are going to be long and
complicated. I don't like complicated formulas but some people do
2) Write a macro that imports the data and puts the data in the correct
locations on the Data Import sheet
3) Write a macro that moveds the data once it is imported
4) Don't link the data. Write a macro that puts the data into Board with no
links

I don't know if you import data comes from a workbook or is a text file.
VBA can open text files and read the data one row at a time and parse the
data into the correct locations in the workbook. Without seeing the workbook
layout I can't determine which is the best metho or the metho you prefer.

 

[Steve in MN]

Thanks for the response,

I need to know how to look up the information and fill it in the main sheet
based on the criteria of what batch it is in.

In the import sheet (which I am pulling the data from) it has data that is
pulled from a data base sorted by batch all in one group. The "Board" sheet
has set areas of 12 rows per batch group. The import sheet does not have
consistent size ranges so one day there may be 10 batch 1 rows and then batch
2 starts at row 11.
How do you write criteria to look up by batch and then fill onto the cells
with out having any empty ones?