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.

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" <(E-Mail Removed)> wrote in message
news:CB1978A7-3C7A-483F-AB57-(E-Mail Removed)...
>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.