Hi Guys,
I have attached the sample data that I needed to be consolidated into 1 tab. each tab on the file have different column or field that is not match on the other tab.
I would like to have a vba to consolidate those 7 data tabs into 1 consolidated tab which is in consolidated data tab.
the scenario is every time I have added a new data set for each tab, it will add or append it on the last row available.
Hope you guys can help me on this, please.
What about the columns that are on the source tabs that are not currently on the Consolidated tab? Like
Remote Management Connection is Successful?_2
You will setup in advance the columns you want in the order you want them on the Consolidated tab?
BTW this would be a VBA project.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
albert28 
Register To Reply
Bookmarks