On my example spreadsheet attached, i need to copy column f,g and h and paste those columns below the end values of b,c and d. Then I need h1 value to be copied all the way down on the e column until the end of values. Then i need to copy all of b,c,d and e to another worksheet. I have about 8 worksheets and would like it to perform this function on each worksheet and display results one under the other.
It is kind of complicated and i don't know if it can be done or not?
I get pricing from my distributor and they send it in a weird excel format where a=LIST#, b=ITEM NO, c=DESCRIPTION, d=PRICE, then another set e=List#, f=Item no, g=Description, h=Price. What I need is the second set f,g, and h to be under b,c, and d. I don't need List#. Then I need for example sheet 1 = Mothboards at h1 to be copied all the way down on column e until the end.
Bookmarks