Creating excel book in folder and saving data to closed files

[Tacir]

Hello friends

Can I ask for your help about the attached files?
I think it is a difficult work to do.I specified the necessary explanations in the document.
I would be very happy if you can look at it at your convenient times.
Thanks in advance

[achammar]

I'm not sure I completely understand what you are wanting, but maybe this is a start. When you run the macro, it saves the data entry sheet as a new workbook in the same folder that the data entry workbook is in and names it the name that is in column R.
I assume that the names in column R will always be the same. Here is the code and a sample workbook:

Please Login or Register  to view this content.

[Tacir]

Hello Achammar

This is an approximate solution.But there is a missing situation.Data will always be entered one after the other on the created pages.Using the home page as a form, the data will always be saved in the relevant book one after the other.
The desired company will have a book in the folder and its records will be saved one under the other.In short, by using the data entry page in closed excel books, the relevant data will be saved in those kits one after another
I hope I could explain it with my broken English spelling

[achammar]

Ok, I see.
Will the name in column R always be the same in all the rows?
Will the books you want to put the data in already exist?

[achammar]

Hi again,

Ok, this probably isn't exactly what you need but I'm sure it's a lot closer. There's still a lot I don't know.
There are some requirements for this to work. We can work on changes after you see how this works.
1. Each of the books must already exist and be in the same folder as the data entry workbook.
2. This macro will always use the value in R2 to determine which workbook to put the data in.
3. This macro will put ALL the data in the data entry sheet into the closed workbook.
4. All the workbooks should only have 1 sheet to make sure the data gets put into the right sheet... (at least for now).

When you run the macro, it will take ALL the data in the sheet, and put it in the workbook with whatever name is in cell R2, and it will be after the data that is already there.

[achammar]

Tacir,

Everything in my last post still applies, but this is better and safer.

[Tacir]

Hello Achammar,

It was exactly what I wanted. In addition, can we do that ? If there is no related book in the folder, can the code add it?
For example Apple workbook ,what is not in the folder.Let the code create this excel book itself
Other than that, it was exactly what I wanted.

Best regards

[achammar]

Hello Tacir,

I'm glad that is what you needed! And adding the code to create the workbook was easy since it was already done in the first one I sent Here is a new version that will create the workbook if it does not exist.

[achammar]

Hello again,

Here's another version. It's pretty much the same as the one I just uploaded, but on this one if an error occurs it tells the user that the data may not have been copied to the closed workbook. For example, if there is nothing in cell R2 then it will error. You can change the message to whatever you want by changing what is between the quotes in the 'MsgBox' line at the bottom of the code. So either this one or the previous one should do what you want.

[Tacir]

Hello Achammar,

it was so super.It was a work that could be enriched.bless your hands.good job
If there is an additional situation later, can I declare

Best regards

[Tacir]

Achammar,

I just thought and wanted to say.
Can the transfer row be fixed to the second line of the related books?
other lines will be transferred as before
If there is a transfer line on the home page, it should be copied to the second line of the related book.

[achammar]

Hello Ticar,

I have a couple questions.
In the photo, you have all 5 lines added to the related book including the transfer line, and also the transfer line put again in row 2. Do you want the transfer line put into both places like your photo shows?
And do you want the transfer line that goes in row 2, to replace the one that is already there?

[Tacir]

Hello Achammar

each time the turnover row will be copied to the second line of the respective books
others will be copied under the full lines again
Each record will be copied below the filled rows.only the transfer rows will be copied to the second row.
If there is a transfer line, it will be copied to the second line of the related books.
If there is the word transfer, copy it to the second line of the closed books.
The transfer line will be single so it must be in the second line.

If this can happen, the program will be perfect.

[achammar]

Tricar,

Ok, try a few tests with this one. Let me know how it goes!

[Tacir]

Achammar,

I am transferring the same data several times
Transfer is located in all lines of the word line.
It should be in the second line containing the word transfer.
other lines should be copied following the filled lines.

[achammar]

Tacir,

Ok, I think I understand what you want. Try this one:

[Tacir]

Achammar,

in the first run of the code, the third line was not copied to the corresponding page (sample product1 )
looks fine on second transfer.


https://hizliresim.com/C0i3NL

[achammar]

Ticar,

It looks like you were using a blank file with just a header in it only. I didn't know you would be doing that. I'm only working on this in my spare time here at work so I don't have much time to test. But I think this one might work for you. Test it out and let me know!

[Tacir]

Hello Achammar,

I am using the data entry page.Closed excel files are created in this direction.
Transfer and excel books have been created with your codes.It seems that the process has been completed with this study.
it's super Thank you very much.
If something goes wrong, I will also forward it.
Thank you again

[achammar]

Ticar,

Good! Glad to hear that and you're welcome! If this post answered your question, would you please mark it as solved and if you're happy with the help I gave you, you could help me out by adding to my reputation in the 'Add Reputation' link at the bottom of any of my posts. I hope this works out good for you! It was a pleasure!

[Tacir]

Achammar,

I've already added it already An auto control mechanism is required based on this work.
I want to open it on a separate subject.This work was perfect.
I stated the statement of reputation as perfect

Thanks again

[achammar]

Thank you!