Hi all
I have workbook with sheet(Main, Resouce, Result)
In sheet(Main) I have Form with 03 option button. Now I want macro to do that:
When I choose one of 03 option on Form will clear all cells in sheet(result) and add ("A1)"value = "Branch", ("B1").value = "Code"
- If I choose option1 will copy data like:
sheet(resource).range(A2, lastrow).copy to sheet(result).range(A2)
sheet(resource).range(B2, lastrow).copy to sheet(result).range(C1) and transpose
Then Call macro "check"
- If I choose option2 will copy data like:
sheet(resource).range(C2, lastrow).copy to sheet(result).range(A2)
sheet(resource).range(D2, lastrow).copy to sheet(result).range(C1) and transpose
Then Call macro "check"
- If I choose option3 will copy data like:
sheet(resource).range(A2, lastrow).copy to sheet(result).range(A2)
sheet(resource).range(C2, lastrow).copy to sheet(result).range(last row, 1)
sheet(resource).range(B2, lastrow).copy to sheet(result).range(C1) and transpose
sheet(resource).range(D2, lastrow).copy to sheet(result).range(1, lastcolumn) and transpose
Then Call macro "check"
I attachment file below to clear my idea, sheet(result_when check All) this mean when I choose option3
Please help me./.
Bookmarks