VBA - Push column I data down depending on F

marshy3300

Board Regular
Joined
Aug 17, 2014
Messages
54
Hi Dante,

There inst a way. Experience on my end to know that "4a, 4b" are required for 4. The pattern that does exist is the date. So how it changes from 4/07 to 27/06 and then back to 4/07 on another valid code (original post)
As for descriptions mentioning it, or codes being similar... That's not the case.
Sorry, when i changed the names/descriptions i didn't think so much focus would be on those 2 columns.

I can say that the WIP Qty 125 (product 4a) really belongs to product 5. The 25 below that belongs to product 6.
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

marshy3300

Board Regular
Joined
Aug 17, 2014
Messages
54
Thanks to you Both (Dante provided the guts and Foo with the change to date)
It does work once filtering per Job. Once i ran it I've realised Due Date also changes for priority stock. It can have a separate date than the bulk which results in pushing everything down.

I'll try to incorporate another variable into what you have provided to cater for that.

Thanks heaps guys, been amazingly helpful.
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
10,221
Office Version
2007
Platform
Windows
Thanks to you Both (Dante provided the guts and Foo with the change to date)
It does work once filtering per Job. Once i ran it I've realised Due Date also changes for priority stock. It can have a separate date than the bulk which results in pushing everything down.

I'll try to incorporate another variable into what you have provided to cater for that.

Thanks heaps guys, been amazingly helpful.

Thanks footoo for the complement, good work.

I like to help you. Thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,089,886
Messages
5,410,979
Members
403,336
Latest member
amreeves87

This Week's Hot Topics

Top