in short please follow the link below of my question.


i am trying to move data from one worksheet to another (post-production to database) on a specific row.

the specific row is the database* ref number, entering this number on the post production form, filling in the details and running the macro will convert the input information into the spreadsheet against the correct production job.

i know how to move the data from the form to the database (i have done this to move the details on the pre-production form into the database) and will match the same method with the post-production. (i have been using "activecell.offset(0,2) etc) however to do so i need a macro that will find the correct cell so i can offset from it



http://www.computerhope.com/forum/in...;topicseen#new



* please note i am using a spreadsheet on excel as a basic "database"