Automation of copying data from other file

[Seeboo]

Hi,

I would like to automate the entire process, which unfortunately takes some time when manually copying data. I have two files:
1. "Daily Production Plan" from which data will be copied
2. "Seq plan" to which the data will be copied

Sequence plan BM01 in file "Plan seq" = column "A" and value A01 in file "Daily Production Plan"
Sequence plan BM02 = column "A" and value A02
e.t.c.

The problem is to copy the values ​​from the columns "C", "D" and depending on the day "AE", "AF" etc. from the "Daily Production Plan" file to the columns "B", "C" and "F" respectively of the file "Plan seq"
(note - the first item from the next day should also be copied (ie the item from 10.08 is pasted into lines from 09.08) but only columns "C" and "D" from the "Daily Production Plan" file to columns "B" and "C" ). And so for the following days and the rest of the tabs. (marked in yellow in the example file).

Note: If there is no comment in the "Daily Production Plan" file in the "J" column, then in the "Plan seq" file in the "H" column for a specific WO value, enter the same as in the "F" column. (marked in green in the example file)

Problem: There are 10 lines for each day, if there are too few lines in the "Plan seq" file for each day, can you write the macro so that it adds another line and then copies the data?

Both files will be in the same folder, the names can be as above (if necessary)

In the "Plan seq" file I completed the first tab with the final effect.


Thank you in advance for your help

[nankw83]

Hi Seeboo,

Is it only up to "Sequence plan BM10" = "A10" ? What about lines C01_B & C02 from Daily Production Plan ? Where should these be updated ?

[Seeboo]

Hi Seeboo,

Is it only up to "Sequence plan BM10" = "A10" ? What about lines C01_B & C02 from Daily Production Plan ? Where should these be updated ?

These two lines do not matter. Only lines #1, #2, #3,#9, #10.

[nankw83]

Try below code ... Place the code in "Daily Production Plan" file & run while "Plan seq" file is closed (just ensure to change the file path)

Please Login or Register  to view this content.

[Seeboo]

Hi, I changed the path like below, placed code but nothing happened when macro finished.

Please Login or Register  to view this content.

and I have one issue... is this possible to automatically add new day and fill data if it will appear in Daily Production Plan?
Like on picture in attachement?

[nankw83]

Hi Seeboo,

I have amended couple of things in the code as shown below. Assuming you're starting with a fresh "Plan Seq" file with 10 rows for each day, try same code with the little modifications below ... I have attached the sample files I was working with, save the file & just change the file path & try it

Please Login or Register  to view this content.

[Seeboo]

Hi nankw83,

I opened yours sample files and in code there is some runtime error in below line:

Please Login or Register  to view this content.

I am sorry, it is working. After change date format in one file macro working very good.
However I have some request:

1. Doubled WO when quantity are for two days for the same WO. Is it possible to deleted position when quatity is 0, for example for WO 1I1D0411 on 18.08.2021 (I added photo "Doubled WO.JPG")
2. Input 150pcs in cell like a added photo (screen.jpg)