In excel file i have multiple sheet (almost 500).
Every sheet have 100-450 rows.
I want all data in one sheet how can i do this.
I am using excel xp version.
Thanks
shubhkaran
In excel file i have multiple sheet (almost 500).
Every sheet have 100-450 rows.
I want all data in one sheet how can i do this.
I am using excel xp version.
Thanks
shubhkaran
you sure you'll have enough rows? there are only 65536 rows in your version even if you average 200 rows thats 100000 total
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
dear Martin,
sorry for late reply.
availability of rows is doesn't matter.
Can I joint 50-60 sheet in one sheet?
thanks,
skaran
yes with vba i think this is the one you want
http://msdn.microsoft.com/en-us/libr...ipleWorksheets
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks