LinkBack URL
About LinkBacks
I'm looking for a method to combine data from multiple worksheets into one.
I'm looking for a method to combine data from multiple worksheets into one.
There are many ways. Tell us more ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I have a file with 120+ worksheets. Columns A&B are populated with varying rows of data. I would like to create one worksheet appending all data to on worksheet.
Your profile says Excel 2007 - is that the version you are using?
Microsoft Excel 2010
OK - I think you will need VBA for this. Shall I move this thread to the VBA section for you?
if you don't mind. although I've been a member for 5 years, I haven't used this forum much, so not too familiar with navigating or finding things. I hope I can find where you're moving it to, I do value other peoples information/tricks/methods of excel use.
thanks
Steve
Moved. You can find any of your own threads by clicking on Find latest started threads on your profile page. If you take a copy of the URL to this page, you can use that as well.
Could you please update your profile to Excel 2010? Thanks.
Create a sheet in your file called "Master" then run this VBA. Note that this is an untested code. Post back with any issues you may encounter with a full explanation.
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
That worked - thank you so much. If it's not too much bother, do you know how to extract worksheets to individual files? I don't.
Are you creating a new file or does it already exist?
Create individual files.
I have a file with 31 worksheets - each individually named and would like to separate each worksheet into it's own file (create a file for each, named the same as the respective tab).
Open this link and scroll down to the zero response. It looks like this will do it for you.
https://stackoverflow.com/questions/...book-using-vba
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks