first off, this forum has been really helpful..so thank you all for that..
i have a question..i dont know of this can be done..question is i have multiple workbooks in a folder all of which have work sheets which are all similarly named... for example workbook A has sheets named abc, 123...workbook B, C and so on will have same names..so i want columns 1 , 3, 5 of all sheets with same name of all workbooks in one workbook...
Like for sheets named abc in workbooks A B C, copy columns 1 2 3 (if sheet abc is absent in one workbook ignore and proceed to the next) and put them all in a new work book...is it possible to do this...
Please help me out
i have a question..i dont know of this can be done..question is i have multiple workbooks in a folder all of which have work sheets which are all similarly named... for example workbook A has sheets named abc, 123...workbook B, C and so on will have same names..so i want columns 1 , 3, 5 of all sheets with same name of all workbooks in one workbook...
Like for sheets named abc in workbooks A B C, copy columns 1 2 3 (if sheet abc is absent in one workbook ignore and proceed to the next) and put them all in a new work book...is it possible to do this...
Please help me out
