Hello everyone
I'm trying to export a specific sheet from an excel file, but without a result
I want to export Customers sheet to the bank sheet In all the files
Hope it is clear .. Thanks advanced for help
Hello everyone
I'm trying to export a specific sheet from an excel file, but without a result
I want to export Customers sheet to the bank sheet In all the files
Hope it is clear .. Thanks advanced for help
Last edited by Feisty2; 05-07-2018 at 04:37 PM.
can you help me please?
Last edited by Feisty2; 04-24-2018 at 03:12 PM.
All help is much appreciated.
Can someone assist or can give some direction? Thank you
Is there some code that I can use to do this for me?
you may try this, but you have to
1. open all the workbooks
2. put this code at the workbooks have "Customers" tabs and use the code at this workbook.
It need not care about the workbook name. just above two condition must be meet.
suggest u close other unrelated workbook to avoid unwanted situation.
Please Login or Register to view this content.
Hope you can learn every time you visit here.
If you still confuse on how it work, kindly ask or go to
i) Formula - Formula (Ribbon) > Formula Auditing (Section) > Evaluate Formula > Evaluate; or
ii) VBA/Code - Click F8 to see how it work step by step.
It it take care of your question, Please:
Mark tread as [Solved] [Thread Tools->Mark thread as Solved];and
Click *Add Reputation to thank anyone solved your question.
Thank you very much Mr. BoredWorker ... You are really a legend
In fact your solution is very very excellent and big step towards the ultimate aim
The original file contains code to create many closed files
How can export the customer sheet with the same formats and equations to bank sheet in all closed files
Hope it is clear .. I greatly appreciate your effort to help me
did you mind to share the code that create lot of closed file?
it is better to merge both code instead of a vba to open all workbook again.
if it sensitive to share, please give me the set of the name of closed file or how the file is created.
Thank you very much Mr. BoredWorker for your interest in the issue
I've post a file to explain my request in post 1 .. But without a response
I have updated the file After two days In an attempt to get a solution
I have "main workbook" contains a code to create many closed files depending on the column y
where I would like to put a code that enables me to export Customers file to the bank sheet in all closed files Which will be created
How can I modify or add code to proceed with this?
Thanks advanced for help
Last edited by Feisty2; 05-07-2018 at 04:35 PM.
Any help in this topic please?
I tried to apply the solution but could not do that
I welcome any ideas
Is it clear or I can not clarify my problem well??
Hope to get an answer
Best and kind regards
Last edited by Feisty2; 05-06-2018 at 08:48 AM.
Hi Feisty2,
It delay due to the weekend.
i merge the code in post#6 into the original vba sub zz()
so you can ignore the vba in post#6
I just include the code into the loop,it should be not affect other, but recommend to have a test on a copy first.
please ensure the Customer sheets.xlsm is open and don't change the name even the xlsm.
Please Login or Register to view this content.
Hi BoredWorker,
Thank you very very much for not forgetting my issue
Everything is ok except I need to Copying all the formats Customers workbook and pasting into all closed files Which will be created
I thought it is easy but after many tries I failed and I can't figure it out
Thanks again for all the great help you offered
Last edited by Feisty2; 05-01-2018 at 06:52 PM.
Any help in this topic please?
I'm really at a loss so any help would be appreciated
Thank you very much
Last edited by Feisty2; 05-01-2018 at 06:01 PM.
change the line to copy command instead of equal.
should be fit your need.
Please Login or Register to view this content.
Thank you very much Mr. BoredWorker
One last point, if possible
Many files will be created through the original file (about 150 files and probably more )
so I need to copies the contents of the source worksheet ( Customers workbook ) to all the target worksheets,such as headers/footers, margins, and Print Areas
Maybe I can not express what I want in this part,But I'm sure you understand what I mean
Thanks very much for your help
Last edited by Feisty2; 05-07-2018 at 04:34 PM.
correct me if i'm wrong.
You want to copy printing setting from "workbook customer" to another.
however, i not strong/familiar with this part,
what i can do is to copy this worksheet to the target workbook and rename the sheet.
and change the content afterward, if the content of is not same.
please let me know the all the worksheet names that needed to have the printing format if this is your need.
I am so sorry Mr. BoredWorker for being late in reply
Yes it is as well as you can do this
As for the printing format I want the print area to be set in the bank sheet in all files Which will be created
Thanks a lot for your great support all the time
Last edited by Feisty2; 05-05-2018 at 11:20 AM.
Change the this code
to:Please Login or Register to view this content.
you may change the words red font below,
refer to the source file name and sheet name respectively,
Please change based on your needs as the name may change from time to time.
Please Login or Register to view this content.
Thank you very very much Mr. BoredWorker
Yes this is the perfect code ... I know I have disturbed you..But you are great and patient
Best Regards from the deep of my heart
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks