I have been tasked with building a sales tracker for my new company and I am trying include a macro to move projects that have been, 'Won' 'Lost' & 'Confirmed' into other sheets named the same and I cant get it to work, Most of the data is input manually or from drop downs.
The data starts from B5 in the 'Tracker' sheet with headers above across to U5 currently down to row 1009, However the Data in the spreadsheet is purely me testing it rather than actuall clients etc. so other than the top 10-15 lines there is no data.
Also, is it possible to move the rows to different sheets once they are moved? or will that require more macros?
Thanks in advance
The data starts from B5 in the 'Tracker' sheet with headers above across to U5 currently down to row 1009, However the Data in the spreadsheet is purely me testing it rather than actuall clients etc. so other than the top 10-15 lines there is no data.
Also, is it possible to move the rows to different sheets once they are moved? or will that require more macros?
Thanks in advance