I want to write such a macro that if i click the button.
if their are 50 sheet in work book and i want to copy paste all the sheets into one sheet for that how can i write for that. Main proble i am facing that when record a macro for that its not working plz help me in this issue
if each sheet has 1000rows 50 sheets will have total 50000 rows and copying into one sheet will be almost full
why do you want to do it. the purpose may be indicated so that alternate solution, if any, can be found.
what is the main sheet name and what are the fifty sheets name. Is the configuration of fifty sheets same that is the column headings same and in the same order etc.