Sheet # 1 = "DATA" is my data file
Work-Order Item-1 Item-2 Item-3 Item-4 Item-5
X X1 X2 X3 X4 X5 >>>> First line of data
Y Y1 Y2 Y3 Y4 Y5 >>>> Second line of data
Z Z1 Z2 Z3 Z4 Z5 >>>> Third line of data
I would like to create automatically new sheet as my work order which is cell A3= X. sheet name should be "X".
Data populated on my new created sheet should be from the second line of data as follow.
Item-1 X1
Item-2 X2
Item-3 X3
Item-4 X4
Item-5 X5
As soon as I entered my next new work order in cell A4, new sheet A4="Y" should be created
Data populated on my new created sheet should be from the Third line of data as follow.
Item-1 Y1
Item-2 Y2
Item-3 Y3
Item-4 Y4
Item-5 Y5
As soon as I entered my next new work order in cell A5, new sheet A5="Z" should be created
Data populated on my new created sheet should be from the fourth line of data as follow.
Item-1 Z1
Item-2 Z2
Item-3 Z3
Item-4 Z4
Item-5 Z5
How can I do this?
All help appreciated.
Bookmarks