Hi all,
I honestly have no idea where to begin with this so was hoping someone could help me out.
What I am trying to achieve is have two buttons, 1 of which (New Item) will make a copy of the section in my sheet from A11:I20 and insert it below with the item number etc blank ready for a new entry.
I was considering the easiest way to do this may be to have a blank copy of this on another sheet and creating a copy from that to save having to clear the cells in the new item of the copied data.
The second button is to delete the section.
as part of this I suppose I would also need the buttons themselves to be copied/deleted along with the sections themselves.
I know this explanation is probably not overly clear but I have attached a link to download my excel sheet below.
https://www.odrive.com/s/e623f855-4bec-4e86-99f5-8ae9b48c4c90-57354015
I honestly have no idea where to begin with this so was hoping someone could help me out.
What I am trying to achieve is have two buttons, 1 of which (New Item) will make a copy of the section in my sheet from A11:I20 and insert it below with the item number etc blank ready for a new entry.
I was considering the easiest way to do this may be to have a blank copy of this on another sheet and creating a copy from that to save having to clear the cells in the new item of the copied data.
The second button is to delete the section.
as part of this I suppose I would also need the buttons themselves to be copied/deleted along with the sections themselves.
I know this explanation is probably not overly clear but I have attached a link to download my excel sheet below.
https://www.odrive.com/s/e623f855-4bec-4e86-99f5-8ae9b48c4c90-57354015
