Hi.
I have a worksheet named "Base" and another called "Results" must separate for material and header so that they are separated by a line.
see sheet "Results" was all done manually.
the field 'Material' in the column is the criterion.
everything is equal stayed together and separated by a line
if someone could help me will be grateful!
Thank you!
Last edited by marreco; 06-22-2012 at 08:55 PM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Hi,
You can use a filter for this. When you copy the filtered you will need to add the headers then copy to the sheet.
There are examples for the filter on this site.
Charles
There are other ways to do this, this is but 1 !
Be Sure you thank those who helped.
IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
How about
Please Login or Register to view this content.
Last edited by jeffreybrown; 06-22-2012 at 09:16 PM. Reason: Commented code
HTH
Regards, Jeff
Hello jeffreybrown , looks great, you can review the code I will be grateful, thank you!
You are very welcome. Glad it helped and thanks for the feedback
NOTE: I update post #3 with comments in the code
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks