It is possible to do something like this?
A workbook consists of 1 datasheet and multiple querysheets.

e.g.
Datasheet contains
Row 1( Header)---- Date Na Nb Nc Nd
Row 2 31/10/03 1 8 3 4
Row 3 01/11/03 5 8 2 9

Querysheet contains
Row 1(Header)---- Date Rowno 1 3 5 6 9
Row 2 31/10/03 2 0 0 1 0 1

Updating conditions a

Look in the datasheet at row2 for first value in the range (B2:E2), in
this case a value of 1 is found, then look at next row i.e. row3 for
value found in the querysheet in this case are 1,3,5,6,9 . If found, it
will write the date & rowno of row2 of datasheet and the value of 1 & 0
will be insert accordingly to the column. After finished the first cell
(B1) value, it will continue to C1 and do the same routine. Which
querysheet to use for updating the info is based on the value found in
cell. The querysheet are name after the cell values with a "Q" in front
like Q1 for cell value of 1 and Q8 for cell value of 8 and so on.
This macro will run the loops from row2 of datasheet until the last
row.

Thank you for helping.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/