Hi All,
I have a problem that I have beating my head about for some time now. I am hoping that one of you helpful lot can help resolve it.
I have a workbook with several sheets within it. The sheets all pull info from a sheet named 'Input'.
The problem I have is that if an order has several different products on it I need to separate the products on to different rows but with all the rest of the data being the same. This is probably made easier to understand with a screenshot.Doc1.pdf
As you can see on the attached under the headings 'xp10, smart windows, smart t&t windows, fixed frames, shaped frames & adeco doors' there is a number.
What I require is that these are all put on to separate rows but with all the rest of the data from the row included.
I hope someone can help.
Bookmarks