G
Guest
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.
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.