Need help copying rows please
Closed
wtr2wine
-
May 2, 2012 at 10:22 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 3, 2012 at 06:54 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 3, 2012 at 06:54 PM
Related:
- Need help copying rows please
- Protect pdf from copying - Guide
- How to delete rows and columns in word - Guide
- Excel insert multiple rows - Guide
- Copying data from one sheet to another - Guide
- Repeat rows in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 2, 2012 at 06:06 PM
May 2, 2012 at 06:06 PM
you would need to use macro as you correctly have said.
What you need to do is
1. create a loop till last row is reached
2. for row, get the account number
3. use "SEARCH" command, to located the account
4. If found, then
4a insert a row
4b copy the row
4c paste the row
5. move to next row and repeat step 2 -5
What you need to do is
1. create a loop till last row is reached
2. for row, get the account number
3. use "SEARCH" command, to located the account
4. If found, then
4a insert a row
4b copy the row
4c paste the row
5. move to next row and repeat step 2 -5
May 3, 2012 at 07:27 AM
May 3, 2012 at 06:54 PM
Here is code which at the minimum should give you a great starting point