Need help copying rows please
Closed
wtr2wine
-
May 2, 2012 at 10:22 AM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Need help copying rows please
- Excel - Copying row from another sheet - How-To - Excel
- How to insert copied rows multiple times in excel ✓ - Forum - Excel
- Copy row and insert n times ✓ - Forum - Office Software
- Copying cond. format for entire row based on 1 cell to other row ✓ - Forum - Excel
- Copying Conditional Formatting with Formulas Accross Rows ✓ - Forum - Excel
1 reply
rizvisa1
May 2, 2012 at 06:06 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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