I have a weekly report that holds line item detail for seven different account numbers. The data is going to vary from week to week and I need vba code that will separate the data by account number into different tabs. Any tips on how to write the code? RWC
I want a loop that will look at the first four words in column A and if they match then the entire row should be cut and pasted to another sheet.