I have an excel doc with several worksheets
1 summary sheet
The rest are all different addresses, the address in each sheet is in cell B2
I would like a formula in the summary sheet the give the address in cell B2 and be able to drag the formula down to give the addresses for each different sheet
There is a add on for excel called Kutools that does it and I'm prepared to pay for that but would rather be able to do it and understand it myself
Thanks in advance
1 summary sheet
The rest are all different addresses, the address in each sheet is in cell B2
I would like a formula in the summary sheet the give the address in cell B2 and be able to drag the formula down to give the addresses for each different sheet
There is a add on for excel called Kutools that does it and I'm prepared to pay for that but would rather be able to do it and understand it myself
Thanks in advance