Macro Code [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,
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

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
consolidating 50 sheets in one sheet can be done.

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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!