I have a workbook with five sheets. on sheet one, i have filled data in colmn C. when i Run the macro it should be moved to cell D.
on the second sheet, when i run the macro the data in colmn D should move to col E and from col C to D.
on the third sheet when i run the macro the data in col E should move to col F and D to E and C to D.
It should be continued in the same way from col M and W ( entirely different items)
on the fourth sheet the macro should be forced to effect the formulea in different columns which have been feeded.
on the fifth sheet the macro should erase all the data from specified columns.
data will be entered in columns C,M and W manually by the user.
kindly provide macros to automate the process. thanks in advance. kindly see the attachment.
Bookmarks