The macro is almost there but just needs fine tuning;
Also another variation;
The first one is the most recent, althought the 2nd one did the trick pretty much except;
When i add that to the sheet i want the macro to run from;
http://img293.imageshack.us/img293/3235/exampleg.jpg
What happens is i enter a 0 into O on the sheet and it pastes into the Zeros sheet at another column number, not O but the sheet is an identical duplicate.
The 2nd macro works perfectly but like this one, i i enter a 0 on the next cell down in O it pastes over the previous one in Zeros instead of moving down to the next unoccupied cell.
Hope you can assist.
Bookmarks