- Jan 20, 2006
- Office Version
I need to copy data from one sheet to another sheet when a mathmatical formula shows a certain number. (ie when stock on hand gets below a certain poiint copy the row over to another sheet so it can be reordered). Probably be more than one row to be copied. But I need all the information in the row copied. Col A= part #, Col B= Description, Col C= Vender etc...Nothing fancy but simple. I know this will be an easy solution for you folks that are VBA Guru's. That leaves me out. Any Ideas, better yet any solutions? Thanks for your help in advance.