Hi,
I have a dropdown in cell D4. This changes a unique ID in cell D7, which calculates the rest of the sheet.
Is there a simple macro that can copy cell AD57 (the result) into a different tab for each name as the macro cycles through the list in cell D4?
Thanks for any help in advance.
I have a dropdown in cell D4. This changes a unique ID in cell D7, which calculates the rest of the sheet.
Is there a simple macro that can copy cell AD57 (the result) into a different tab for each name as the macro cycles through the list in cell D4?
Thanks for any help in advance.