Dear All
I have a few excel files with the same format, different colleagues in my team will key in their own data at their own file, can I merge data from these files into one single sheet without open>copy>paste?
Thank you.
Wan
Dear All
I have a few excel files with the same format, different colleagues in my team will key in their own data at their own file, can I merge data from these files into one single sheet without open>copy>paste?
Thank you.
Wan
You could try this or you could do it manually or you could use a macro but RDB merge is the fastest and easiest option usually.
http://www.rondebruin.nl/win/addins/rdbmerge.htm
Thank those who have helped you by clicking the Star * below their name and please mark your post [SOLVED] if it has been answered satisfactorily.
Did this bring you a solution you had in mind? If so could you mark this as solved and give rep to those who've helped you.
Hi JACK
Sorry for the late reply.
Thank you for your suggestion and it really work.
Wan
sweet. anytime.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks