#1
|
|||
|
|||
Master sheet row insert and then update another worksheet
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? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update Excel worksheet from Google sheet | tasneemj | Excel | 0 | 02-11-2018 12:17 PM |
update master list automatically from other worksheet | vicmar | Excel | 21 | 09-08-2017 11:33 PM |
Open an existing sheet by clicking on a cell in a master sheet | darbybrown | Excel | 3 | 09-12-2016 05:12 PM |
Pulling data from one sheet and displaying on another worksheet | baybeelov | Excel | 0 | 12-19-2014 12:24 PM |
want to put ID no from worksheet ID no master..... | mahfuz19 | Excel | 3 | 03-13-2014 10:37 AM |