I dont know if your macro is doing anything before this but is it on a different worksheet when it errors? the code is not fully qualified, so it will...
i have created a small macro to filter out anything older than the 1st of the previous month and attached it to your button, but if you really dont wa...
Can you attach an example workbook rather than pictures, otherwise we have to waste time recreating data
As Miguel has said we need a workbook with the code so that we dont waste time recreating data. that said, having a quick look though your code it ...
Okay that wasnt clear in the question. Do you want to count the cells that are blank (so the first row would be would be 3,17) or just the number ...
Please upload example workbook rather than pictures
try this as a starting point - ranges will need updating
Nothing attached
Please add a workbook and not pictures! it means that we have to waste time recreating a workbook Range("D2:D2" & last).Select is the issue - l...
There is an upper limit (255 characters i think), but for 100 you could use subtitute =SUBSTITUTE(B1,".navheader { display: block; width: 120px; fo...
Please add worksheet examples, it means we don’t have to waste time creating data that you already have and it ensures it is in the correct format. ...
It is so much easier if you add workbook examples instead of pictures you should be able to use an index/match or vlookup =INDEX(P1:P5,MATCH(A2,...
Nothing attached
This seems to work =IFERROR( IF(MONTH($D5)=MONTH(L4),IF($D5="",0,($G5/($E$3-$D5)*(L$4=MEDIAN(EOMONTH($D5,-1)+1,EOMONTH($E$3,0),L$4))*(MIN($E$3,EOMONT...
It add more complexity to the macro, but yes it can be done. Wouldnt it just be easier to delete the data in master download and run it again? D...