Help macro copying specific columns from one workbook and paste value .... in another workbook again in specific columns

[K0st4din]

Hello everyone,
I need your help on a macro to perform the following:
I have a main file (database)
in different folders have monthly excel files
1 I have USERFORM, there I have buttons.
2 Is it possible to make a macro that put it in my selected button that:
pressing it - opens the menu and navigate it alone file from which to copy the information
3 Can you ensure that the information in column B4: to include text -> to put in column C (paste value)(below the last text that is in it and be cumulative (do not want to delete the previous information)) in database file
4 Can you ensure that the information in the column F4: to include text -> to put in column E (paste value)(below the last text that is in it and be cumulative (do not want to delete the previous information)) in database file
5 Can you make sure that information from the column I4: to include text -> to put in column I (paste value)(below the last text that is in it and be cumulative (do not want to delete the previous information)) in database file
6 Can you ensure that the information in column M4: to include text -> to put in column H (paste value)(below the last text that is in it and be cumulative (do not want to delete the previous information)) in database file
7 Can you ensure that the information in column O4: to include text -> to put in column J (paste value)(below the last text that is in it and be cumulative (do not want to delete the previous information)) in database file
8 Close the file from which we get the information and are still open database file.
I would be very grateful if you could help me with this macro.
Be healthy

 

[K0st4din]

I agree with you, but could you explain to me how to get these two workbooks and download them via the site?
I have no option anywhere I can get into the site except by links and external references it?
https://drive.google.com/file/d/0BzbSYUMuiNUENnZTWUQxbkpWTFE/edit?usp=sharing
https://drive.google.com/file/d/0BzbSYUMuiNUEME44ZTZBalVsWVk/edit?usp=sharing

 

[cplmckenzie]

Okay, I have the work sheets. I will look at it over the weekend.

cplmckenze

 

[cplmckenzie]

<a href="https://drive.google.com/file/d/0Byo7jsaOs54_azJtV1RENEpTYlk/edit?usp=sharinghttps://drive.google.com/file/d/0Byo7jsaOs54_OWphVTg2MC1ISEk/edit?usp=sharinghttps://drive.google.com/file/d/0Byo7jsaOs54_YmNhcGZNaTU4Vms/edit?usp=sharing" target="_blank">https://drive.google.com/file/d/0Byo7jsaOs54_azJtV1RENEpTYlk/edit?usp=sharing
https://drive.google.com/file/d/0Byo7jsaOs54_OWphVTg2MC1ISEk/edit?usp=sharing
https://drive.google.com/file/d/0Byo7jsaOs54_YmNhcGZNaTU4Vms/edit?usp=sharing


K0st4din,

There are 3 files google drive. See the readme file first.

cplmckenzie

 

[VoG]

Cross posted Help macro copying specific columns from one workbook and paste value .... in another

In future, please provide links to all the sites where you have posted the same question.

Please read Excelguru Help Site - A message to forum cross posters

 

[K0st4din]

Hello Sir,
I absolutely agree with you and do not deny it, but please notice that over the first few days I did not get any response in a show of support. August 19, made ​​his first inquiry here on the site and only on August 21 after two days waiting, I decided to try and ask in the other website where I have listed a link where I made the first request.
Of course I've read the rules and it very carefully, but it says to mention where I made ​​the same request (regardless of what it refers) but never explained when - ie before I asked here first, or if I am asked elsewhere.
If I was asked first in the other site on 100% I'd give you a link that I made the request to another site simply because you will be (figuratively speaking - the second who ask for aid).
Please do not judge me and do not be angry with me, but after two days of waiting and there I decided to ask. I think two days is enough time to wait, because I am personally very much agree with you that everyone here helps by giving of their free time, but if you need people have to wait one month lost somehow meaning.
Again I ask you to understand. I did not put bad intent in effect.
Please excuse me again, and I wish you and ask - can you help me with this macro that I alone can not do?
Best regards

 

[cplmckenzie]

K0st4din,

I accept part of the blame also. K0st4din, since I do not know where you previously posted if you need further help you can email me at
gmckenzie444@gmail.com. I am certain there will be no issue there.

cplmckenzie

 

[K0st4din]

Thank you so much cplmckenzie
I would like to ask you one more thing that bothers me:
First - can you change a little early or exactly where we always have the same place of the file itself, I navigate to the desired file (I inserted the it in my post number 9)?

f = Application.FindFile 
   If Not f Then Exit Sub ' no file selected

Second - is there a possibility not to disturb anything in Sheet2 because my original file I have over 40 sheets and what I submitted is just an example in which each sheet is "free"?
Just copy and paste special value ....
Otherwise I thank you heartily

 

[K0st4din]

P.S - And another thing - I see that there are several macros, I think there are three. Can I copy all this and put it in a button, ie in CommandButton1_Click ()? I do ask, because I do not understand how things happen when I have several Sub & End Sub

 

[cplmckenzie]

K0st4din,

Until we are certain of the status of this post, please use the email address I gave or goto excelforum.com,I am there quite regularly.

cplmckenzie