Hi and Welcome to ehealth
Sorry you are suffering like this.
Did they do an ultrasound or CT scan? Are you seeing a urologist?
Do you have any blood in your urine? Does the pain get worse when you increase your fluids?
It could be anything from an infection, kidney stone, obstruction (UPJ or UVJ type obstruction). I've had all of these.
I haven't been on Macrobid in years but if I remember correctly it took a few days before I began to feel a little relief. Are taking anything to help with the pain?
Keep us posted...I hope you feel better soon..