I was here a few months back to to refresh this is my setup;
I have an excel file with 12 worksheets (see attachment) Within the sheet I have a column marked O/S this will feature a Y if it is outstanding and nothing if not.
I need to get it so that at the click of a button every row that has a Y is pasted into another worksheet, sorted into date order and totalled.
My problem is this; I have set the worksheets up to have 29 rows, however should the user require more then they can insert new ones, below the dashed line are formulas and nothing must be done beneith this line.
I can get a macro to autofilter the Y only columns on eacvh sheet but cant get it to copy the area as it differs from month to month.
I really need help with this and whilst I know my explanation might be a bit hard to understand would be really grateful for anyones help.
Thanks in advance