Hi
Let's say i will be using 1 of 6 words (cell a13) to categorise a row of data (cells b13 - q13) in a worksheet.
I then have 6 other worksheets each named after the 6 words.
Let's say the category words/worksheet names are A, B, C, D, E & F.
If a13 = A then put the values in cells b13 - q13 into worksheet A, cells b13 - q13
If a13 = B then put the values in cells b13 - q13 into worksheet B, cells b13 - q13 etc
Hope that's clear & someone can help.
Thanks,
Al.
Bookmarks