M
Michael168
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 are:
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 summary 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.
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 are:
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 summary 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.