In the attached file, the Part B worksheet from B4 downwards is parsed out through a Text2Column macro (Ctrl+r to run it) and that information goes into hidden Columns C, D and E. The information in the hidden columns is then used to update the Part C worksheet rows 4 and 5 on-wards through an INDEX/COLUMN function. For example if I insert information into Part B cell B7 and then run the macro, it will do the Text2Column conversion and parse that information into Part C cells E4 and E5. So far so good



Part B is considered the 'Master data sheet' so if I select cells B9 thru X9 and then insert and shift the selected cells down, fill in the updated information and then run the macro, it will have moved the information that was contained in Part C cells G4 and G5 into cells H4 and H5 and populated cells G4 and G5 with the updated information.

The issue is that the information contained in cells G6 thru G15 needs to 'remain attached' with the info now in cells H4 and H5.

What is the best way to make that happen?

Attached Files

Book 1 as at 13_05.xlsm (44.9 KB, 18 views)

this has now also been cross-posted at this site.