Copy / Insert n Rows of data simultaneously to 3 worksheets, same workbook
 

Example :
1. Prompt for the number of rows to insert from mouse pointer.
2. If mouse pointer is on Row 5 on Sheet 1
Link Sheets 1, 2 and 3
Copy simultaneously All Row 4 (Format & Formulas) from Sheet1, 2
and 3
3. Insert the number of copies to insert from Row 4 in Sheets 1, 2 and
3
to Row 5 in same Sheets.
4. Unlink Sheets 1, 2 and 3
Help appreciated.
J.P.

Copy / Insert n Rows of data simultaneously to 3 worksheets, same workbook
 

On Jul 26, 3:12*pm, u473 wrote:
Example :
1. Prompt for the number of rows to insert from mouse pointer.
2. If mouse pointer is on Row 5 on Sheet 1
* * Link Sheets 1, 2 and 3
* * Copy simultaneously All Row 4 (Format & Formulas) from Sheet1, 2
and 3
3. Insert the number of copies to insert from Row 4 in Sheets 1, 2 and
3
* * to * Row 5 in same Sheets.
4. Unlink Sheets 1, 2 and 3
Help appreciated.
J.P.

Why? Is this homework?