Rearranging data to another sheet in excell
Closed
Michael
-
May 4, 2010 at 05:49 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 4, 2010 at 06:01 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 4, 2010 at 06:01 PM
Related:
- Rearranging data to another sheet in excell
- Sheet right to left in google sheet - Guide
- Mark sheet in excel - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to open excel sheet in notepad++ - Guide
- Windows network commands cheat sheet - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 4, 2010 at 06:01 PM
May 4, 2010 at 06:01 PM
Yes possible with a macro.
1. Find the last used row
2. loop thru all rows
3. in each row
3a. look for item that you wanted
3b. copy to the new sheet
3c. if row is blank then presume that new record
1. Find the last used row
2. loop thru all rows
3. in each row
3a. look for item that you wanted
3b. copy to the new sheet
3c. if row is blank then presume that new record