0
votes

I'm looking for a way (macro or formula) to insert multiple rows of pre-defined data from sheet2 (4 additional rows) between each existing row on sheet1.

The predefine data on sheet2 is as following:

enter image description here

The Existing data on sheet1:

enter image description here

The resulting data after - Added rows show in yellow: enter image description here

  1. Between Each row of data on sheet1, it needs to add each row from Sheet2.
  2. Copy Existing data from the ROW and duplicate on new ROW
  3. BUT change the Sublevel column to N on each added Row.
1

1 Answers

-1
votes

duplicate your data 4 times

4332
4333
4335

then fill in the data you want (on the duplicated records only)

20
21
10
6

then change the sublevel to N (on the duplicated records only)

then apply autofilter sort by Projects (A-Z), then sort SubLevel (Z-A)