Button to insert rows on mutiple worksheets and copy text and info
 

I have mutiple worksheets A, B, C and D. Worksheets B, C, and D are
subsidiary sheets of Worksheet A. Worksheet A column A lists items. Worksheet
B, C and D's column "A"s link to Worksheet A column A so as to list the same
item as Worksheet A. Additionally, Worksheet A's columns BB, CC, and DD are
linked to worksheets B, C and D.

I would like to add a button to a Worksheet A that performs multiple steps.
(1) add the same, specified number of rows - based on # input - into
Worksheets A, B, C, and D.
(2) add temporary placeholders that read "Info to be input", or something
akin to that, into the new rows in Worksheet A, column A
(3) add or copy links in Worksheets B, C and D to Worksheet A column A for
the new rows
(4) add or copy relative links in Worksheet A columns BB, CC and DD to
Worksheets B, C and D for the new rows

The rows must be inserted at specific locations.

Lastly, please help me in adding a button for deleting a range of rows in
Worksheets A, B, C and D simulaneously.

Thank you.

Button to insert rows on mutiple worksheets and copy text and info
 

Use ONE sheet, with customized views, data filters, or a macro to hide rows -- Anything other than
multiple worksheets showing the same data in the same way.


HTH,
Bernie
MS Excel MVP


"chuck_galda" wrote in message
...
I have mutiple worksheets A, B, C and D. Worksheets B, C, and D are
subsidiary sheets of Worksheet A. Worksheet A column A lists items. Worksheet
B, C and D's column "A"s link to Worksheet A column A so as to list the same
item as Worksheet A. Additionally, Worksheet A's columns BB, CC, and DD are
linked to worksheets B, C and D.

I would like to add a button to a Worksheet A that performs multiple steps.
(1) add the same, specified number of rows - based on # input - into
Worksheets A, B, C, and D.
(2) add temporary placeholders that read "Info to be input", or something
akin to that, into the new rows in Worksheet A, column A
(3) add or copy links in Worksheets B, C and D to Worksheet A column A for
the new rows
(4) add or copy relative links in Worksheet A columns BB, CC and DD to
Worksheets B, C and D for the new rows

The rows must be inserted at specific locations.

Lastly, please help me in adding a button for deleting a range of rows in
Worksheets A, B, C and D simulaneously.

Thank you.