Hello everybody
I have Data sheet in which I need to loop through the range G6:G18 and if the value equals to sheet name so the related data of that row to be copied to that sheet ..
As for the header to be copied only if the cell value within the range G6:G18 equals to the sheet name
I need to keep formatting in the results. I mean the results would be formatted as the main table in Data sheet if possible
Hope it is clear
Last edited by YasserKhalil; 07-11-2015 at 05:14 PM.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Hi,
Consider unmerging row 4 and 5. With the current structure, the procedure below only copy row 4 as header.
Try,
Cheers,
Please Login or Register to view this content.
berlan
Hi,
Using array (as alternative to my Avenger team who use AutoFilter) :
Please Login or Register to view this content.
Regards
Thanks a lot for both of you Avengers
Mr. Berlan your code is perfect thanks for help
Mr. Karedog
Thank you very much for great help. Just a little point : the headers not to be copied in excluded sheets
Test it and see sheets("K")
You are welcome, thanks for the reps. Don't worry, we are always ready to eradicate crimes.
Here is the code to exclude blank sheets :
Please Login or Register to view this content.
Regards
That's perfect now
Thanks a lot for your efforts ..
Till we meet again Avengers I have to say goodbye and regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks