Hi
Im looking for help writing a macro that will go through all sheets in my workbook except sheet "xxx" and "yyy". In each sheet the macro should copy cell c2 to b2 in the current sheet and c7 to c2 in current sheet. The data from the next sheet should be pasted in to b3 and c3 and so forth.
Hope that makes sort of sense? any clarifications needed please let me know.
All help is highly appreciated.
Im looking for help writing a macro that will go through all sheets in my workbook except sheet "xxx" and "yyy". In each sheet the macro should copy cell c2 to b2 in the current sheet and c7 to c2 in current sheet. The data from the next sheet should be pasted in to b3 and c3 and so forth.
Hope that makes sort of sense? any clarifications needed please let me know.
All help is highly appreciated.