I was recently transfered to planning department in my company, and I found myself drowning in about 40 excel files to manipulate manually, for every small change I nedd to do for an item on a machine. That is impossible for me as it will quickly create confusion regarding what I already did in one file but didn't modify in the other/s.
What I have to work with:
1. I have a file named Pressing in real time, which I change manually as per need of the factory floor. Every machine is listed in column A of the sheet Master, and it has multiple rows, as one machine usually does two to five items in one day.
2. Then after I mannually update Pressing in real time I have to go and mannually update the specific machine workbook, which are in the same folder. For every machine there is a workbook, named with the machine mumber, so from 1 to 23. As moving more items from one machine to another may occur two or three times a day, it is very easy to mess things up, by opening, cutting, copying pasting....
What I would very badly need at the moment:
1. I will manually update the wrkbook Pressing in real time, specifically the sheet Live pressing
2. I would need a macro that I would associate to a command button on the Live pressing sheet, and when I click it it would have to copy and paste rows in the machine workbooks, based on column A criteria. SO the rows which in column A in MAster have number 17 listed, would have to be pasted into the workbook n. 17. The rows which have 19 in column A in MAster would have to be pasted in workbook named 19., and so on for every machine listed in column A
3. The master sheet, has also the column DAYS NEEDED. Now, I don't know if this is feasable. but I would also like that when the loop finds the number 2 listed in column H of the live pressing sheet , when copying the rows into the respective machine wkbks, I would like to paste them with one blank row underneath them ( because that item will take two days on the machine).
I attach the example file with fictionary data...I really hope someone can help me, as otherwise it can be very difficult not to mess up in planning the machines for the floor personnel... thank you very much in advance, any help will be highly appreciated.