LinkBack URL
About LinkBacks
(source)
I tried apply this code to my file. It is successful.Originally Posted by JBeaucaire
But, If the header contain with formula, VBA code doesn't apply on that column.
Any code have add in to allow the data copy over?
(source)
I tried apply this code to my file. It is successful.
But, If the header contain with formula, VBA code doesn't apply on that column.
Any code have add in to allow the data copy over?
Last edited by JBeaucaire; 08-31-2014 at 10:04 AM. Reason: Moved to its own thread. Please read and follow the Forum Rules, link above in the menu bar.
Assuming your row1 headers do not include any blanks, you can change this one line of code that skips blanks:
Please Login or Register to view this content.
....to this instead:
Please Login or Register to view this content.
_________________
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!)
Thanks. It is work to fit my requirement.
There is another question, if the body contain with formula in sheet 1, the data copy over is together with formula.
How to set it to copy the data from sheet 1 to sheet 2 with extract data without formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks