macro that copies and paste info into another worksheet

[TimfromFinland]

I am trying to build a macro that copies and paste info into another worksheet. It has to see whether a range of cells met a criteria and the copy that cell plus the cell next to it to another sheet. It is for monhtly charts exactualy.

so e.g. you have january and you want to see wether the data is in January then you set up the condition. and it that one is true copy the cell and the cell on the right which covers the values to another cell. If this is done you go to the next cell and further on. but only copy when the other cell is empty so it would not overwrite is. Can someone please help since I am not an expert. I tried to do this but how can I make sure it goes to another row everytime? (the cell under the first one).

Thanks.

[davesexcel]

Here's a sample workbook that has many different kinds of code as well as looking for a value in another sheet and pasting some of the cells in that row to another sheet
It also includes
Remove duplicates for a listbox,thanks to J-Walk-http://j-walk.com/ss/excel/tips/tip47.htm
Shows RightClick Worksheet event, on "Information" sheet column B
Find value from listbox and paste to Order Form using a loop code
Ensure a number is entered in a certain range using worksheet change event
Also shows how to use send keys code
When the workbook is opened, click the button, select a number,
then the code will loop through column A in the information sheet,copying and pasting ranges as it finds a matching value... well check it out and see if you have any questions after that...