Gordon Scott
10-03-2006, 12:02 AM
I have a workbook with a list of jobs on sheet1 and i need to transfer all the data from some of the jobs to sheet2 and some of the jobs to sheet3. Does anyone have a macro that if i put a certain number in column A next to a certain job it will transfer all the data from that row to the required sheet. Is it also possible to transfer only half the data on the row to another sheet such as column B to Column E only. Your help would be much appreciated.