I need to get a button to, when clicked, inserts a (copied) named range on another sheet, into the rows above the location of the button as it moves down the page when new "items" are added.
I'd also like it to be able to number the "items" accordingly, as in the sheet will start with 1 "item" that is numbered "1". I'd like to add the aforementioned range, below "1" and have the newly inserted item automatically numbered "2", and so on.
I played around with macros and was successful in copying and pasting the range into the area above the button, but it only worked once as the code specifies the row to be inserted and if i tried it again it would insert it into the completely wrong area.
Here is a screenshot to what I have and what it will look like first opening it.
Here is a screenshot of what it looks like when I press the button with it's assigned macro... - Notice How it places it above #1 and not in the rows above the Button... I don't want that, ha.
Here is a screenshot of what I'd ultimately like it to look/act like.
The Add New Cabinet button (Form) has the macro AddNewCab assigned to it. That Macro's code is currently:
The Named Range I was talking about is on another sheet (same workbook) that is essentially just a duplicate of what you see on rows 30 to 46. I named it NewCab.Please Login or Register to view this content.
And the "Numbering" that I mentioned would change the merged cell C34 to the number in the cabinet above it plus 1.
I hope that makes sense. Also, If I could go about this another way, I'm open to suggestions.
Bookmarks