I have a number of worksheetpage in a worksheet. Say name of the worksheet is 'X' and the worksheetpages therein are X1,X2,...etc and another set is Fit_1, Fit_2,...etc. Now all those Fit_ worksheetpages have multiple X, Y columns. I want help in writing a program which will ask me for the input worksheet name (here X) then again ask me to copy the file series (here Fit_1,Fit_2 etc),ask me for the destination worksheet name (say Y) and then copy those Fit_1,Fit_2...etc files to the worksheet Y. Can anyone please help me with this ?
AB |