I am currently creating a workbook that has 5 worksheets. I have a MAINPAGE, where I would like to input all necessary information. Then, based of the criteria in Column H, paste the entire row into the according worksheet. For example, if Row1=Scrap, Copy entire row to Scrap worksheet.
I am not familiar with VBA or macros. Was hoping for a formula, but if one is not available, with a little explanation of macro code I can understand. Any help would be appreciated!
Bookmarks