I have multuple sheets in one workbook. I want to consolidate F1:F47 in each of the 4 sheets and list them in coloumns in the Summary sheet. I used the code below and I am able to get the results but they are sacked into one coloumn.
Please helpPlease Login or Register to view this content.
Thanks,
Brett
Bookmarks