Good evening Happy Campers,
I return seeking wisdom from you Excel guru's (i thought i could do it without asking and as such am close to crying lol)
So far i have a worksheet, on the tab 'raised' in reality there is hundreds of records, for now i cut it down to 5.
On tab named 'Raising' i only want to manually fill out cells A3, B3, C3 & D3, i then already have a form control button in place. (which will run the code im hoping you can do)
What i would like is vba code that will auto fill the range (H8:O8 (P8 & Q8 are seperate) and down by as many component items, as displayed in 'H14:Q19') by looking in the tab 'Raised' for the most recent order of the same Final Part Code, and show all the Component part codes in exactly the same format as shown in 'Rasied' tab.
Would anyone care to have a stab at my query? please ignore the silly descriptions, they are only for display!
Massive appreciation in advance. Galvinpaddy
Bookmarks