J
J.W. Aldridge
I had trouble assembling a code to do the following, please assist....
1. Combine list from 3 specific sheets, into one "master" sheet.
(All data is on each sheet A:I - No headers)
Sheet 1 - "Apples"
Sheet 2 - "Oranges"
Sheet 3 - "Grapes
2. Sort Master sheet based on column A (groups), then B (names).
3. Create new sheets based on the names column B in the master sheet
(in the same order that the names appear).
1. Combine list from 3 specific sheets, into one "master" sheet.
(All data is on each sheet A:I - No headers)
Sheet 1 - "Apples"
Sheet 2 - "Oranges"
Sheet 3 - "Grapes
2. Sort Master sheet based on column A (groups), then B (names).
3. Create new sheets based on the names column B in the master sheet
(in the same order that the names appear).