Hi guys,

So I am trying to write some code that would delete a static range of data and shift the rows up.

For example, I have charts that are reading data from rows B3:H14. I also have data on B18:H29, and so forth up to 14 sets of data for 14 different charts.
What I want to do is click a button and it will shift cells B4:H14 up ultimately replacing the data in B3:H3, and the same thing for B19:H29 where B18:H18 is replaced.

I was originally using this:
Please Login or Register  to view this content.
but this is obviously only on select, and I'm not sure how to designate a specific range, let alone multiple ranges throughout the whole sheet.

Any help would be greatly appreciated!

-Bob