Transfer names from general sheet to separate other sheets
Closed
Tyler
-
23 Jun 2016 à 18:17
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 25 Jun 2016 à 03:40
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 25 Jun 2016 à 03:40
Related:
- Transfer names from general sheet to separate other sheets
- How to copy data from one excel sheet to another - Guide
- Google sheets download - Download - Spreadsheets
- Little alchemy cheat sheet - Guide
- Free fire transfer - Guide
- Google sheets right to left - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Contributor
Last seen
6 September 2024
262
25 Jun 2016 à 03:40
25 Jun 2016 à 03:40
Hello Tyler,
Using formulae will leave blanks in the "Group" sheets as formulae are cell specific. You can, of course, sort Columns A & C (ascending) in sheet 1 first by using the sort feature in the ribbon or use a macro to sort for you.
Furthermore, if your data set is large, or you expect it to grow large, then formulae will slow proceedings considerably.
So, in your case, I would say that a macro using auto filter, would be your best option. Sorting would not be required.
Let us know your thoughts.
Cheerio,
vcoolio.
Using formulae will leave blanks in the "Group" sheets as formulae are cell specific. You can, of course, sort Columns A & C (ascending) in sheet 1 first by using the sort feature in the ribbon or use a macro to sort for you.
Furthermore, if your data set is large, or you expect it to grow large, then formulae will slow proceedings considerably.
So, in your case, I would say that a macro using auto filter, would be your best option. Sorting would not be required.
Let us know your thoughts.
Cheerio,
vcoolio.