Dear Experts
Could you please help me out here to develop VB for:
If Qty sold in Column R >6,
Split those relevant rows (where Column R>6) in Workbooks by location (Column A) with the Columns C, D, E, R, AJ. Split relevant rows in Worksheets by Customer Names (Column D) inside those relevant workbooks (by location).
I'd be so grateful if i can get this sorted. I have attached the sample file here.
Cheers.
Jared
Bookmarks