Macro to move data to sheet,

Attached is workbook.  Macro1 moves columns in a certain order from the sheet1(main) to another sheet (AccountNumber)(from which print preview shows  a report  (AccountNumber order).  Note arrangement of columns in sheet1(Main) and those that appear in the print preview. There are 11 columns in the sheet but only seven appear on print preview.    This first report has seven columns in a certin order, but "account number" is now in the first column to coincide with report title "...account number order.  Now I need a macro2(already done) which moves the seven columns in the same order except for first column which will be  "Benefactor" and prints as in "account Number" .  Macro1 was designed by a compatriot of yours and works very good.  **Then there will be a third reports along the same lines except it will be entitled "Originator" with "originator"  in the first column .  The "sorter" macro is called toward the end of macro1 & 2.  Notice that the sheets for rpt 2 and 3 (originator) are already established.  Above has been accomplished.  See attached file.  Now rearrange in a new macro3 the seven columns so Originator is first (to be sorted on) and the others remain in their original order.  Then a new sorter macro called "originator;  then  mcacro 3 prints  preview.
Hopefully gowflow will get this assignment.  ID number was 34240811 and related questions.
PSBWIRE-2010.xlsm
1r3o2n8Asked:
Who is Participating?
 
gowflowCommented:
Here it is.
gowflow
PSBWIRE-2010New.xlsm
0
 
1r3o2n8Author Commented:
Hopefully gowflow will get this assignment.  ID number was 34240811 and related questions.  New question ID is 26848167
0
 
gowflowCommented:
tks and noted for your trust
gowflow
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
gowflowCommented:
Hi 1r3o2n8

Hope this is what ur looking for.
Pls let me know ur comments/changes if any
rgds/gowflow
PSBWIRE-2010.xlsm
0
 
gowflowCommented:
Hi 1r3o2n8

Did you hv a chance to look at the report ? Is it what you wanted ?
Pls let me know of any changes
Rgds/gowflow
0
 
1r3o2n8Author Commented:
I looked at it briefly and it worked.  I may have questions about it later.
0
 
gowflowCommented:
ok no problem anytime ... take your time :)
gowflow
0
 
1r3o2n8Author Commented:
I'm having difficulty with tthe sorter sub.  I don't understand the sorter ("originator
") cmd.  I originally just used a sub named sorter.  Subsequently for macro 2 you added a phrase to the sorter.  In macro 3 your refer to the sorter as above and I can not get the macro to work.  It works OK in the file you sent me, but when I copy it to my workbook, there's an error or the sort doesn't work.  I can't use you your file directly, because I have made changes in mine since I sent the question.
0
 
gowflowCommented:
OK fine just do this, What I did is in the sorter sub it used to be:
Sub Sorter()
Now it is
Sub Sorter(Sht As String)

I did  this to avoid creating a new sub that do exactly the same thing so what you need to change in your code beside the sub header like above is the following line:
instead of:
With Worksheets("Account number")
replace by
With Worksheets(Sht)

and in each of the Macros:
Macro1: Sorter ("Account Number")
Macro2: Sorter ("Benefactor")
Macro3: Sorter ("Originator")

Hope above clarify
Pls let me know any other problem or difficulty. We can improve your code but I choose not to order not create waves ... its the only small change I did !!

Rgds/gowflow
0
 
1r3o2n8Author Commented:
I'm sorry, I can't figure it out.  Attached is my workbook for you to make the changes.
PSBWIRE-2010.xlsm
0
 
1r3o2n8Author Commented:
ID: 26657924-see this id for next question
0
 
gowflowCommented:
I do not understand your comment !!! I gave you the solution for your question but seems you are closing it !!
???
Moderator appreciate your help in advising what happend
gowflow
0
 
gowflowCommented:
modus_operandi:
what happens in this case if 1r3o2n8 fails to react or reply ? will the question be closed with 0 points and asker got his question answered and no objection can be posted ? Find this somewhat unfair !

On an other level asker point to his last in the thread as :
ID: 26657924-see this id for next question
Upon checking this ID it returns nothing found !!!

Can you please clarify hwat is happeneing here ?
rgds/gowflow
0
 
1r3o2n8Author Commented:
gowflow was a very good solver.  As stated above, my intentions were to give him top grades.  Sometimes it is difficult follwing your maze of rules.  Those were my intentions.  How it happened otherwise, I do not know.  Pleaser close tthis out properly giving top grades.
0
 
gowflowCommented:
Well 1r3o2n8, modus_operandi told you how to do it:

Post an objection to stop the autoclose you have created. Then select the answer that you find appropriate.
It seems crystal clear to me
Rgds/gowflow
0
 
gowflowCommented:
1r3o2n8 why are you not responding ?
gowflow
0
 
gowflowCommented:
Sorry 1r3o2n8 but seems the questions was closed with Zero point. It is not that I am after the points but seems you are not following your issues.

Ask for attention in this question (in the beginning of the question there is a ! REQUEST ATTENTION) Just click on it and explain your point clearly so moderator can fix the issue !
Rgds/gowflow
0
 
gowflowCommented:
One last comment 1r3o2n8,
If you want to make up for the mistake of this question (as moderators are not answering and guess quesiton is now closed) is to do following:

1) post again this question under a new question
2) post here as a comment the NEW ID of the question
3) I would then reply to your new quesiton with the file attached
4) You select my answer in the new question as ACEEPTED SOLUTION and rate as you wish

Rgds/gowflow
0
 
gowflowCommented:
Tks your intervention alias99 and appreciate your grade 1r3o2n8 and glad this issue is resolved finally.
Rgds/gowflow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.