hello
I have two columns in I,J for each separated sheet . the column I is the item should add into column B for specific sheet and the column J is where the location should add to it .
so if I would add item into column B for adjacent cells based on adjacent cells column J . for instance when write 1 in column J then should add the item into position after first item and create one space after add it and if I write 0 should add before the first item . should add it to adjacent cell into column B and so on should search the position of item based on value in column J and add it after it .
I put the expected result in sheet result how should be in sh1,sh2 into column B based on column I,J
Bookmarks