I am trying to get refreshed on my excel macros and VBA and need some help. I am working on a WIP schedule that I paste raw data in to the "Master" sheet. I have 4 other sheets with the Job Class as the sheet name. I have a column C in the master report with the job class as the cell data. I need a Macro to Copy the entire row to the corresponding sheet based on the cell data. I only need it to copy columns a-k because I have formulas on the template for the other columns.
Basically, if cells in column C = data, move row to sheet Data
= IND, move to sheet IND
= com, move to sheet com
=auto, move to sheet auto
I need it to paste row in corresponding worksheet starting with row 3 and only copy a through k. Any help would be appreciated.
Bookmarks