I want to code a module below using 2 worksheets i.e "Data" and "Query"
but not good in vba code.

Look in the datasheet at row2 for a value of 1, if found, then look at
next row i.e. row3 for value found in the querysheet. If the individual
value found is the same as in the querysheet individual column, it will
write the date & rowno of row2 of datasheet and the value of 1 or 0
will be insert accordingly to the column into the querysheet.

This macro will run the loops from row2 of datasheet until the last
row. New found items/values will be written row after row in the
querysheet. Can anyone help.

Some questions concerning VBA syntax.

Q1) To use a workbook/worksheet
Q2) Do whil not eof() & Enddo.
Q3) Checking a range of cells for value
Q4) Skipping next row
Q5) Writing value to particular cell into particular cell
Q6) Do Case & Endcase with Select.

Can someone tell me what are these syntax in VBA.

Thank you.


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