| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter data simultaneously on mulitiple worksheets? | Setting up and Configuration of Excel | |||
| Entering Data into worksheets Simultaneously | Excel Worksheet Functions | |||
| Indicating Rows to Repeat At Top on all Worksheets Simultaneously | Excel Worksheet Functions | |||
| Button to insert rows on mutiple worksheets and copy text and info | Excel Programming | |||
| adding data simultaneously onto 3 worksheets | Excel Worksheet Functions | |||
Linear Mode
