Solved

Macro to move data to sheet,

Posted on 2010-11-30
21
342 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:1r3o2n8
  • 13
  • 6
21 Comments
 

Author Comment

by:1r3o2n8
ID: 34241848
Hopefully gowflow will get this assignment.  ID number was 34240811 and related questions.  New question ID is 26848167
0
 
LVL 29

Expert Comment

by:gowflow
ID: 34242572
tks and noted for your trust
gowflow
0
 
LVL 29

Expert Comment

by:gowflow
ID: 34246149
Hi 1r3o2n8

Hope this is what ur looking for.
Pls let me know ur comments/changes if any
rgds/gowflow
PSBWIRE-2010.xlsm
0
 
LVL 29

Expert Comment

by:gowflow
ID: 34256079
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
 

Author Comment

by:1r3o2n8
ID: 34259707
I looked at it briefly and it worked.  I may have questions about it later.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 34260024
ok no problem anytime ... take your time :)
gowflow
0
 

Author Comment

by:1r3o2n8
ID: 34263135
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
 
LVL 29

Expert Comment

by:gowflow
ID: 34265480
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
 

Author Comment

by:1r3o2n8
ID: 34269197
I'm sorry, I can't figure it out.  Attached is my workbook for you to make the changes.
PSBWIRE-2010.xlsm
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 34270308
Here it is.
gowflow
PSBWIRE-2010New.xlsm
0
 

Author Comment

by:1r3o2n8
ID: 34274874
ID: 26657924-see this id for next question
0
 
LVL 29

Expert Comment

by:gowflow
ID: 34276584
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
 
LVL 29

Expert Comment

by:gowflow
ID: 34285030
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
 

Author Comment

by:1r3o2n8
ID: 34285290
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
 
LVL 29

Expert Comment

by:gowflow
ID: 34285375
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
 
LVL 29

Expert Comment

by:gowflow
ID: 34304254
1r3o2n8 why are you not responding ?
gowflow
0
 
LVL 29

Expert Comment

by:gowflow
ID: 34308946
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
 
LVL 29

Expert Comment

by:gowflow
ID: 34312941
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
 
LVL 29

Expert Comment

by:gowflow
ID: 34317473
Tks your intervention alias99 and appreciate your grade 1r3o2n8 and glad this issue is resolved finally.
Rgds/gowflow
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now