Macro Code

Closed
Vivek - Feb 10, 2010 at 04:41 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 10, 2010 at 05:24 AM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Feb 10, 2010 at 05:24 AM
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.
0