Insert, shift cells down and populate

Good morning,

I have a range of cells in a sheet that I am wanting to insert data in to and then populate with data. (there is other information in the rows so I dont want insert rows.

I have the following for the insert, but the populate is very manual

Please Login or Register  to view this content.

Currently I have the populate as a cell reference, but this list may change regularly.

Please Login or Register  to view this content.

Is there a way that I can have the cells insert and populate the next cells down rather than including a cell reference? The above is just a sample. I have a heap that I need to insert (and change) on a regular basis.

is this the best way of going about this? or is there a better/easier way?

Please Login or Register  to view this content.

Thanks for looking

Please Login or Register  to view this content.

Hi there,

It's much simplier, easier to read/follow and quicker if you just reference the relevant cell you want to manipulate, i.e.

Please Login or Register  to view this content.

HTH

Robert