I have changed the file around a bit and made each worksheet loop and filter on each other, so it is a bit more efficient as we don’t need to have cod...
It may not make any difference if you added it to a Personal Macro workbook, it really depends if I used any reference to 'thisworkbook' or if I refer...
Morning Shane The workbook you uploaded does not have the Macros i created in it - are you keeping both spreadsheet open while running the Macro? (...
Okay will look tonight when I get home as I can't download at work
Can you zip the file using 7zip? It might compress it enough to get to under 1mb. Or can you zip it, then put it in a free dropbox account and shar...
Have you run the macro in just the uploaded file? So just as it was on my PC?
I am no coder, but I noticed that in SBLay and FALays1, this line of code is present, but in FALays2, which is where it fails, it is absent The lin...
I added the LayRunOrder macro to my My Macros toolbar, but it fails at almost the last hurdle. The debugger stops on this line Worksheets("FA Lays 1")...
Try the attached - Just run the LayRunOrder Macro It is automated using advanced filter with all sheets checked against each other SBLay v FA La...
To clarify 1) If A&B&H from SBLAY appear on FA Lays 1 and/or FA Lays 2 you want it copied to Confirmed Lays 2) If A&B&H from FA Lay...
Like this? (See attached) You don't mention about bank holidays or if the calculation is every 6 months or based on 360 day/year or 365 day/year. ...
Sorry can you clarify what you actually want to happen and based on what figure? it is always best to upload an example worksheet so we can see how...
Try the attached, i have created a couple of small macros to hide/unhide/go to pages, but using the indirect formula to look up the details on each sh...
I have no idea why it has stopped working, sorry. As a work around i have put in a check on each cell in the range to test the date rather than a f...
the 6 highlighted cells are only a small selection of items dated the 8th and the 9th. I have probably misunderstood the requirements - i thought y...