Hi there
I need some code please where it look at what is in column M and whatever is in this column, it copies the whole row (columns A to T) onto the relevant tab. Tabs are called Team1, Team2, Team3 etc to Team10. I tried recording a macro, filtering on column M and copying to the relevant tab, but this fails as when running the report there will be occasions where a certain Team will have no data to copy across.
This will be programmed into a button which will run the report. Before it does this, I need it to clear all the data, but I take it a simple select.Sheet, ClearAllContents A:T should do that part
Many thanks
I need some code please where it look at what is in column M and whatever is in this column, it copies the whole row (columns A to T) onto the relevant tab. Tabs are called Team1, Team2, Team3 etc to Team10. I tried recording a macro, filtering on column M and copying to the relevant tab, but this fails as when running the report there will be occasions where a certain Team will have no data to copy across.
This will be programmed into a button which will run the report. Before it does this, I need it to clear all the data, but I take it a simple select.Sheet, ClearAllContents A:T should do that part
Many thanks