Hi,
So I have 50 worksheets, and I want to paste link this to B15 of each worksheet: Sheet1!A15 .
I know I can do multiple pasting using shift or Cntrl, but I don't want to copy the formula exactly the way it is.
Instead, I want to paste it like a mixed cell reference,
wherein the column reference will remain "A", but the row reference will change (15,16,17,18...)
as it paste in B15 each worksheet.
Is there a faster way to do this?
Thank you for whoever will advise!
Bookmarks