hello
I have first sheet name's MAIN . what I want using input box if i write 1 , then should add new sheet name's PURCHASE1 after the first sheet and if I write 2 in inputbox then should add new sheets names are PURCHASE2,PURCHASE3 and so on . to become the final result after sheet MAIN (PURCHASE1,PURCHASE2,PURCHASE3)
so every time write value into inputbox should add and inceremnts numbers based on previous sheet name.
thanks
I have first sheet name's MAIN . what I want using input box if i write 1 , then should add new sheet name's PURCHASE1 after the first sheet and if I write 2 in inputbox then should add new sheets names are PURCHASE2,PURCHASE3 and so on . to become the final result after sheet MAIN (PURCHASE1,PURCHASE2,PURCHASE3)
so every time write value into inputbox should add and inceremnts numbers based on previous sheet name.
thanks